To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82015 Issue #|82015 Summary|Cell's references lost when ordering Component|Spreadsheet Version|OOo 2.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|pjimenezo
------- Additional comments from [EMAIL PROTECTED] Thu Sep 27 12:30:29 +0000 2007 ------- When ordering rows that in some of the cells contain references to cells that are within the ordered rank, those references correctly do not stay, without mattering if they are absolute or relative. For example: ________________________ | | A | B | C | ------------------------------------------ | 1 | Australia | = C3 | valor1 | ------------------------------------------ | 2 | Canada | = C1 | valor2 | ------------------------------------------ | 3 | Belgium | = C2 | valor3 | ------------------------------------------ If we ordered alphabetically by the column "A", we obtain: ________________________ | | A | B | C | ------------------------------------------ | 1 | Australia | = C3 | valor1 | ------------------------------------------ | 2 | Belgium | = C1 | valor3 | ------------------------------------------ | 3 | Canada | = C2 | valor2 | ------------------------------------------ where one sees that the formulas of column B have not moved when ordering. If we had worked with absolute references, after ordering we had obtained exactly the same, the formulas remain where they are. On the other hand, if the references are external to the rank that is ordered, everything goes well, but if soon we ordered that other rank of cells, the references return to disorder themselves. --------------------------------------------------------------------- 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]
