random numbers
Bug #107700 reported by
Séb
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
openoffice.org (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
Hello,
I'll tried to speak approximately in English...
The random numbers' generator (ALEA in French, RADN in English, I suppose) is not correctly configured.
Random numbers must be in [0,1[ interval, but open office gives numbers of [0,1].
For a lot of people it's a detail, but when you want to teach simulation with kids, you may obtain a 7 on a die (un dé en français).
Can you change the source please ?
Sincerely your,
Sébastien DUMORTIER
To post a comment you must log in.
With other functions, you should be able to tweak it to your needs.
For example, to obtain the dice side #, you might want to use:
=TRUNC(RAND()*6)+1
RAND() * 6 -> between 0,6
Trunc -> 0,1,2,3,4,5
+1 -> 1,2,3,4,5,6
The odds of arriving exactly at 1.00000000000000 are 0.
Hope this helps.
Rejecting.