Bug 135855 - Apply Recalcule F9 to the selection rather than the active cell
Summary: Apply Recalcule F9 to the selection rather than the active cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Selection
  Show dependency treegraph
Reported: 2020-08-17 20:07 UTC by gmildner
Modified: 2023-05-19 15:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description gmildner 2020-08-17 20:07:14 UTC
The introducion of RAND.NV() is fine! However it´s behaviour that it can be triggered by F9 only when the focus is on the cell conaining RAND.NV() is i.m.h.o. a bit too special. I expected (and tried) marked- as well as named cell-ranges which contained
several RAND.NV()s with the focus on arbitrary cells within these ranges, but only the specified cell was recalculated.
I´d suggest to extend RAND.NV()-functionality as described above. While giving more flexibility, this would not spoil the
original function.
Thanx and best regards,

Steps to Reproduce:
1.easy, see description

Actual Results:
RAND.NV() is not recalculated on F9
(no bug, is as documented)

Expected Results:
obvious, see above

Reproducible: Always

User Profile Reset: No

Additional Info:
OS is Win 10
Comment 1 gmildner 2020-09-07 13:19:46 UTC
The extended funtionality of RAND.NV() would allow to change calculations or
entries into a spreadsheet without changing one or more given SETS of rnd-numbers.
This whole SET would be updated on F9 only when the focus is on a
a cell which is inside a the named cell-range containg the RAND.NV() functions.
This would be useful for simulation of stock-quotes.
Comment 2 Eike Rathke 2021-07-26 09:35:14 UTC
This is nothing RAND.NV() specific though. F9 recalculation acts only on the currently active cell, regardless of selection (apart from volatile functions and pending dependencies that it also recalculates). I thought there was already an RFE for that but couldn't find it.
Comment 3 Heiko Tietze 2021-08-16 09:39:30 UTC
Andreas, I thought you might be interested in this.