Bug 86742 - Sorting problem with cross references
Summary: Sorting problem with cross references
Status: RESOLVED DUPLICATE of bug 79441
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: All All
: high normal
Assignee: Not Assigned
Whiteboard: target:4.2.8 target:4.3.6
Depends on:
Reported: 2014-11-26 14:38 UTC by Erick
Modified: 2014-12-04 16:42 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Simple sheet that reproduces the bug (20.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-26 14:38 UTC, Erick

Note You need to log in before you can comment on or make changes to this bug.
Description Erick 2014-11-26 14:38:59 UTC
Created attachment 110064 [details]
Simple sheet that reproduces the bug

In a spreadsheet with 2 sheets, the first is the database (source) and the second  is for sorting as you wish (called references)

The second sheet makes references to the first sheet - all ok.

Now, try to delete some entries in the references sheet and them sort it. Its all broken!

I've created a simple example which demonstrates it: 

id, name, age in the source sheet

try referencing and sorting it on the references sheet and you will see.
Comment 1 Erick 2014-11-26 14:40:51 UTC
got this libreoffice from ppa
Build ID: 430m0(Build:1)

because Libreoffice has similar issues as seen on 
Comment 2 janekptacijarabaci 2014-12-01 12:38:43 UTC
Recurrent error.

Comment 5 V Stuart Foote 2014-12-01 14:15:40 UTC

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