https://bugs.documentfoundation.org/show_bug.cgi?id=149041
--- Comment #6 from Rafael Lima <[email protected]> --- FYI: In MS Excel the behavior is a bit different than in LO Calc. In Excel if no range is selected and the cell cursor is positioned in A7, applying "AutoSum" will only select cells A5:A6 and leave the formula open for the user to change it. This is exactly the same LO Calc does. The difference is when there's a range selected. For instance, in Excel if we select A4:A6 and click AutoSum, it will consider cell A4 in the resulting SUM formula. LO Calc won't consider cell A4 since it has a formula in it. IMO the way MS Excel behaves is more natural from a user's point of view, since the user explicitly selected a range of cells and clicked the SUM formula in the AutoSum, so this means that he/she wants that cell to be considered. There's one side note: The behavior I reported for Excel won't work if cell A1 is selected. For example, if you select A1:A6 and apply AutoSum, only cells A5:A6 will be included in the SUM formula. However if you select A2:A6 then the SUM formula will include A2:A6. This looks like an Excel bug to me. -- You are receiving this mail because: You are the assignee for the bug.
