https://bugs.documentfoundation.org/show_bug.cgi?id=152091
--- Comment #5 from Julien Nabet <serval2...@yahoo.fr> --- (In reply to Julien Nabet from comment #4) > Created attachment 183657 [details] > testfile > > Sorry I had forgotten the attachment. > > BTW, sum in status bar at bottom right (don't know if it's the right naming) > provides correct sum, 210, so Calc considers it as a plain sum in this case. Unless because it would be equivalent here as =SUM(A1:A2;A5:A6;A9:A10) which indeed works. So if this one isn't considered as a bug, at least it means we mustn't mimick Excel in all cases (because I consider its result, 90 120, not intuitive here) :-) -- You are receiving this mail because: You are the assignee for the bug.