Issue 84331

Summary: sequence of operations in Calc
Product: Calc Reporter: snsh <spirits07>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact: Rob Weir <robweir>
Severity: Normal    
Priority: P3 CC: don.troodon, issues, kpalagin
Version: OOo 2.3   
Target Milestone: ---   
Hardware: Sun   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: 3.4.1
Developer Difficulty: ---
Attachments:
Description Flags
Example used for confirming the defect none

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
S.Shakun
Comment 1 frank 2007-12-07 09:56:45 UTC 
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
Comment 2 kpalagin 2008-01-09 15:08:47 UTC 
snsh,
please attach sample document.

Additionally you may want to ask for help in Russian language community 
http://community.i-rs.ru/index.php.
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.