Apache OpenOffice (AOO) Bugzilla – Issue 84331
sequence of operations in Calc
Last modified: 2013-02-09 22:49:44 UTC
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
Hi, I'm sorry but I do not understand what the problem is. Could you attach a document showing the problem and a step by step description how to reproduce the problem. Thanks. Frank
snsh, please attach sample document. Additionally you may want to ask for help in Russian language community http://community.i-rs.ru/index.php.
Created attachment 80245 [details] Example used for confirming the defect
Confirmed on 3.4.1. I've attached a spreadsheet showing the problem. Sort on column C ("Dist"), ascending or descending order. It will be sorted correctly. The rand() function should be updated after each spreadsheet calculation. But it does not seem right for this to be triggered during or by a sort operation. There are many problems where sorting by a random column is useful. For example, it is an easy way to do a "random shuffle" in a spreadsheet.