To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103567 Issue #|103567 Summary|Sort gives unexpected results on calculated field refe |rencing its own worksheet Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|kcr
------- Additional comments from [email protected] Wed Jul 15 11:52:03 +0000 2009 ------- version of openOffice : OOO310m11 (Build:9399). A spreadsheet contains formulas in a column that refer to fields on the same worksheet. The reference to these fields may or may not include the worksheet name. If the worksheet name is not included in the cell reference, the sort works as expected. If the worksheet name is included in the cell reference, the sort gives unexpected results. In Excel, the formulas are completely mixed up. In Calc, the behaviour is also unexpected, but there seems to be a bit more structure. It is easy to reproduce : Create a spreadsheet as follows : 1;2;A1*B1;Sheet1.A1*B1 2;4;A1*B1;Sheet1.A2*B2 3;6;A1*B1;Sheet1.A3*B3 4;8;A1*B1;Sheet1.A4*B4 5;10;A1*B1;Sheet1.A5*B5 Then do a sort descending on column C or D. The first 3 columns sort as expected, the fourth column does not sort, but the references are changed. --------------------------------------------------------------------- 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]
