Issue 62567 - Formula correction suggests invalid formulas
Summary: Formula correction suggests invalid formulas
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:
Depends on:
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: ---


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:

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.

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 "".