https://bugs.documentfoundation.org/show_bug.cgi?id=172799

--- Comment #3 from Ben Urban <[email protected]> ---
(In reply to ady from comment #1)
> The status bar has very limited space. Calc already has better hints about
> where or what the problem could be than other spreadsheet tools, which offer
> more generic error codes / messages.
> 
>  <https://wiki.documentfoundation.org/Faq/Calc/015>

I do agree that the status bar has limited space, but there must be a way to
show more. A tooltip would work. But I believe you are misunderstanding my
suggestion. Taking an example from that table:

=VLOOKUP(1;0;1) shows Err:504 Error in parameter list. That is *very* unhelpful
for someone who does not know where the error is or what VLOOKUP expects. Even
the Wiki page doesn't explain what went wrong in *that* formula (well, other
than using that particular one as an example...).

A better message would be something like:
Error: VLOOKUP expects an array or range for its second parameter; found 0
instead.

Again, if it doesn't fit in the status bar, it could show as a tooltip or some
other way. But that error message is substantially easier for a user to
understand than "Error in parameter list."

Also, thanks for the link; I'm adding Err:542 to that list.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to