https://issues.apache.org/ooo/show_bug.cgi?id=123926
Bug ID: 123926
Issue Type: DEFECT
Summary: Function TYPE returns value 8, but that value does not
exist in specification
Product: Calc
Version: 4.1.0-dev
Hardware: PC
URL: http://docs.oasis-open.org/office/v1.2/os/OpenDocument
-v1.2-os-part2.html#__RefHeading__1018408_715980110
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: rb.hensc...@t-online.de
CC: issues@openoffice.apache.org
Created attachment 82182
--> https://issues.apache.org/ooo/attachment.cgi?id=82182&action=edit
Some cases with wrong results of TYPE function
The function TYPE returns the value 8 for some cases, see attached file. But
the valid values of the TYPE function are given in a table in the specification
and the value 8 doesn't exist there.
The help has "Value is a specific value for which the data type is determined.
Value 1 = number, value 2 = text, value 4 = Boolean value, value 8 = formula,
value 16 = error value." But the specification explicitly states "If a
Reference is provided, the reference is first dereferenced, and any formulas
are evaluated."
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
