https://bugs.documentfoundation.org/show_bug.cgi?id=171209
Bug ID: 171209
Summary: TYPE function works inconsistent with range reference
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 206013
--> https://bugs.documentfoundation.org/attachment.cgi?id=206013&action=edit
Example of TYPE function with range parameter
In a call like TYPE(C4:G4) the function is evaluated using implicit
intersection. That is, using the formula =TYPE(C4:G4) in cell C6 will evaluate
TYPE(C4) and used in cell E9 will evaluate TYPE(E4).
That means that LibreOffice does not convert the reference to an array.
But when TYPE(C4:J4) is set to array context, it does not iterate over the
range and evaluates TYPE(cell), but returns for all cells of the range the
value 64. The number 64 is result of TYPE(Parameter with data type Array).
That means that LibreOffice converts the reference to an array and repeats the
value in the target range.
The specification is no help, as it only says "dereference". Indeed, the ODF TC
has got a public comment about the insufficient specification.
Excel converts the range to an array and thus returns a single value 64 for
=TYPE(C4:G4). Excel uses the @ operator to provide implicit intersection.
--
You are receiving this mail because:
You are the assignee for the bug.
