Bug 158180 - T function requires a description When the ERROR Value is an argument
Summary: T function requires a description When the ERROR Value is an argument
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-11-12 02:11 UTC by nobu
Modified: 2024-04-27 06:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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