Description of problem: As said, MINA() doesn't consider blank as zero. This might be "right", but is rather counter-intuitive. Version-Release number of selected component (if applicable): openoffice.org-calc-2.0.3-7.4 How reproducible: Always Steps to Reproduce: 1. Create a spreadsheet with some positive numbers in it 2. Compute MINA() of a range that includes blank cells 3. Actual results: Minimum of non-blank cells Expected results: Zero (i.e., value of blank as text is zero) Additional info: Dumb workaround is to fill with a space (instead of empty/blank), but it is ugly and error-prone.
You could log that upstream directly against sc.openoffice.org's issuezilla if you want to get an answer "from the horse's mouth", but I'm not going to get sucked into the eternal "when is blank 0 or not" wars that always seem to rage in the spreadsheet world :-)