Bug 168539 - As of 25.8.1.1 Calc: entering formula '=SUBTOTAL(9,A:A)' does not work as intended
Summary: As of 25.8.1.1 Calc: entering formula '=SUBTOTAL(9,A:A)' does not work as int...
Status: RESOLVED DUPLICATE of bug 168013
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.1.1 release
Hardware: All All
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2025-09-24 17:16 UTC by ops
Modified: 2025-09-25 01:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
bug (25.70 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-09-24 21:49 UTC, ops
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ops 2025-09-24 17:16:41 UTC
Description:
EDITING
=SUBTOTAL(9,A:A)
until 25.8.1.1, entering the above formula would subtotal the entire column A.
Now, upon entry Calc converts it to =SUBTOTAL(9,A$1:A$152) where '152' will be the last row in the column in which there is data.
Your low-IQ incompetent dumb-fuckery has fucked up every single spreadsheet I've ever created because when opened all SUBTOTAL formulas summing entire columns are converted to a column-row range instead of the entire column, thus when data is completed in new rows I now have to reenter all Subtotal formulas.
Too fucking stupid!! NEVER again will I donate. I've been donating to microsoft-level intellect all along.

Steps to Reproduce:
enter '=SUBTOTAL(9,A:A)'in any cell

Actual Results:
=SUBTOTAL(9,A$1:A$152) where '152' will be the last row in the column in which there is data

Expected Results:
=SUBTOTAL(9,A:A) is entered as it always has been


Reproducible: Always


User Profile Reset: Yes

Additional Info:
=SUBTOTAL(9,A:A) should have been entered in the cell like always has happened

Version: 25.8.1.1 (X86_64)
Build ID: 54047653041915e595ad4e45cccea684809c77b5
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2025-09-24 21:18:49 UTC
Please attach a sample file, reduce the size as much as possible without private information.
Comment 2 ops 2025-09-24 21:47:20 UTC
I don't believe you can't reproduce the bug according to the instructions/explanation I gave.
Two other people I know can.
Comment 3 ops 2025-09-24 21:49:07 UTC
Created attachment 202955 [details]
bug

att.
Comment 4 m_a_riosv 2025-09-24 22:00:05 UTC
Please watch your language.

Reproducible
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 6f68c46d0aa5fe872de0dec8777d35ff91886043
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded

Latest version that works on the ones I have installed.
Version: 25.2.7.0.0+ (X86_64) / LibreOffice Community
Build ID: 13f49dd637f5e6778fe5dcf7ee22f33a455815da
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 5 nobu 2025-09-25 01:22:31 UTC

*** This bug has been marked as a duplicate of bug 168013 ***