Description: When writing the function 'subtotal(3;D4:D1000)' in head of a column, LB automaticaly corrects the range of cells. The formulas become 'subtotal(3;D4:D205)' if the last line is line 205. This is annoying because if you add a row below your table the formulas subtotal become wrong. You've to correct the formula to 'subtotal(3;D4:D206)'... and so on. Steps to Reproduce: 1.table with numbers, 1 column A, 10 lines 2.insert a row ahead, add in A1 function 'subtotal(3;A1:A1000)'. Result is ok... but LB tansforms function into 'subtotal(3;A1:A11)'. 3.add a number in A12 and the formula in A1 become "wrong" since the range of cells is wrong. You've to correct it manualy to 'subtotal(3;A1;A12)' to get the right number of line in your table. This seems to ben new (in earlier versions it wasn't like that). Actual Results: Nothing serious, but you have to constantly update the formula at the top of the table to get the right result. Expected Results: allow the user to select the range of cells on which the formula should be applied Reproducible: Always User Profile Reset: No Additional Info: Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 8; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded
Created attachment 204432 [details] test of subtotal function
confirmed with both: Version: 25.8.3.2 (AARCH64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded Version: 25.8.3.2 (AARCH64) / LibreOffice Community Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Flatpak Calc: threaded but works with: Version: 25.2.3.2 (AARCH64) / LibreOffice Community Build ID: 520(Build:2) CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Debian package version: 4:25.2.3-2+deb13u2 Calc: threaded
*** This bug has been marked as a duplicate of bug 168013 ***