Bug 1390776
| Summary: | [fix available] relative row references in MS Excel 2003 XML files are computed incorrectly | ||||||
|---|---|---|---|---|---|---|---|
| Product: | Red Hat Enterprise Linux 6 | Reporter: | Carl Byington <carl> | ||||
| Component: | libreoffice | Assignee: | David Tardon <dtardon> | ||||
| Status: | CLOSED WONTFIX | QA Contact: | Desktop QE <desktop-qa-list> | ||||
| Severity: | unspecified | Docs Contact: | |||||
| Priority: | unspecified | ||||||
| Version: | 6.8 | CC: | caolanm, dtardon | ||||
| Target Milestone: | rc | ||||||
| Target Release: | --- | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | If docs needed, set a value | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | Environment: | ||||||
| Last Closed: | 2017-11-06 10:14:46 UTC | Type: | Bug | ||||
| Regression: | --- | Mount Type: | --- | ||||
| Documentation: | --- | CRM: | |||||
| Verified Versions: | Category: | --- | |||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||
| Embargoed: | |||||||
| Attachments: |
|
||||||
For some reason the import filter thinks it is at row 45 when translating the formula (my guess is that it counts the Column elements in addition to Row). (In reply to David Tardon from comment #1) > (my guess is that it counts the Column elements in addition to > Row). Yeah, it's that. Fixed with https://gerrit.libreoffice.org/gitweb?p=core.git;a=commit;h=30e2171b6eac8e373e31f20de4a0cee6d5d64a08 Development Management has reviewed and declined this request. You may appeal this decision by reopening this request. |
Created attachment 1216279 [details] sample xml/xls file showing the 17 line offset error Description of problem: Libreoffice calc (and MS Excel) can load a spreadsheet from an xml file. The sample is attached. Version-Release number of selected component (if applicable): libre office version 4.3.7.2, build id 4.3.7.2-2.el6 How reproducible: Always Steps to Reproduce: 1. ooffice test.xls Actual results: Cell A28 contains contain a formula "=SUM(A35:A40)" Expected results: Cell A28 should contain a formula "=SUM(A18:A23)" Additional info: The xml file represents that formula as "=sum(R[-10]C:R[-5]C". Row 28-10 is row 18. Other production files that I am working with also have the same error. All the relative row numbers are off by 17.