Issue 101845 - Sorting fails for cells with links to different sheets (Unexpected results)
Summary: Sorting fails for cells with links to different sheets (Unexpected results)
Status: CLOSED DUPLICATE of issue 101690
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1 RC2
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-12 19:23 UTC by robertpopa22
Modified: 2009-05-13 17:18 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Sort problem, example 1.ods (24.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-12 19:25 UTC, robertpopa22
no flags Details
Sort problem, example 2.ods (16.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-12 19:25 UTC, robertpopa22
no flags Details
Sort problem, example 3.ods (37.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-12 19:25 UTC, robertpopa22
no flags Details
Sort problem, example 4.ods (37.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-12 21:04 UTC, robertpopa22
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description robertpopa22 2009-05-12 19:23:47 UTC
In the ods attached there are shown 2 different behaviours:

1 - the normal expected result is shown in example 1. If you sort the range
Timp.A1:G30 by column G for example, everything is ok, the formulas in column F
are kept intact.

2 - in example 2, identical to example 1, on column G we make a reference to
$Parametri.$B$3 instead of $N$2 (in the same sheet). If you sort now the same
range Timp.A1:G30 by column G the formulas in column F are mixed up after sorting...
You can check the same behaviour in the 3rd example, by sorting range
Salarii.A2:AD29, by column AD. You will have unexpected results on columns: X,
U, T, P, o, N, L, k, j, f, i. All these columns have in comon the reference to
another sheet ($Parametri.$d$24 for example)

So, the conclusion is that the sort doesn't modify corectly the references in
formulas containing also refrences to other sheets, but work well for refrences
in the same sheet.

This was tested with the release 3.1, and I haven't seen it on previous releases.

Please help!
Comment 1 robertpopa22 2009-05-12 19:25:04 UTC
Created attachment 62210 [details]
Sort problem, example 1.ods
Comment 2 robertpopa22 2009-05-12 19:25:26 UTC
Created attachment 62211 [details]
Sort problem, example 2.ods
Comment 3 robertpopa22 2009-05-12 19:25:50 UTC
Created attachment 62212 [details]
Sort problem, example 3.ods
Comment 4 robertpopa22 2009-05-12 19:47:22 UTC
We have to switch back to release 3.0.1 wich works well in this situation.

Please help!
Comment 5 robertpopa22 2009-05-12 21:04:41 UTC
Created attachment 62213 [details]
Sort problem, example 4.ods
Comment 6 robertpopa22 2009-05-12 21:08:12 UTC
In example 4 we have submited the file reworked with 3.0.1 release.

Also here there were some minor issues. But generally the sort works!

**Please use example 4 instead of example 3, for testing on 3.1**
Comment 7 niklas.nebel 2009-05-13 17:17:37 UTC
Same as 101690.

*** This issue has been marked as a duplicate of 101690 ***
Comment 8 niklas.nebel 2009-05-13 17:18:02 UTC
closing duplicate