| Summary: | Cell references are not converted from MS format to OpenFormula format when loading MS Excel created odf files | ||
|---|---|---|---|
| Product: | [Applications] calligrasheets | Reporter: | swathi <swathi.vegesna999> |
| Component: | opendocument | Assignee: | Calligra Sheets (KSpread) Bugs <calligra-sheets-bugs-null> |
| Status: | VERIFIED FIXED | ||
| Severity: | normal | CC: | mkruisselbrink |
| Priority: | NOR | ||
| Version First Reported In: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Unlisted Binaries | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
Test data is missing, without test data it is impossible to fix. Okay, can confirm the bug, loading formulas from ms excel saved odf files should go through the same conversion code as when ooxml files are loaded. Git commit ef7c0d057c1c2132df28423aa58689549f46d39d by Marijn Kruisselbrink. Committed on 17/08/2011 at 10:42. Pushed by mkruisselbrink into branch 'master'. move MSOOXML formula conversion to tables itself, as it is also needed when loading ms office created odf files. BUG: 275031 M +2 -1 filters/tables/xlsx/TestFormulaParser.cpp M +1 -1 filters/tables/xlsx/XlsxXmlWorksheetReader.cpp M +0 -1 tables/CMakeLists.txt M +51 -1 tables/Util.cpp M +0 -45 filters/tables/xlsx/FormulaParser.cpp M +0 -5 filters/tables/xlsx/FormulaParser.h M +8 -0 tables/Util.h http://commits.kde.org/calligra/ef7c0d057c1c2132df28423aa58689549f46d39d Verified in bf7bf12d4548e039e80e0dc863d3f4039745f8bd. |
Version: git checkout 09bf66c4b404f9fb8d3c2912ea77d02646e38f0a (Using KDE 4.5.5) OS: Kubuntu 10.10 Test data is in ODS format which has some conditional formatting in it. Open the same document in Calligra Tables, check the display of the results. Expected outcome: Results should be displayed properly. Actual outcome: PARSE error is displaying on the place of results. Frequency: Always.