https://bugs.documentfoundation.org/show_bug.cgi?id=172989
Bug ID: 172989
Summary: EDITING: Array formula always AutoCalculated
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Disabling AutoCalculate doesn't disable the recalculation of array formulas.
My spreadsheets make heavy use of Named Expressions and array formulas (often
both). They sometime become heavy to compute, hence wanting to disable
AutoCalculate.
I hope disabling AutoCalculate would also disable computing the new values of
Named Ranges and Expressions, and not just prevent showing the result.
Steps to Reproduce:
1. Enter 0 cell A1
2. Enter regular formula =A1 in cell A2
3. Enter array formula {=A1} in cell A3
4. Disable AutoCalculate
5. Change A1 to 1
Actual Results:
Cell A2 keep its old value, as intended.
Cell A3 does get updated.
Expected Results:
Neither should get updated.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 26.2.4.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 8; OS: Linux 6.19; UI render: default; VCL: x11
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Debian package version: 4:26.2.3.2-2
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
