Issue 86314 - Text parameter of function evaluates to 0
Summary: Text parameter of function evaluates to 0
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2008-02-21 15:19 UTC by kpalagin
Modified: 2013-01-29 21:47 UTC (History)
2 users (show)

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


Attachments
illustrating file (7.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-02-21 15:20 UTC, kpalagin
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description kpalagin 2008-02-21 15:19:19 UTC
In attached "text-param.ods" please see cells B3:B6 - they contain 
=EXP(C3)
=COS(C3)
=LN(C3)
=SIN(C3)
and act as if C3 is equal to zero, when C3 contains text.
This looks wrong. Competing spreadsheet produces #VALUE error.

OTOH,
=COS("jkh")
produces Err:502, which is correct and expected.
Comment 1 kpalagin 2008-02-21 15:20:02 UTC
Created attachment 51632 [details]
illustrating file
Comment 2 kpalagin 2009-05-19 07:38:22 UTC
Dear developers,
since we are very strict when dealing with empty cell (it is not considered 
zero anymore), this issue shows our relaxed attitude for potentially serious 
problem. 
Please see if this issue is even valid.

Regards,
K. Palagin.
Comment 3 Regina Henschel 2009-05-19 20:19:43 UTC
@kpalagin: The current way is an allowed behavior, see section 6.2.4 of the
draft spec, especially the comment.
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula