Issue 93916

Summary:	PRODUCT does not always ignore text
Product:	Calc	Reporter:	villeroy <villeroy>
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	elish, issues
Version:	OOo 2.4.1
Target Milestone:	---
Hardware:	Unknown
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	4.0.0
Developer Difficulty:	---

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