Bug 198581 - OOo calc MINA() function doesn't consider blank cells as text (zero)
Summary: OOo calc MINA() function doesn't consider blank cells as text (zero)
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: Fedora
Classification: Fedora
Component: openoffice.org
Version: rawhide
Hardware: i386
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Caolan McNamara
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2006-07-12 02:04 UTC by Horst H. von Brand
Modified: 2007-11-30 22:11 UTC (History)
0 users

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2006-07-12 07:58:47 UTC
Type: ---
Embargoed:


Attachments (Terms of Use)

Description Horst H. von Brand 2006-07-12 02:04:10 UTC
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.

Comment 1 Caolan McNamara 2006-07-12 07:58:47 UTC
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 :-)


Note You need to log in before you can comment on or make changes to this bug.