To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85147
------- Additional comments from [EMAIL PROTECTED] Fri Oct 24 06:37:06 +0000 2008 ------- Sorry, forgot to refer to the #REF. For the small 4 cell example, the sorted formula ending up in B2 refers to the row one above (as it did before sorting). If you move the four cells to the top right-hand corner and do the sort again, the formula ends up in B1 and the cell 'one above' is outside the grid, therefore #REF is correctly generated. This will happen to any formula when sorting moves a cell so that the relative position of the cells referred to in the formula are beyond the range of the sheet. --------------------------------------------------------------------- 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]
