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
I forgot before step #3 to reproduce : - Define named range on every sheet
CCing UX for their opinion.
I would be careful to modify data in non-visible sheets, in general. But for this particular case, if a) the data has changed, and b) the action is run intentionally via the extra command, it makes sense to have this convenience function.
It would be great if we could refresh all ranges in only one operation. On Stéphane's example, other sheets are not hidden. The subject is why refresh range by range and not sheet by sheet or for the whole workbook, when several ranges (on several sheets) depend on the same data ? I also agree with Heiko's comment. Care must be taken with this type of command. But we could ask for confirmation before refresh all ranges. Of course, the current function would still be relevant, but it would be a really nice improvement. Thanks Claire