Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

This website is an archive and is no longer active
NeoOffice announcements have moved to the NeoOffice News website


Support
· Forums
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


  
NeoOffice :: View topic - Rand() and Data Tables
Rand() and Data Tables
 
   NeoOffice Forum Index -> New Features Program
View previous topic :: View next topic  
Author Message
jpdaley
Blue Pill


Joined: Jun 02, 2007
Posts: 1

PostPosted: Sat Jun 02, 2007 7:55 am    Post subject: Rand() and Data Tables

There appears to be a problem with how the Rand() function works in conjunction with data tables (multiple.operations).
If the formula used for the data table involves a random number directly (such as NORMINV(RAND(),10,2)) then the data table will be populated with random numbers. If however, the formula used for the data table is a function of other cells involving random numbers (such as "=(C4+C5)/2" where C4 and C5 are each randomly generated numbers using NORMINV(RAND(),10,2) then the data table will NOT be populated with randomized numbers, but rather only 1 number.

The program should recalculate the entire sheet (including formulas of random numbers) for each row of a data table.

Thanks!
Jon
Back to top
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11949

PostPosted: Mon Jun 04, 2007 1:02 pm    Post subject:

This sounds like bug 2449 which is simply an OpenOffice.org bug. Have you filed a bug with OpenOffice.org?

Patrick
Back to top
Samwise
Captain Naiobi


Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France

PostPosted: Mon Jun 04, 2007 1:29 pm    Post subject:

FWIW it seemed like jpdaley and the bug reporter are the same person.
Back to top
Display posts from previous:   
   NeoOffice Forum Index -> New Features Program All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.