Issue 89621 - Calc should warn about REF errors
Summary: Calc should warn about REF errors
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: 4.1.0-dev
Hardware: PC Windows, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
: 95641 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-05-19 03:15 UTC by tab
Modified: 2014-01-07 19:53 UTC (History)
3 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 tab 2008-05-19 03:15:41 UTC 
Calc give #REF! warning.
If B1 refers to A2 and row 2 is deleted, B1 is no longer valid and shows the
#REF! error message. OK. If I see the error message, I can undo the deletion.
But if column B is hidden, the message is not shown, and I may not realize I
made a mistake until it's too late.
	Suppose column W suddenly fills up with #REF! as a result a wrong deletion or
edit. If I am working on column A, column W is off screen, and I don't see all
these #REF!. 

Conclusion: Calc should warn if an edit operation is going to cause mayhem. Or,
at least, warn if it just did, so that the user can undo the operation.
Since Calc immediately recalculates, and displays REF error messages (in visible
cells, anyway), it should very simple to program Calc to pop a message at the
first such error: 'Warning: ref error in cell ***; Continue?/Cancel?'.
Comment 1 oc 2008-07-15 10:45:05 UTC 
reassigning features and enhancements to user requirements@openoffice.org which
will be the default owner for those tasks (was introduced some time ago)
Comment 2 Edwin Sharp 2013-11-29 10:45:22 UTC 
Display in status bar "Number of errors in sheet".
A number other than zero implies errors are present.
Comment 3 Edwin Sharp 2014-01-07 19:53:11 UTC 
*** Issue 95641 has been marked as a duplicate of this issue. ***