Activity log for bug #107700

Date Who What changed Old value New value Message
2007-04-19 13:16:32 Séb bug added bug
2007-04-19 13:24:34 Philip Paquette openoffice.org: status Unconfirmed Rejected
2007-04-19 13:24:34 Philip Paquette openoffice.org: statusexplanation 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.
2009-11-16 22:58:53 Andy 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 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
2009-11-16 22:59:58 Andy openoffice.org (Ubuntu): status Invalid Confirmed
2010-05-17 21:48:18 Chris Cheney openoffice.org (Ubuntu): status Confirmed Incomplete
2010-06-11 01:32:34 Chris Cheney openoffice.org (Ubuntu): status Incomplete Expired