To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=61936 Issue #:|61936 Summary:|no sort with simple references but with full |references Component:|Spreadsheet Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P4 Subcomponent:|code Assigned to:|spreadsheet Reported by:|regina
------- Additional comments from [EMAIL PROTECTED] Sat Feb 11 13:49:03 -0800 2006 ------- I use German OOo2.0.1 on German WinXP Home. There are three tables in the attached document. The first one has some simple data. The second table, the green one, contains in column A references like “=A2” and in column B the RANK-Function like “=RANG(B2;Liste), where “Liste” is a named range of the data in Column B of the first table. The third table, the yellow one, contains the same as the green table but the references contain also the name of the sheet. So you have “Tabelle1.A2” and “=RANG(Tabelle1.B2;Liste)”. Now mark the green table. Use Data - Sort... Notice that it not possible to sort the rows of the table, neither with criterion in column A nor with criterion in column B. Now do the same with the yellow table. It will sort fine. Expected behavior: Sorting is also possible, if you use the short form of the references. --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]