To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=89621
Issue #|89621
Summary|Calc should warn about REF errors
Component|Spreadsheet
Version|OOo 2.3.1
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|tab
------- Additional comments from [EMAIL PROTECTED] Mon May 19 02:15:41 +0000
2008 -------
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?'.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
