Hi everyone, I'm using Aspose.Cells 7.2.2.0 for filling up an existing .xls template file with values coming from a database. The template contains conditional formatting for one of the columns, it uses the icon set with 3 arrows and the rule is
- red when value is >= 3 (type: number)
- yellow when < 3 and >= 2 (type: number)
- green when < 2.
In the result file everything is fine, all cell values are correct, except that the above rule changes for some un-explicable reason to the following:
- red when value is >= 0 (type: number)
- yellow when < 0 and >= 0 (type: number)
- green when < 0.
So all the settings of the rule are kept all right, except for the two numbers (2 and 3).
Has anyone else experienced this issue? Any help would be much appreciated, even if it is only confirming the issue.
Regards,
Csilla