https://bugs.documentfoundation.org/show_bug.cgi?id=149041
--- Comment #3 from Eike Rathke <[email protected]> --- The button (maybe should be called "AutoFunction" instead of "Select Function", Excel still calls it "AutoSum" I think) inserts a function taking a data range up to and excluding the last formula cell within a selection, or if the previous cell is already a formula cell then collecting all formula cells of a contiguous cell range within the selection, acting similar to a SUBTOTAL() function on the overall range. Shortening the cell range passed in this case when a formula cell was encountered is correct behaviour. As Leroy said, the confusion is mainly because the original selection is kept, if it was adjusted to the resulting A5:A6 it would be clearer in this case. -- You are receiving this mail because: You are the assignee for the bug.
