I am using Aspose.Cells v.7.4.2 and am having a problem with the rendered output of a worksheet with a number of conditional formatting rules used to control the color of the cell based upon the cell's value.
The conditional formatting worked fine except for the case when the cell value is set to Zero. Then it appears as though the rule engine is not engaged. If I open the spreadsheet in Excel and type in the Zero value, I get the red background as expected. However, when the cell value is set programmatically, the background does not change.
I have attached a zipped file containing the VB code snippet, source data file, spreadsheet and PDF of the rendered output.