Questions about GetDisplayStyle and GetConditionalStyle

Aspose.Cells Product Family
1

Hello:

If a cell contains conditional formatting, could be there a difference between the Style object returned by GetDisplayStyle and the one returned by GetConditionalStyle, or are they identical?

My other question is: which function should I use to get the actual style of a cell that takes into account all the scenarios including conditional formatting? I would think it is GetDisplayStyle but I want to make sure.

Thanks

2

Hi Costa,

Thank you for using Aspose products.

The Cell.GetDisplayStyle method is specifically used to get the display style of the cell if the cell is conditionally formatted. Whereas, the Cell.GetConditionalStyle method gets the conditional formatted style when the cell value fits the condition.

If the cell(s) has conditional formatting applied then it is best to use the Cell.GetDisplayStyle method to get the display style of the cell, which was computed after the cell value meets any condition.