Talk:Documentation/Calc Functions/ERRORTYPE

    From The Document Foundation Wiki

    SF Comments

    (1) Summary. Suggest the following replacement text – “Determines the numeric error code for a given error condition. This number can be used to generate a bespoke text explanation of the error that has occurred.”.
    (2) Returns. Suggest replacing with the following – “Returns a positive integer in the range 501 to 540 (inclusive) if the argument specifies an error condition. Returns the #N/A error if the argument does not specify an error condition.”
    (3) Arguments, Reference. 1st sentence does not reflect that you can pass an error as argument rather than a cell reference; for example, =ERRORTYPE(#DIV/0!) is valid and returns 532. Delete 2nd sentence – it is repeating what is now said in the Returns section.
    (4) Arguments, 1st bullet. Do we mean that “If Reference is not a reference to a cell or a valid error code, then the function returns #N/A”?
    (5) Additional details, bullet. Rather than referring to a legacy section of the 4.1 Calc Guide, suggest explaining that a list of Calc’s error messages and codes can be found by visiting https://help.libreoffice.org/ and searching for “error codes” in the help index (this approach avoids linking to a specific page which may become obsolete or even disappear). Also, it would be worth explaining that this information can also be accessed in the Error Codes appendix of the latest version of the Calc Guide available at https://documentation.libreoffice.org/en/english-documentation/.
    (6) Additional details. I do not feel that this text needs to be highlighted as a Note – it would be more appropriate as a Tip. Also, maybe reword as – “If you click a cell containing an error, the Status Bar displays a generic explanation of the error.”.
    (7) Examples, general. Please include an example for =ERRORTYPE(#DIV/0!).
    (8) Examples, 1st example. “display” should be “displays”. This is a poor example because error 518 is an internal error which, we hope, should not occur often. Suggest changing formula so that A1 contains =SIN(“angle”) and displays the #VALUE! error, with the value 519 returned.
    (9) Examples, 2nd example. Suggest the following replacement to improve grammar – “The function returns the error number associated with the Err:511 error displayed in A3.”.
    (10) Examples, 3rd example. Maybe reword as – “The function returns the error number associated with the #DIV/0! error displayed in A4”.
    (11) Examples, 4th example. Maybe reword as – “The function returns the error number associated with the #NUM! error displayed in A2”.
    (12) Examples, 5th example. Suggest changing “cell has” to “contains”.
    (13) Related LibreOffice functions. Do you think it might be worth marking ERROR.TYPE and ERRORTYPE as related to each other?

    --Stevefanning (talk) 2020-12-10T21:20:03 (UTC)