Problems setting color to formula value cell


#1

Hello, I open an excel file very simple ( cell A1=1, A2=2, A3=Suma(A1:A2) )
Later I define a new style, set the background and foreground color, and assign this style to the three cells (A1, A2 and A3).

When I save the file I see A1 and A2 have the color ok, but A3 don’t; …why?

If I set the formula Suma(A1:A2) at runtime in the code it works fine ( e.Worksheets.GetAt(0).Cells().GetAt(2, 0).Formula = "=Suma(A1:A2) )



Here is the code:

Dim e As New Excel()
e.Open(“base.xls”)

Dim s As Style = e.Styles.GetAt(e.Styles.Add())
s.BackgroundColor = Color.Beige
s.ForegroundColor = Color.Yellow

e.Worksheets.GetAt(0).Cells().GetAt(0, 0).Style = s
e.Worksheets.GetAt(0).Cells().GetAt(1, 0).Style = s
e.Worksheets.GetAt(0).Cells().GetAt(2, 0).Style = s

e.Save(“test.xls”, FileFormatType.Default)



#2

This is a bug. I have fixed it. You will get the new release soon.

Thank you very much.