https://bugs.freedesktop.org/show_bug.cgi?id=62376
Priority: medium
Bug ID: 62376
Assignee: [email protected]
Summary: EDITING: sorting rows breaks relative references
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.1.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 76569
--> https://bugs.freedesktop.org/attachment.cgi?id=76569&action=edit
test spreadsheet for reproducing problem per above
Sorting rows breaks relative references in formulas. The problem
appears when running either LibreOffice 4.0.1.2 or 3.4.4 on a MacBook
Pro 17 running Mac OS 10.7.5. The test file was created with
LibreOffice 3.4.4.
Steps to reproduce, w/ current and expected behavior:
1. open LibreOffice4.0.1.2_Sort6-13KeyAUBreaksBH-BL13RelativeRefs.ods
2. confirm original values in cells AU6 and AU13 are 82 and 153,
respectively
3. select cell BH13
- confirm original formula: =IF(BH6<>"",BH6,"")
4. select rows 6 through 13
- "Data | Sort..."
- sort key 1: column AU
- confirm rows 6 and 13 correctly moved to rows 10 and 12,
respectively
- e.g., values in cells AU10 and AU12 are 82 and 153, respectively
5. select cell BH12
- NOTE INCORRECTLY ADJUSTED RELATIVE REFERENCES: =IF(BH5<>"",BH5,"")
- should be: =IF(BH10<>"",BH10,"")
Operating System: Mac OS X
Version: 4.0.1.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
