Issue 62567 - Formula correction suggests invalid formulas
Summary: Formula correction suggests invalid formulas
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-25 14:19 UTC by rosspjohnson
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 rosspjohnson 2006-02-25 14:19:23 UTC 
An issue reported by someone on the user's list.

Enter the following formula into Calc:

=SUM D8:D9)

Calc suggests an even less valid formula as a replacement:
=SUMD8:D9

It's the same for every function I tried.
Comment 1 grsingleton 2006-02-25 14:39:29 UTC 
True in rc3
Comment 2 rosspjohnson 2006-02-26 00:34:02 UTC 
One really simple safeguard against this in general would be to have Calc
re-check it's own suggested replacement formula *before* suggesting it. If the
replacement fails the check then Calc should issue an appropriate message (i.e.
no valid replacement can be suggested) and give up.
Comment 3 frank 2006-03-08 11:09:57 UTC 
Hi Niklas,

one for you.

Frank
Comment 4 niklas.nebel 2006-03-08 18:16:22 UTC 
Not important for the next release.
Comment 5 Marcus 2017-05-20 11:13:12 UTC 
Reset assigne to the default "issues@openoffice.apache.org".