Assume I have a column of numbers in column A I highlighted 3 cells vertically in column B which contained no data (yet). After hitting the SUM() from the toolbar, it instead summed up the neighbouring contents in column A. Once I added contents to column B, the result did not update. I checked the formula bar and noticed that the short-cut created had in fact been created for column A. I repeated the operation again and had the same result. I had to type SUM(B1:B3) into the formula editor to correct it.
Fedora 21 Version: 4.4.0.0.beta1 Build ID: 9af3d21234aa89dac653c0bd76648188cdeb683e Locale: en_AU - I enter values into A1, A2 & A3 - Highlight B1, B2, B3 - click the SUM icon B1 says sum(A1:A1) B2 says sum(A3:A2) B3 says sum(A3:A3) Similar but different but, in my opinion, wrong.
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. I think this not a bug.
(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