Issue 33230 - invalid functions in writer table don't cause error messages
Summary: invalid functions in writer table don't cause error messages
Status: CONFIRMED
Alias: None
Product: Writer
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 103895 123614 (view as issue list)
Depends on:
Blocks:
 
Reported: 2004-08-19 20:24 UTC by avagula
Modified: 2013-11-02 17:57 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
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 avagula 2004-08-19 20:24:24 UTC 
Let me explain - if I write in writer table an invalid formula, I'll get the
result, that contains the last argument in formula. 
Example: I want write formula "=sin(<A1>)", where A1=0.5. The right answer is
0.48. But I'll make a mistake by typing and enter "=sun(<A1>)". And I'll get the
answer 0.5. It is wrong answer, but I'll never know that... It is dangerous and
leads to wrong results. 
I think that if cell content in table begin with =, then must the formula syntax
be checked and when it is invalid or contains unknown entries user must get the
error message.
Comment 1 pavel 2004-08-19 20:27:24 UTC 
confirmed.
Comment 2 avagula 2004-08-23 16:30:38 UTC 
I took a look at 680_m49, here invalid functions are giving answer 0. It is
better than "old" behaviour but not good enough. One possibility were displaying
error message, other and maybe even better - if function is invalid (or unknown)
or amount or content of arguments wrong - in cell will be shown formula as text
string, so that user can fix errors if he wants.
Comment 3 michael.ruess 2004-08-24 12:57:50 UTC 
Reassigned to BH. It might be better to give "** Expression faulty ***" message
also when there's e.g. a typo in the function names.
Comment 4 avagula 2009-06-06 22:08:34 UTC 
after 5 years it still exists...
Comment 5 bettina.haberer 2010-05-21 14:53:24 UTC 
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements".
Comment 6 Regina Henschel 2013-11-02 17:45:36 UTC 
*** Issue 123614 has been marked as a duplicate of this issue. ***
Comment 7 Regina Henschel 2013-11-02 17:57:02 UTC 
*** Issue 103895 has been marked as a duplicate of this issue. ***