I have an Excel 2007 Rule that formats numbers in my smart marker grid.
So basically given the below data:
Data1 | Data 2 | Data 3
Data4| Data 5 | Data 6
We have a separate section in the excel that has
2Decimal | 4 Decimal | 6 Decimal
4Decimal | 5 Decimal | 10 Decimal
We then have a rule named 2Decimal, 4Decimal, 6Decimal, that applies a certain format which applies to the Grid Data.
When we save to excel, everything works. However, if we save to CSV or PDF, the rules don't seem to be applied.
Example Conditional Formatting Rule ("Use a formula to determine which cells to format"):
Note: If I export to PDF from the working excel file, the conditional formatting is applied correctly. It's only when I save through Aspose.