I have an Excel file (test.xlsx), which contains some cells with conditionnal formatting. Basically, the cell displays an arrow that depends on the possible cell values, which are -1, 0 or 1. As you can see in the “before.jpg” screenshot, the conditions are set on “Number” type.
If I just open and save the Excel file using Aspose (out.xlsx), the conditions have been changed to the type “Percent” type, as shown in the “after.jpg” screenshot.
The code used to save is simply:
Workbook book = new Workbook();
What is wrong here?
The problem may be in the Excel template, as this problem may not always appear if I recreate a new XLSX file from scratch.
Thanks in advance.
Aspose Cells v126.96.36.199, Java 1.6, Excel 2007.
The above link to the new release is not working. Please download it from this link: Aspose.Cells for Java v188.8.131.52.
I’ve tested my report with the new version, and the problem is now solved. Thanks !