https://bugs.freedesktop.org/show_bug.cgi?id=73078
Priority: medium
Bug ID: 73078
Assignee: [email protected]
Summary: Function TYPE returns error, when parameter is a
reference to an empty cell
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Make sure cell B2 is empty, that means it has no content at all.
Write formula =TYPE(B2) into cell A1.
Expected behavior: You get a number.
Seen behavior: Err:502. That is "Error: Invalid argument".
The function TYPE is specified with the Syntax: TYPE( Any value ) and the rule
"If a Reference is provided, the reference is first dereferenced, and any
formulas are evaluated." [ODF1.2 part2 section 6.13.33 TYPE]
Because of argument type "Any" the function cannot result in an error.
Gnumeric, Apache OpenOffice, and Excel return the number 1 in this case.
Suggestion: LibreOffice should return 1 in this case too.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
