https://bugs.documentfoundation.org/show_bug.cgi?id=158180
Bug ID: 158180
Summary: T function requires a description When the ERROR Value
is an argument
Product: LibreOffice
Version: 3.3.0 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
