Does anyone know of a way to programatically get the Conditional Formatting color of a cell, specifically from Color Scales?
Using IRange.CellStyle.Color I can get the fill color of a cell. However if the user has created a Conditional Formatting Color Scales I haven't been able to figure out how to get the cell color.
I've figured out that IRange.ConditionalFormats gives me access to the information about the conditional formats and I can interrogate each individually. I can also use the IConditionalFormat.FormatType to determine if it is a ColorScale. I was hoping that there was a property that would just provide me color, but since I don't see that I tried to go the route of calculating it.
I've attached a really simple example excel workbook that has 6 formatted cells. Using IConditionalFormat.ColorScale.Criteria I believed that I could try to compare the cell text to the Criteria's Value using the Operator and then know which color. However, even though I have 6 unique colors I'm only getting 3 criteria.
tl;dr: Is there property that provides the cell color being set by Conditional Formatting, if not is there a way to figure it out and specifically for ColorScale Conditional Formatting?
KDKesavan D Syncfusion Team July 20, 2016 07:20 AM UTC
XlsIO doesn’t have support to calculate and return color scale value of a cell and have logged feature report regarding this. A support incident to track the status of this feature has been created under your account. Please log on to our support website to check for further updates