[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #10 from BugMagnet --- Created attachment 186475 --> https://bugs.documentfoundation.org/attachment.cgi?id=186475=edit Situation Solved with If-Then-Else -- You are receiving this mail because: You are the assignee for

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #9 from BugMagnet --- I have to apologize for my display of ignorance. I tend to be very intuitive and this behavior isn't IMO. However, when I started to research this issue, I saw many have asked about the same thing over

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 ady changed: What|Removed |Added Resolution|--- |NOTABUG Status|REOPENED

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #7 from BugMagnet --- Might it be possible then to have some alternative options to this? Perhaps when such a column is defined as being numeric, to then assume blank is to be 0 for function purposes. Or the option to

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #6 from ady --- 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.

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #5 from BugMagnet --- Created attachment 186456 --> https://bugs.documentfoundation.org/attachment.cgi?id=186456=edit example spreadsheet -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 --- Comment #4 from BugMagnet --- correction, it would add product(price,1) for the other 90 items when the price cell if filled but the quantity cell is left blank. Should be price*0, not price*1 when blank. -- You are receiving this

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 BugMagnet changed: What|Removed |Added Status|CLOSED |REOPENED Resolution|NOTABUG

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 Eike Rathke changed: What|Removed |Added Resolution|--- |NOTABUG

[Libreoffice-bugs] [Bug 154577] Calc assumes blank cell has value of 1 instead of zero

https://bugs.documentfoundation.org/show_bug.cgi?id=154577 BugMagnet changed: What|Removed |Added CC||bugmagn...@gmail.com --- Comment #1