https://bugs.documentfoundation.org/show_bug.cgi?id=154577
BugMagnet <bugmagn...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CLOSED |REOPENED
Resolution|NOTABUG |---
Ever confirmed|0 |1
--- Comment #3 from BugMagnet <bugmagn...@gmail.com> ---
This is a bug.
Documentation for the Product function says:
This function ignores any text or empty cell within a data range
It is not ignoring the empty cell. It is filling the cell with "1". It should
default to 0.
A usage example for this would be making a spreadsheet of perhaps 100 standard
items as a product order form. The user would then select maybe 10 items to
order and then enter a quantity for those 10 items, leaving the cells in the
quantity column blank for other 90 items.
As is, the total column would calculate the price for the 10 items ordered,
then add $90 for the 90 items unordered and left blank.
--
You are receiving this mail because:
You are the assignee for the bug.
