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
Can reproduce. Setting to "NEW". Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: fd48da7236f26d9d8d16759546a5c860f91b82de CPU threads: 12; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: CL threaded
*** Bug 168539 has been marked as a duplicate of this bug. ***