https://bugs.documentfoundation.org/show_bug.cgi?id=164966
Cekomote <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #2 from Cekomote <[email protected]> --- After a lot of tests, I confirm that the Σ button acts inconsistently. The simplest test I found is : 1. In cell A1, enter 1 2. In cell A2, enter =SUM(A1) 3. Select cell range A1:A2 and use the Σ button to generate a sum formula in A3 Actual result : A3 is =SUM(A2:A2) Expected result : A3 should be =SUM(A1:A2) The behavior is the same for all Σ button formulas (Sum, Average, Min, Max, Count, CountA, Product, Stdev, StdevP, Var, VarP). Full behavior seems to be : IF the selected range contains a formula in the the Σ button formula list AND if this formula uses - for formula generation of a column, (a cell OR a cell range of one cell height) of the row above - for formula generation of a raw, (a cell OR a cell range of one cell width) of the column before THEN the generated formula has a truncated range. The range of the generated formula is correct if the other cases. Exemple if Σ button is used to sum a column - if A2 is =SUM(A1), A3 will be =SUM(A2:A2) instead of =SUM(A1:A2) - if A2 is =SUMPRODUCT(A1), A3 will be =SUM(A1:A2) - if A2 is =SUM(M1:Z1), A3 will be =SUM(A2:A2) instead of =SUM(A1:A2) - if A2 is =SUM(B2), A3 will be =SUM(A1:A2) Reproduced in version 24.8.4.2 on MacOS 15.1.1 - There is no Help - About LibreOffice in LibreOffice for MacOS (Apple Silicon). This seems to be a bug, I change the status to new. -- You are receiving this mail because: You are the assignee for the bug.
