https://bugs.documentfoundation.org/show_bug.cgi?id=71339
--- Comment #10 from Anthony Youngman <anth...@youngman.org.uk> --- Just adding that I've filed a similar bug (93257) again asking for autosum to respect the user's selection. This is behaviour I expect from Excel, and I believe was in QuattroPro before that (that's QP for Win3.11, ie back in the DOS days). And even used as described here, autosum doesn't work. Enter a column of figures, click in the cell below and click autosum. Works fine. Add more figures below (ie, in the user's mind, the previous sum was a *sub*total). Now autosum the column again. It creates a new total of just the numbers after the previous total! Okay, that behaviour *could* be seen as logical. But if that behaviour is wanted, surely the user can just stick a blank line after the previous subtotal to indicate it? If I do that, I always want a new (sub)total of the *entire* column. Basically, it seems to me that the design of autosum makes sense, it just doesn't work in the real world the way most people want to use it :-( (and breaks the "principle of least surprise" in that it produces very different results from what most people expect from other spreadsheets). Cheers, Wol -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs