[Libreoffice-bugs] [Bug 127831] New: recalculate vs. random functions in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127831
           Summary: recalculate vs. random functions in Calc
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: turbobeholder at mail.ru

Description:
In 6.0 and 6.1 RANDBETWEEN(X,Y) generates a new value only when its own cell is
recalculated (F9), while RAND() generates a new value when any cell is updated
by F9 or even a value entered in any cell.
In 6.3 RANDBETWEEN(X,Y) also generates when any cell is updated.
Could this behavior be set in options, please?
It's not always convenient to randomize everything (and then recalculate
everything downstream) all the time; explicit refresh allows to play with
constants vs. a given set of random values for debugging formulae, and/or
generate only for a specific part of the table.
Also, needless recalculation as such probably isn't good for performance on
huge spreadsheets.

I occasionally defined small cell groups to be randomized, via constructs like
A3«="Group 1"», B3 «=RANDBETWEEN(1,10)+0*LEN($A$3)». It's a roundabout way to
do things, of course, but controllable, easy to paste around and transparent
(thanks to cell highlight).

Steps to Reproduce:
1. Enter '=RANDBETWEEN(1,10)' into one cell, '=RAND()' into another.
2. Enter some value into third cell.
3. Recalculate (F9( the third cell.

Actual Results:
Values are recalculated even when a given cell or its dependencies didn't
change.

Expected Results:
Values are recalculated when a cell or any of its dependencies change.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190928/343c5e48/attachment.html>