Description: T function requires a description When the ERROR Value is an argument Steps to Reproduce: 1. Open New Calc 2. Input Cell [ A1 ] "=T(NA())" 3. #N/A 4. Read T Functiuon Help : https://help.libreoffice.org/latest/en-US/text/scalc/01/04060110.html?#t Actual Results: 5. This function returns the target text, or a blank text string if the target is not text. Expected Results: 5. Like the n function, it is necessary to describe the error value is an argument. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060104.html?&#n Do not imitate the deficiencies of MS's help Reproducible: Always User Profile Reset: No Additional Info: Documentation/Calc Functions/T https://wiki.documentfoundation.org/Documentation/Calc_Functions/T Returns: Returns a text string, which is either the same as the supplied string or the empty string. There is NOT a description when the error value is an argument. Documentation/Calc Functions/N https://wiki.documentfoundation.org/Documentation/Calc_Functions/N Returns: The number returned depends on the nature of the argument as follows: For a numeric argument, N returns that number. For a Boolean argument, N returns 1 (TRUE) or 0 (FALSE). For a date/time argument, N returns the equivalent date-time serial number. For a string argument, or a reference to an empty cell, N returns the value 0. For an argument that represents an error condition, N propagates the error code. Other Company --- MS Excel = T function https://support.microsoft.com/en-gb/office/t-function-fb83aeec-45e7-4924-af95-53e073541228 There is NOT a description when the error value is an argument. MS Excel = N function https://support.microsoft.com/en-gb/office/n-function-a624cad1-3635-4208-b54a-29733d1278c9 There is a description when the error value is an argument. --- Google Spreadsheet = T function https://support.google.com/docs/answer/3094138 There is a description when the error value is an argument.
Documentation on wiki: https://wiki.documentfoundation.org/Documentation/Calc_Functions/T
Pierre F committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/commit/4a27fa416765ce8ceecfbf1bd70ef1343dcc8e2a tdf#158180 - description of ERROR Value as argument of T()
I read the English website with automatic translation and it is not accurate. It looks like nothing has changed on the first page that should be corrected. https://wiki.documentfoundation.org/Documentation/Calc_Functions/T