It seems that the version 2.5.3 has a problem when saving an Excel 2003 file.
I have a really simple Excel file (called “test-2003.xls”), which contains in the cell C2 the value “=B2” (i.e. the C2 cell contains the same thing as the cell B2).
In my code, I put a value in B2 cell, using the following code:
Workbook book2003 = new Workbook();
Then, I open the “output.xls” file, and I see “foo” in B2, but I see “0” in C2, which means that the C2 cell has not been “refreshed” during the save process.
- If I define the file format type (book2003.save(“output.xls”, FileFormatType.EXCEL97TO2003);), it does not work neither.
- If I use the 2007 Excel format (.xlsx), the problem does not occur.
- If I use Apose Cells 220.127.116.11, the Excel 2003 format is correctly handled.