Issue 67135

Summary: Array calculation with volatile subexpression paths
Product: Calc Reporter: wedesoi <wedesoi>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.3Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 84806    

Description wedesoi 2006-07-08 00:58:32 UTC
Perhaps someone could clarify a situation for me. I am using rand() in an 
array calculation with an array variable. 
=A1:A100+3*RAND() 
The variable is just a random set of integers. However rand() only seems to 
excute once since all the resulting numbers in the array have the same 
trailing digits. This is not what I would have expected.  
  I received a reply in the forum stating that it is a known issue and that I 
could try submitting it here.
Comment 1 gercokees 2006-07-12 09:23:25 UTC
Hi,
Can you please attatch a file in wich the error occurs? Otherwise i do not fully
understand.
Thanks
Gerco-Kees
Comment 2 frank 2006-07-27 13:38:26 UTC
Hi Eike,

thought this one is a double but could not find an Issue. So one for you.

Frank
Comment 3 ooo 2006-08-02 15:16:54 UTC
Accepted. If the formula is entered as an array formula the single cells should
have different results for the +RAND() expression. Easiest test case: in A1:A3
enter the value 0 in each cell, and in B1:B3 enter =A1:A3+RAND() as array
formula (close with Ctrl+Enter). Result is three times the same value, should be
different values instead.
Comment 4 Martin Hollmichel 2007-11-09 16:52:52 UTC
change target from 2.x to 3.x according to
http://wiki.services.openoffice.org/wiki/Target_3x
Comment 5 Marcus 2017-05-20 11:11:20 UTC
Reset assigne to the default "issues@openoffice.apache.org".