Bug 1118983
| Summary: | Sorting columns with formulae referencing cells in other sheets broken | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Fedora] Fedora | Reporter: | Anil Seth <seth.anil> | ||||||
| Component: | libreoffice | Assignee: | Eike Rathke <erack> | ||||||
| Status: | CLOSED ERRATA | QA Contact: | Fedora Extras Quality Assurance <extras-qa> | ||||||
| Severity: | unspecified | Docs Contact: | |||||||
| Priority: | unspecified | ||||||||
| Version: | 20 | CC: | caolanm, dtardon, erack, ltinkl, mstahl, sbergman | ||||||
| Target Milestone: | --- | ||||||||
| Target Release: | --- | ||||||||
| Hardware: | Unspecified | ||||||||
| OS: | Unspecified | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | libreoffice-4.2.5.2-6.fc20 | Doc Type: | Bug Fix | ||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2014-07-19 06:03:40 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: |
|
||||||||
libreoffice-4.2.5.2-6.fc20 has been submitted as an update for Fedora 20. https://admin.fedoraproject.org/updates/libreoffice-4.2.5.2-6.fc20 Package libreoffice-4.2.5.2-6.fc20: * should fix your issue, * was pushed to the Fedora 20 testing repository, * should be available at your local mirror within two days. Update it with: # su -c 'yum update --enablerepo=updates-testing libreoffice-4.2.5.2-6.fc20' as soon as you are able to. Please go to the following url: https://admin.fedoraproject.org/updates/FEDORA-2014-8398/libreoffice-4.2.5.2-6.fc20 then log in and leave karma (feedback). Thanks. The above version solved the problem. However, I noticed one related issue. Suppose you have a cell outside the sort range which references a cell in the sort range. The cell outside the range continues to refer to the old position. E.g. In the sample example, on Sheet1, C5 has the formula =A2 (value a). After sorting the first three rows, C5 still =A2 (value b). (In reply to Anil Seth from comment #3) > E.g. In the sample example, on Sheet1, > C5 has the formula =A2 (value a). Which sample are you talking about? Neither the here attached document nor the one of the referred FreeDesktop bug has a formula in C5. > After sorting the first three rows, > C5 still =A2 (value b). Looks like that is how relative references are supposed to work. If you want sticky references use absolute addressing, i.e. =A$2 Created attachment 919005 [details]
Sorting the 3 rows on the first sheet demonstrates the problem
Sorry, I forgot to attach the modified sample sheet.
The spreadsheet showing the error now has A2 in C5 and A$2 in C6.
After sorting first 3 rows, both show the value b,
that is they still have the same formula A2 and A$2
whereas I would have expected the result to be A1 and A$2.
Sorry, it should be: The spreadsheet showing the error now has A2 in C5 and A$2 in D5. Ah, I see what you mean. That's something different though, not related to the sheet reference issue here, and apparently fixed in a later version. Upcoming 4.3 behaves differently. OK. Thanks. libreoffice-4.2.5.2-6.fc20 has been pushed to the Fedora 20 stable repository. If problems still persist, please make note of it in this bug report. |
Created attachment 917544 [details] Sorting the 3 rows on the first sheet demonstrates the problem Description of problem: A sheet references data from other sheets. If the data is sorted, the result is incorrect. E.g. Sheet 1 A & B columns c =sheet2.b3 (value 3) a =sheet2.b1 (value 1) b =sheet2.b2 (value 2) & Sheet2 A & B columns a 1 b 2 c 3 Sorting the first sheet on first column results in incorrect formulae. Version-Release number of selected component (if applicable): 4.2.5.2-1.fc20 How reproducible: Every time Steps to Reproduce: 1.Create a document with 2 sheets as above 2.Sort the first sheet on first column (ascending) 3. Actual results: a #Ref b 1 c 0 Expected results: a 1 b 2 c 3 Additional info: attaching the trivial sheet to reproduce the problem I suspect that it may be a regression because I recall using similar functionality less than a year ago.