To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84331 Issue #|84331 Summary|sequence of operations in Calc Component|Spreadsheet Version|OOo 2.3 Platform|Sun URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|snsh
------- Additional comments from [EMAIL PROTECTED] Fri Dec 7 05:32:31 +0000 2007 ------- I use OOo 2.3 Russian version. I use to put before my students such a task. They must generate with the help of RAND() function 10 pairs of values that represent plane points coordinates (two columns). Then they have to calculate distances from zero point to each of generated points (3-rd column) and range them in increasing or decreasing order. In EXCEL this task works perfectly but in CALC it does not work. I never managed to receive right order. Then I copied values (only values) to another three columns and all worked! That is why I suppose that there is a mistake of consequence of operations. Fields in CALC cells must be renewed BEFORE they are arranged in new order and indeed they are renewed AFTER the task is completed. May be it is good for another tasks but in my case it gives a mistake. Best regards S.Shakun --------------------------------------------------------------------- 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]