Red Hat Bugzilla – Bug 491015
Incorrect formulas result when importing Excel xml spreadsheet
Last modified: 2009-03-19 08:20:16 EDT
Created attachment 335771 [details]
Small spreadsheet exhibiting the bug. See cells A7 and B7.
Description of problem: Introduces formula errors in functions when importing Excel 2003 xml spreadsheet.
Version-Release number of selected component (if applicable):
How reproducible: always
Steps to Reproduce:
1. Use Excel to create spreadsheet. Save as XML Spreadsheet (*.xml).
2. Open spreadsheet in openoffice calc.
Actual results: Any formula originally of form =SUM(B2:B6) is now =SUM(B2:B6])) which is syntactically incorrect. This error occurs for other functions also.
Expected results: Formulas should be same as original.
Additional info: the attached file Book1.xml exhibits the problem, visible in cells A7 and B7. It was created using Excel 2003 on Windows XP, but I have seen the exact same problem opening a spreadsheet created using the Apple iPhone Softalk Spreadsheet application.
This also happens with OpenOffice 3.0.1 on Windows XP. It does not happen with OpenOffice 2.4.1 on Windows XP. These are all the other versions I have handy.
This works in the 3.1 previews, so I guess the question is if its worth digging our the change for a possible backport to F-10 3.0.1
I can wait. Thanks.