Issue 84331 - sequence of operations in Calc
Summary: sequence of operations in Calc
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 2.3
Hardware: Sun Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Rob Weir
Depends on:
Reported: 2007-12-07 05:32 UTC by snsh
Modified: 2013-02-09 22:49 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---

Example used for confirming the defect (11.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-02-09 22:48 UTC, Rob Weir
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description snsh 2007-12-07 05:32:31 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
Comment 1 frank 2007-12-07 09:56:45 UTC

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


Comment 2 kpalagin 2008-01-09 15:08:47 UTC
please attach sample document.

Additionally you may want to ask for help in Russian language community
Comment 3 Rob Weir 2013-02-09 22:48:59 UTC
Created attachment 80245 [details]
Example used for confirming the defect
Comment 4 Rob Weir 2013-02-09 22:49:44 UTC
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.