Bug 127523

Summary:	Bug with ALEA() and ALEA.ENTRE.BORNES()
Product:	LibreOffice	Reporter:	KELLER <stephane.keller>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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.