https://bugs.freedesktop.org/show_bug.cgi?id=86677
Robinson Tryon (qubit) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #3 from Robinson Tryon (qubit) <[email protected]> --- (In reply to raal from comment #2) > The same behaviour as in excel. When you select 1 empty cell (B1), then > behaviour is the same - sum detects automaticaly left area. When you select > 3 empty cell, Calc is doing same detect of area. When the selected cells > are empty then calc find filled area to sum. Yes, that's how it works for me with LO 4.4.0.0.beta2 + Ubuntu 14.04 If you add data to A1:A3 and B1:B3, and then highlight C1:C3 and click the "Σ" button, the cells in column C will now contain row sums for (A1:B1), (A2:B2), etc... > I think this not a bug. I agree 1) Summing rows or columns of numbers is one of (if not) the most fundamental uses of a spreadsheet 2) Excel has the same behavior Looks like the docs have info: https://wiki.documentfoundation.org/images/4/47/CG41-CalcGuideLO.pdf "clicking on the Sum icon totals the numbers in the cells above the selected cell and then places the total in the selected cell. If there are no numbers above the selected cell, then the cells to the left are totaled." FWIW, I checked Gnumeric and it does *not* have this behavior. Resolving this one as NOTABUG -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
