https://bugs.documentfoundation.org/show_bug.cgi?id=169826
Bug ID: 169826
Summary: LB automatically corrects the subtotal selection
range... which is a problem.
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
