To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101845 Issue #|101845 Summary|Sorting fails for cells with links to different sheets | (Unexpected results) Component|Spreadsheet Version|OOo 3.1 RC2 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|robertpopa22
------- Additional comments from robertpop...@openoffice.org Tue May 12 18:23:47 +0000 2009 ------- 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! --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org