https://bugs.documentfoundation.org/show_bug.cgi?id=168539
Bug ID: 168539
Summary: As of 25.8.1.1 Calc: entering formula
'=SUBTOTAL(9,A:A)' does not work as intended
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
