To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101690 Issue #|101690 Summary|Sort in CALC mixes up references to cell identifiers Component|Spreadsheet Version|OOO310m11 Platform|Unknown URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|patb
------- Additional comments from [email protected] Fri May 8 15:29:25 +0000 2009 ------- OOO310m11 I'm bringing forward a spreadsheet from Calc Open Office 3.01 into Open Office 3.1 that I downloaded last night and updating my personal accounts for last few days. Column A is date. Other columns have references in them. References are like in cell BeforeSort.F11 have =ROUND(0.05*E11;2) and E11 is a reference. Sort by date, column A, and find that references are all screwed up. Some are sorted as expected - for example cell AfterSort.G10. Some are messed up - for example AfterSort.F10 is =ROUND(0.05*E11;2) - AfterSort.F10 should be =ROUND(0.05*E10;2) Another example Aftersort.N11 = =IF(LEFT($C7;3)="rec";$I7;0) I think you get the idea. I'll send the spreadsheet in email since only use this occasionally and don't see where to paste it. --------------------------------------------------------------------- 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]
