https://bugs.documentfoundation.org/show_bug.cgi?id=171485
Bug ID: 171485
Summary: TYPE returns unsuitable value for a ReferenceList as
argument
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 206404
--> https://bugs.documentfoundation.org/attachment.cgi?id=206404&action=edit
Examples with ReferenceList
Open attached document. It contains examples for ReferenceList. A reference
list is created by the concatenation operator ~
If a ReferenceList is used as argument of the TYPE function, it returns 1. That
is surely wrong, because result 1 indicates data type Number.
Excel returns 16. That means it considers a ReferenceList as error. That is
neither correct. However it is as least consistent in Excel, because
ISERROR(ReferenceList) is TRUE in Excel.
The error happens in LibreOffice in
void ScInterpreter::ScType()
in https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx
The switch there misses the case svRefList and therefor runs into default case.
ODF has no value specified for data type ReferenceList. There is ongoing
discussion in https://issues.oasis-open.org/browse/OFFICE-4201.
Therefore I suggest to postpone a fix till there is a decision by the ODF TC
for ODF 1.5.
--
You are receiving this mail because:
You are the assignee for the bug.
