[Libreoffice-bugs] [Bug 134933] New: Inconsistent behavior on cell update with F9 at cells filled by RANDBETWEEN() function

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134933

            Bug ID: 134933
           Summary: Inconsistent behavior on cell update with F9 at cells
                    filled by RANDBETWEEN() function
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: zoltan.theobald at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200718/e7c72fdf/attachment-0001.htm>