https://bugs.documentfoundation.org/show_bug.cgi?id=172763
Bug ID: 172763
Summary: Spill-operator # does not recalculate immediately when
rows increase
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Spill-operator # does not recalculate immediately when rows increase.
Steps to Reproduce:
1. Open Sample Calc File.
```
B2 is Number of Rows.
B3 is Number of Columns.
B4 is Formula "=SUM(A7#)" with "#" .
A7 is Array formula "=SEQUENCE(B2,B3)"
```
2. Insert number "5" into Cell [ B2 ].
Actual Results:
3. Value of B4 is 10.
but,
3a. Insert number "2" into Cell [ B3 ].
3b. Value of B4 is 55.
Expected Results:
3. Value of B4 is 55.
Reproducible: Always
User Profile Reset: No
Additional Info:
Reproducible in
[2026-07-11]
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: 5525f5e89b7cc4078d2ae603e4c39f3079e1d93e
CPU threads: 4; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
