https://bugs.documentfoundation.org/show_bug.cgi?id=171183
Bug ID: 171183
Summary: TYPE functions works inconsistent with array as
parameter
Product: LibreOffice
Version: 26.8.0.0 alpha0+ master
Hardware: All
URL: https://docs.oasis-open.org/office/OpenDocument/v1.4/p
art4-formula/OpenDocument-v1.4-os-part4-formula.html#T
YPE
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 205983
--> https://bugs.documentfoundation.org/attachment.cgi?id=205983&action=edit
Test cases for parameter with data type Array
If the argument of TYPE has data type Array, the function TYPE returns value
64. The error is, that in some cases LibreOffice automatically generates an
array context. And the user cannot avoid this array context because the
checkbox is disabled in the function wizard.
LibreOffice calculates these correctly:
=TYPE(COLUMN(B5:D5))
=TYPE(LARGE(B21:B25;{1;2}))
LibreOffice erroneously forces an array context:
=TYPE({"A";999;"B"})
=TYPE(MUNIT(2))
The attached file contains these cases. In my settings the semicolon is the
column separator in inline arrays. Depending on your settings and your locale,
you might see a different separator, when you open the attached file.
--
You are receiving this mail because:
You are the assignee for the bug.
