Bug 127523 - Bug with ALEA() and ALEA.ENTRE.BORNES()
Summary: Bug with ALEA() and ALEA.ENTRE.BORNES()
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-09-12 12:06 UTC by KELLER
Modified: 2019-09-13 14:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

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

Note You need to log in before you can comment on or make changes to this bug.
Description KELLER 2019-09-12 12:06:32 UTC 
With LibreOffice 6.1.6.x:

In cell A1, I enter the formula:
=ALEA()
In cell A2, I enter the formula:
=ALEA.ENTRE.BORNES(1;6)

If I press Ctrl+Shift+F9, ALEA() and ALEA.ENTRE.BORNES(1;6) generate a new random number.
If I press F9, ALEA() generates a new random number and not ALEA.ENTRE.BORNES(1;6).
This is the normal and usual behavior of calc.


Since LibreOffice 6.2.x.x:

In cell A1, I enter the formula:
=ALEA()
In cell A2, I enter the formula:
=ALEA.ENTRE.BORNES(1;6)

If I press Ctrl+Shift+F9, ALEA() and ALEA.ENTRE.BORNES(1;6) generate a new random number.
This is the normal and usual behavior of calc.
If I press F9, ALEA() and ALEA.ENTRE.BORNES(1;6) generate a new random number.
This is not the normal and usual behavior of calc.
Comment 1 m_a_riosv 2019-09-13 14:40:58 UTC 
This was changed https://bugs.documentfoundation.org/show_bug.cgi?id=102257, so both functions has the same behavior.