To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102668 Issue #|102668 Summary|Sorting causes cell references in formulas to be misca |lculated Component|Spreadsheet Version|DEV300m49 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|code Assigned to|spreadsheet Reported by|pasco
------- Additional comments from [email protected] Thu Jun 11 10:31:36 +0000 2009 ------- When sorting a selection of data which contains a formula, the cell references contained in the formula are not correctly re-calculated to account for the change in row number. To reproduce: Cell A1: 2 Cell A2: 1 Cell B1: Test Cell B2: =IF(A2=2;"Cell is two";"") Select all four cells and sort by column A ascending. Cell B2 contains "Test" which is correct. The cell references in B1 are miscalculated and now refer to A2 instead of A1, causing the cell to display "Cell is two" which is incorrect. I have attached the real-world data which I found this bug while using OOO310m11 - which you can see causes quite serious data corruption as this is my accounting data which would have been damaged had I not realised the effects due to the colouring. --------------------------------------------------------------------- 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]
