Bug 134933 - Inconsistent behavior on cell update with F9 at cells filled by RANDBETWEEN() function
Summary: Inconsistent behavior on cell update with F9 at cells filled by RANDBETWEEN()...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-18 14:39 UTC by zoltan.theobald
Modified: 2020-08-16 16:44 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
A sheet on which the software produces the detailed beavior (30.98 KB, application/octet-stream)
2020-07-18 14:43 UTC, zoltan.theobald
Details

Note You need to log in before you can comment on or make changes to this bug.
Description zoltan.theobald 2020-07-18 14:39:47 UTC
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
Comment 1 zoltan.theobald 2020-07-18 14:43:01 UTC
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.
Comment 2 zoltan.theobald 2020-07-19 12:55:55 UTC
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.
Comment 3 Xisco Faulí 2020-08-03 15:34:37 UTC
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.
Comment 4 Regina Henschel 2020-08-03 17:10:11 UTC
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.
Comment 5 Roman Kuznetsov 2020-08-13 20:02:20 UTC
(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?
Comment 6 zoltan.theobald 2020-08-14 10:22:26 UTC
It does work fine on version 7.0.0.3.
Comment 7 QA Administrators 2020-08-15 04:26:28 UTC Comment hidden (obsolete)
Comment 8 raal 2020-08-16 16:44:46 UTC
(In reply to zoltan.theobald from comment #6)
> It does work fine on version 7.0.0.3.

Closing the bug.