Hi,
I’m trying to get the color of a negative value from a specific cell that is formatted with Number/Currency where the value is rendered in red if negative (as shown in the attached picture).
I’ve tried the following API:
cell.GetDisplayStyle().ForegroundColor = Collor [Empty]
cell.GetStyle().ForegroundColor = Collor [Empty]
cell.GetDisplayStyle().Font.Color = Collor [A=0, R=0,G=0, B=0]
cell.GetStyle().Font.Color = Collor [A=0, R=0,G=0, B=0]
cell.GetDisplayStyle().ForegroundThemeColor = null
cell.GetStyle().ForegroundThemeColor = null
cell.GetFormatConditions() = null
cell.GetConditionalStyle() = null
cell.GetDisplayStyle().Number = 0
cell.GetStyle().Number =0
I’ve opened the workbook and saved it as PDF and the cell is rendered with red color but there is no information in the API that the cell is going to be red.
Is there a way to get this color from the Aspose API?
Thanks.