To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101653 Issue #|101653 Summary|Sorting a table does not work properly Component|Spreadsheet Version|OOO310m9 Platform|Other URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|code Assigned to|spreadsheet Reported by|phildetroy
------- Additional comments from phildet...@openoffice.org Thu May 7 17:20:53 +0000 2009 ------- Misfunction in new OOO 3.1 with an XLS file created by excel and previously edited with OOO 3.0 The table is wide (53 columns, most with formulas and 500 lines). I use to select the relevant columns and sort with option "range includes column labels". Formulas are no longer updated properly according to new line position =IF(AC28>0;ROUND($Coeff.$B$19*(101-1000*LOG(AC28/$Coeff.$D$19));0);0) remains AC28 when line is sorted to line 2, should become AC2 --------------------------------------------------------------------- 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
