https://bugs.documentfoundation.org/show_bug.cgi?id=105847
stragu <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |UNCONFIRMED
Resolution|NOTABUG |---
--- Comment #3 from stragu <[email protected]> ---
Hi m.a.riosv
Thanks for your comment, although I am not sure I understand what you are
saying.
If this is not a bug, could you please explain each of the cases that are
highlighted in orange in the example spreadsheet? (rows 2, 6, 7 and 10)
They are very unintuitive results. I am particularly interested in what you
think of rows 6 and 7 as they don't even result in a multiple of 2.
When you say "you can put =SUMIF(A2:A5; "yes"; B2) and it works fine", do you
mean that the sum_range "B2" is interpreted as "B2:B5"? (In which case, the
result "4" would make sense)
Or do you mean that it is useless to define the end of the range for sum_range,
and that inputting e.g. "B2:B5" would result in "B5" being completely ignored?
If that is the case, again, it is a very unintuitive behaviour, and it would
not explain the result "4".
Anyway, neither of those explanations would explain the bulk of the cases
presented in the attached spreadsheet.
I am switching it back to unconfirmed as I expect more input from the
community, and I don't think your comment explains the behaviour. But I could
be missing something obvious...?
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
