https://bugs.documentfoundation.org/show_bug.cgi?id=173332
--- Comment #8 from BDF <[email protected]> --- If there are two different values click Ctrl + Click, Shift + Click and Left Mouse + Drag, this is a bug IMHO. If you have a more elaborate name for this, I'm also fine with this. When you take a look at the demo image (that I updated because I accidentally uploaded the demo video twice) 250+500+1000+100 is 1'850 and _not_ 3'500. There is no indication where the extra numbers are coming from or how it can be fixed. SUM(A1:B4) works as intended and you kind see where the problem could be. If you just click on a cell, it does not tell you the sum area nor does it indicate that it considers values that are hidden in a second cell. Even I repeat myself: IMHO if you have a sum operator and it gives you a value that you can not reproduce with what you see and your calculator, it's a bug. -- You are receiving this mail because: You are the assignee for the bug.
