https://bugs.documentfoundation.org/show_bug.cgi?id=164966
Heiko Tietze <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #6 from Heiko Tietze <[email protected]> --- A1 = 1, A2 = 2 => Σ returns SUM(A1:B1) A1 = 1, A2 = SUM(A1) => Σ returns SUM(B1:B1) A1 = 1, A2 = SQRT(2) => Σ returns SUM(A1:B1) A1 = 1, A2 = <any range based function>(<any range>) => Σ returns SUM(B1:B1) Indeed inconsistent. The help says: Select Function applied with no selected range LibreOffice automatically suggests a cell range, provided that the spreadsheet contains data. If the cell range already contains a function, you can combine it with the new one to yield the function applied to the range data. If the range contains filters, the Subtotal function is inserted instead of the selected function. https://help.libreoffice.org/7.3/en-GB/text/scalc/02/06030000.html?DbPAR=CALC I cannot wrap my mind around "combine it with". Neither Eike's explanation in bug 149041 comment 3. Wonder if this is really a duplicate. -- You are receiving this mail because: You are the assignee for the bug.
