https://bugs.documentfoundation.org/show_bug.cgi?id=154577
--- Comment #6 from ady <adylo811...@gmail.com> --- This seems to be a matter of clear language and specific details. @BugMagnet, this is probably not what you expect from this function. I indeed understand, but... Let's assume cell A2 is empty or has text. This cell would then be "ignored" by this function means... =PRODUCT(A1,A2) would be equivalent to =PRODUCT(A1) which would be equivalent to cell A1 by itself. A cell without an explicit number (or an equivalent to an explicit number) being "ignored" implies that for a cell to be considered as having a zero, the cell needs to actually be zero or result in zero, not just empty. I do understand that, in terms of "common" arithmetic, this doesn't make much sense. Unfortunately, this is how this function is "defined" (although, possibly additional details in ODF might be welcome). This is the reason for this report to be set as NAB. FWIW, other spreadsheet tools work in the same way with this function. -- You are receiving this mail because: You are the assignee for the bug.
