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
Please attach a sample file, reduce the size as much as possible without private information.
I don't believe you can't reproduce the bug according to the instructions/explanation I gave. Two other people I know can.
Created attachment 202955 [details] bug att.
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
*** This bug has been marked as a duplicate of bug 168013 ***