Description: The software changes behavior on cell update by F9. Some cells filled by RANDBETWEEN() functions are getting updated unexpectedly at some cases. The behavior changes after full sheet update by Ctrl+Shift+F9. It happens only at certain circumstances. Creating a sheet produces the error is not trivial. (at least not yet for me) Steps to Reproduce: 1.open the attached file test_sheet.ods 2.select a cell in the F column filled by RANDBETWEEN() function 3.press F9 : the whole F column will update 4.select a random cell which is not in the F column 5.press F9 to update the cell: the whole F column will update as well 6.press Ctrl+Shift+F9 7.select any cell from anywhere but the F column 8.press F9: the behavior changed back to normal Actual Results: The RANDBETWEEN() functions in the column F got updated unexpectedly Expected Results: The selected cell and the related cells should update only Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: Version: 6.0.7.3 Build ID: 1:6.0.7-0ubuntu0.18.04.10 CPU threads: 4; OS: Linux 5.3; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group
Created attachment 163239 [details] A sheet on which the software produces the detailed beavior This is a simplified version of the file I started tho experience the problem.
According to Bug 127831 i realized that my expectations was wrong. I guess the values of RANDBETWEEN() functions should be updated every time. Even if it does not make any sense at all (since the cells using these values are not getting updated), we can live with it. In this case the problem is (and the source of the confusion) that sometimes these updates are failed to happen. That is the inconsistency: the change of behavior. At step 5. all the cells in the column F is been updated, while at step 8. no cells from column F is been updated. Here column F is the only column containing the RANDBETWEEN() function.
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
The behavior of the RANDBETWEEN and RAND functions was changed, so that the value always changes with simple "Recalculate" (F9). For to keep the current value when pressing F9 and only change it with "Recalculate Hard"(Ctrl+Shift+F9) the new functions RANDBETWEEN.NV and RAND.NV were implemented. They will be available in 7.0. Please try it with the release candidate.
(In reply to Regina Henschel from comment #4) > The behavior of the RANDBETWEEN and RAND functions was changed, so that the > value always changes with simple "Recalculate" (F9). For to keep the current > value when pressing F9 and only change it with "Recalculate > Hard"(Ctrl+Shift+F9) the new functions RANDBETWEEN.NV and RAND.NV were > implemented. They will be available in 7.0. Please try it with the release > candidate. Regina, can we close it as WFM?
It does work fine on version 7.0.0.3.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to zoltan.theobald from comment #6) > It does work fine on version 7.0.0.3. Closing the bug.