Bugs in fpspreadsheet demos
Original Reporter info from Mantis: wp @wpam
-
Reporter name:
Original Reporter info from Mantis: wp @wpam
- Reporter name:
Description:
When running the example excel8demo that comes with fpspreadsheet and opening the created file in Excel2007 I see that the cells with rpn formulae (E1 and F1) are imported with error - see screenshot (note that I have a German Excel, the text #WERT would be #VALUE in English). On the second tab, everything is correct (rotated text in cell A1, bold text in B1).
To test other Excel versions written I modified the writing instructions of the demo to produce Excel2, Excel5, Excel8, ExcelOOXML and OpenDocument files from the same source:
// Save the spreadsheet to a file
MyWorkbook.WriteToFile(MyDir + 'text2_Excel2.xls', sfExcel2, true);
MyWorkbook.WriteToFile(MyDir + 'text2_Excel5.xls', sfExcel5, true);
MyWorkbook.WriteToFile(MyDir + 'test2_Excel8.xls', sfExcel8, true);
MyWorkbook.WriteToFile(MyDir + 'test2_ExcelOOXML.xlsx', sfOOXML, true);
MyWorkbook.WriteToFile(MyDir + 'test2_OpenDocument.ods', sfOpenDocument, true);
These are the observations made when loading these files into Excel:
- The Excel2 file does import the formula cells prefectly and performs the calculation. It ignores the altered background color in cell D6. There is only one tab, but this is a limitation of the file format. The title of the tab is not changed (again a limitation of the file format).
- Same for Excel 5 regarding the cells. Excel5 can show the second page, but the formatting instructions are ignored. The name of the first tab is changed as defined in the source code.
- ExcelOOXML: the formula cells are empty, the background color is ignored. No rotated text, but bold font. The tab name is not changed.
- OpenDocument: formula cells empty, background color ok, no rotated text, but bold font. Tab name correct. Same observation when opened by OpenOffice.
Steps to reproduce:
Run attached modified fpspreadsheet demo, load created files into Excel (the Excel files are included in the attachment as well).
Mantis conversion info:
- Mantis ID: 25104
- OS: Windows 32bit
- OS Build: Win7
- Platform: i86
- Monitored by: » BigChimp (Reinier Olislagers), » @wpam (wp)