Issue with Gradients

[ccx004B]

I found another odd thing ImportExcel when creating and copying gradient settings in a cell. The following code demonstrates this:
`
$XL = Open-ExcelPackage -Path "example.xlsx" -Create
$Sheet = Add-WorkSheet -ExcelPackage $XL -WorksheetName "Example"

$Sheet.Cells["A1"].Style.Fill.Gradient | gm | ft

$Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Setcolor("BLUE")
$Sheet.Cells["A1"].Style.Fill.Gradient.Color2.Setcolor("GREEN")

write-host "RGB= " $Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Rgb
write-host "Top= " $Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Top
write-host "Bot= " $Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Bottom
write-host "Lef= " $Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Left
write-host "Rig= " $Sheet.Cells["A1"].Style.Fill.Gradient.Color1.Right

Close-ExcelPackage -ExcelPackage $XL -Show
`

Running this will create a blank spreadsheet with one cell (A1) filled with a gradient going from Blue to Green. However, reading back the values that have been set gives nothing as shown by the 4 write-host commands. I have checked all the other properties of "Style.Fill.Gradient" and they are all NULL or blank. This means it is not possible to copy gradients from one set of cells to another but perhaps there is some other way.

Any thoughts would be appreciated.

[dfinke]

Thanks for the issue @ccx004B don't know off the top of my head. This is using EPPlus at its core. Feels like an issue in their library. I have not explored the gradient/color aspects.

[dfinke]

@ccx004B I didn't review what the Copilot coding agent came up with, take a look, see if it helps.

[ccx004B]

Dear Doug, Sadly, it didn’t really help. All it does is set Color1 and Color2 to $NULL and then return that. You are right; it is an issue in the EPPlus library but it is quite strange. I had a look at the source code of the last free version of EPPlus (4.5.3.3) and the methods in ExcelGradientFill.cs are all of the form public ExcelFillGradientType Type { get { return ((ExcelGradientFillXml)_styles.Fills[Index]).Type; } set { _ChangedEvent(this, new StyleChangeEventArgs(eStyleClass.GradientFill, eStyleProperty.GradientType, value, _positionID, _address)); } } As you would expect. However, the two Color methods are of the form: public ExcelColor Color1 { get { if (_gradientColor1 == null) { _gradientColor1 = new ExcelColor(_styles, _ChangedEvent, _positionID, _address, eStyleClass.FillGradientColor1, this); } return _gradientColor1; } } In other words they have a “getter” but not a “setter” which is the exact opposite of what I’ve found which is that I can set the values but not read them. Oh well, such is life. It is not important to me at least so it is probably one for the back burner unless other people have an issue with it. Thanks for looking anyway. Best wishes….. Colin From: Doug Finke ***@***.***> Sent: 22 September 2025 12:34 To: dfinke/ImportExcel ***@***.***> Cc: ccx004B ***@***.***>; Mention ***@***.***> Subject: Re: [dfinke/ImportExcel] Issue with Gradients (Issue #1720) dfinke left a comment (dfinke/ImportExcel#1720) <#1720 (comment)> @ccx004B <https://github.com/ccx004B> I didn't review what the Copilot coding agent came up with, take a look, see if it helps. — Reply to this email directly, view it on GitHub <#1720 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AVBL56PBRACD2OUIX2N6CDT3T7NEJAVCNFSM6AAAAACG5PQ6SWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTGMJYGQZTAOJZGY> . You are receiving this because you were mentioned.Message ID: ***@***.***>