https://bugs.documentfoundation.org/show_bug.cgi?id=152095
Bug ID: 152095
Summary: Enhancement request : adding 'Data - Refresh all
ranges' command
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: m.libreoff...@santonum.eu
Description:
The 'Data - Refresh range' can refresh only the data range that includes the
active cell.
One new command is needed to refresh all the workbook data ranges.
Steps to Reproduce:
1. You fill a table in Sheet1 A1:J30
2. You mirror data by the "{=$Sheet1.A1:J30}" array formula in multiple sheets
Sheet2, Sheet3, Sheet4
3. You define an automatic filter on every mirroring sheet Sheet2, Sheet3,
Sheet4
4. You modify a cell data in Sheet1
5. You want to refresh all the filtered sheets
Actual Results:
You have to activate one sheet after another and execute the "Data - Refresh
range" as many times as the sheets count.
Expected Results:
Use only the "Data - Refresh all ranges" or "Data - Refresh all workbook
ranges" manu command.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.4.1.2 (x64) / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
