https://bugs.documentfoundation.org/show_bug.cgi?id=153574
Bug ID: 153574
Summary: RFE: Add information about errors, error codes or
error numbers in Calc (that is currently not included)
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Documentation
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: adylo811...@gmail.com
CC: olivier.hal...@libreoffice.org
When using
https://help.libreoffice.org
(and/or the built-in help system), it is not so easy to find information about
errors, error codes or error numbers in relation to Calc's formulas (or their
results).
It is particularly relevant for the #N/A error (at the moment of writing).
ATM there are, for instance:
* NA
https://help.libreoffice.org/7.5/en-US/text/scalc/01/04060104.html#bm_id3156275
* Error Codes in LibreOffice Calc
https://help.libreoffice.org/7.5/en-US/text/scalc/05/02140000.html
* ERRORTYPE function
https://help.libreoffice.org/7.5/en-US/text/scalc/01/04060109.html#bm_id3153114
* ERROR.TYPE function
https://help.libreoffice.org/7.5/en-US/text/scalc/01/func_error_type.html#bm_id346793467934679
While less directed to common simple final users (of Calc), there is also (not
part of Calc):
* Error Function
https://help.libreoffice.org/7.5/en-US/text/sbasic/shared/03050300.html
and additionally, there is the Guide (CG75-CalcGuide.pdf, the latest ATM).
But there seems to be no info with more details about (some of) the errors (and
particularly for #N/A), nor a simple way for newbies to find information about
situations like the following:
"what is this #N/A error result that I am getting? Why? What should I do with
this?
(To be clear, I know the answer. This is only a rhetorical question, in order
to explain the need for this RFE.)
I have tried several different keywords, sometimes with or without "#" and/or
"!" and/or "?" and/or "/" (as in NA, N/A, #NA, NA(), #N/A...), and sometimes
with or without additional words such as "error", "code", in plural, in
uppercase, combining them...
Please also note that even in the aforementioned links, there is little or no
relevant information about the #N/A error, not even in the help page for the
NA() function.
In particular, the help page that lists the error codes (already mentioned
above):
https://help.libreoffice.org/7.5/en-US/text/scalc/05/02140000.html
does not include the #N/A error.
Moreover, I couldn't find any mention about #N/A in the Guide
(CG75-CalcGuide.pdf, the latest ATM).
Even if the #N/A error were to be considered a different category than those
listed in that help page – IDK whether that's the case – from the POV of a
newbie "an error (message) is still an error (message)" (and a newbie might
probably won't know nor care about categories of errors in Calc).
IMHO, either all errors seen by final users should be listed (and minimally
explained, at least), or some other help page should include them somewhere.
This is the point of this RFE.
--
You are receiving this mail because:
You are the assignee for the bug.
