Issue 67135 - Array calculation with volatile subexpression paths
Summary: Array calculation with volatile subexpression paths
Status: ACCEPTED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.0.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks: 84806
  Show dependency tree
 
Reported: 2006-07-08 00:58 UTC by wedesoi
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".