https://bugs.documentfoundation.org/show_bug.cgi?id=168013
Bug ID: 168013
Summary: Cannot set SUBTOTAL cell range in advance
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I used to use formulas like =SUBTOTAL(9;G5:G99999) and =SUM(G5:G99999) to count
all amounts in column, with and without filters, respectively. Using row number
99999 might look ambiguous, but it's just "somewhere far far away, definitely
below the end", and it was working well--until now.
After update to 25.8 release, LibreOffice Calc always automatically changes my
=SUBTOTAL(9;G5:G99999) formulas to something like =SUBTOTAL(9;G5:G6512) where
6512 is the last row number on the sheet. Thus, after adding next row, I have
to change the range by hand. That is super annoying, broke existing sheets and
is not error-proof.
Steps to Reproduce:
1. Start with empty sheet
2. Put some numbers to cells A2, A3, A4, A5 (e.g., 10, 20, 30, 40)
3. Put formula =SUBTOTAL(9;A1:A99999) to cell A1
Actual Results:
The formula in A1 is changed to =SUBTOTAL(9;A2:A5)
Expected Results:
The formula in A1 should be =SUBTOTAL(9;A2:A99999)
Reproducible: Always
User Profile Reset: No
Additional Info:
Fortunately, =SUM(A2:A99999) behavior is not affected
--
You are receiving this mail because:
You are the assignee for the bug.
