[Libreoffice-bugs] [Bug 120179] [LOCALHELP] rewrite SUMIF Help page
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 --- Comment #6 from Rafael Lima --- Created attachment 175196 --> https://bugs.documentfoundation.org/attachment.cgi?id=175196=edit SUMIF with different range sizes > Both ranges should have the same length in rows or columns, or the second > range has only the first cell (not compatible with other file formats). I ran some tests and this is no longer the case. SUMIF accepts ranges of different sizes. Maybe this was an enhancement after this bug was filed, but the fact is that now SUMIF does work if both ranges have different sizes (see attached example). It seems that the size of the first range always prevails, be it smaller or larger than the sum range. I guess this is due to MS compatibility: https://support.microsoft.com/en-us/office/sumif-function-169b8c99-c05c-4483-a712-1697a653039b In Excel, "the formula will sum a range of cells that starts with the first cell in sum_range but has the same dimensions as range". So far, this behavior is reproducible in LO Calc as well. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 120179] [LOCALHELP] rewrite SUMIF Help page
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 himajin100...@gmail.com changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=12 ||1696 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120179] [LOCALHELP] rewrite SUMIF Help page
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 Buovjaga changed: What|Removed |Added Blocks|80430 | Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=80430 [Bug 80430] [META] LOCALHELP: Features x Documentation gap -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 120179] [LOCALHELP] rewrite SUMIF Help page
https://bugs.documentfoundation.org/show_bug.cgi?id=120179 Olivier Hallot changed: What|Removed |Added Resolution|NOTABUG |--- Summary|sumif works wrong if Range |[LOCALHELP] rewrite SUMIF |has different row index |Help page |than SumRange | Status|RESOLVED|NEW Component|Calc|Documentation Blocks||80430 Ever confirmed|0 |1 --- Comment #5 from Olivier Hallot --- The Help page of SUMIF is too amateur-ish, and even wrong. It deserves a much more precise definition, more/better examples, and corner case situations. Re-qualifying the bug as doc bug Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=80430 [Bug 80430] [META] LOCALHELP: Features x Documentation gap -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs