Bug 491015
| Summary: | Incorrect formulas result when importing Excel xml spreadsheet | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Robert K. Moniot <moniot> | ||||
| Component: | openoffice.org | Assignee: | Caolan McNamara <caolanm> | ||||
| Status: | CLOSED RAWHIDE | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||
| Severity: | medium | Docs Contact: | |||||
| Priority: | low | ||||||
| Version: | 10 | CC: | caolanm | ||||
| Target Milestone: | --- | ||||||
| Target Release: | --- | ||||||
| Hardware: | All | ||||||
| OS: | Linux | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2009-03-19 09:00:51 UTC | Type: | --- | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
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. |
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): openoffice.org-calc-3.0.1-15.3.fc10.i386 How reproducible: always Steps to Reproduce: 1. Use Excel to create spreadsheet. Save as XML Spreadsheet (*.xml). 2. Open spreadsheet in openoffice calc. 3. 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.