Bug 62376 - EDITING: sorting rows breaks relative references
Summary: EDITING: sorting rows breaks relative references
Status: RESOLVED DUPLICATE of bug 45146
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-15 16:08 UTC by tony_silva
Modified: 2013-04-16 23:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
test spreadsheet for reproducing problem per above (10.80 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-15 16:08 UTC, tony_silva 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description tony_silva 2013-03-15 16:08:03 UTC 
Created attachment 76569 [details]
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
Comment 1 Joel Madero 2013-04-15 04:18:53 UTC 
Changing version to 3.4.4, version field is oldest version that we see the problem, not latest version that we've tested on -- we use comments for this.

As for the bug, this is a dupe I'm almost sure, just need to track down the bug number for the duplicate bug.


Thanks for reporting!
Comment 2 Joel Madero 2013-04-16 23:15:22 UTC 

*** This bug has been marked as a duplicate of bug 45146 ***