For a cell that uses conditional formatting data bar or color scale how can I access the condition that is applied?
Basically, I want to access the background color if a color scale has been used, or the information stored in the data bar if a data bar was used.
A while ago I posted this message:
How to get the icon used in the conditional formatting of a cell
The aspose team has been extraordinary and they provided the ConditionalFormattingResult class which contains the icon in the ConditionalFormatting icon, if an iconset was used to format a cell.
I think the ConditionalFormattingResult class can be extended further to provide a DataBar object or a ColorScale object in case those are used to format the cell. Is it possible?
It seems that multiple visually different conditions can be applied to a cell. See the attached spreadsheet (cell B1). Ultimately I think the api should provide a way of finding which condition is true and was applied to the cell…
The issues you have found earlier (filed as CELLSNET-41740) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.