Bug 158180

Summary: T function requires a description When the ERROR Value is an argument
Product: LibreOffice Reporter: nobu <tac725>
Component: DocumentationAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: olivier.hallot, raal
Priority: medium    
Version: 3.3.0 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

Description nobu 2023-11-12 02:11:36 UTC
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.
Comment 1 raal 2023-11-13 22:27:02 UTC
Documentation on wiki: https://wiki.documentfoundation.org/Documentation/Calc_Functions/T