https://bugs.documentfoundation.org/show_bug.cgi?id=172799
Bug ID: 172799
Summary: Improve Calc error messages
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Errors in formulas are differentiated only by a single enumerated integer,
which is displayed when an error occurs, along with the (unvarying) message
associated with that number. I think it would be much more helpful to the user
if those messages were only the default, and in most cases the error codes were
supplemented by templated text describing the specific problem (and, possibly,
where the problem occurred). The templates would need to be translatable, of
course, but it should be set up so that data from the formula in question can
be filled in.
Steps to Reproduce:
1. Create a new Calc spreadsheet.
2. Enter =] in cell A1.
Actual Results:
The cell shows "Err:507", and the status line shows "Error: in bracketing"
Expected Results:
The status line (at least) shows something more descriptive, such as "Error:
Expected operand or unary operator here, but found ']'"
If there was a way to identify exactly where the error was found in the
formula, that should also be shown.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This is, of course, an example. This sort of change should apply to (nearly)
all of the errors that can occur. The default message is still appropriate if
no information can be discerned at the point of raising the error, or if the
default message alone is as descriptive as things can get.
--
You are receiving this mail because:
You are the assignee for the bug.
