Issue 93916 - PRODUCT does not always ignore text
Summary: PRODUCT does not always ignore text
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-09-15 16:08 UTC by villeroy
Modified: 2013-04-15 19:29 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 4.0.0
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2008-09-15 16:08:32 UTC 
=PRODUCT(A1) yields 0 with text in A1, but
=PRODUCT(1;A1) yields 1

See also A1;C1:E1 in
http://www.openoffice.org/nonav/issues/showattachment.cgi/56545/issue_93915.ods
related to another issue in the first place.
Comment 1 natalia_hitekschool 2009-01-17 23:58:08 UTC 
Verified on PC platform, Windows Vista Home Premium OS with version DEV300m37.
Really, 
=PRODUCT(A1) yields 0 with text in A1, but
=PRODUCT(1;A1) yields 1

but it is a consequence of the fact that mathematical functions accept text as 
an empty cell; =PRODUCT(empty cell)=0 the same way as SUM, ABS and others, 
=PRODUCT(1;0) = 0 (AVERAGE(empty cell) leads to #DIV/0! whereas AVERAGE(0)=0).

I am not sure that functions specified  as they must validate argument. If they 
must there is the issue, if - not - not.
Comment 2 Edwin Sharp 2013-04-15 19:29:54 UTC 
As given in description.
Rev. 1467605 Win 7