You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/12/28 01:38:22 UTC
[Bug 123926] New: Function TYPE returns value 8, but that value does
not exist in specification
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.henschel@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.
[Bug 123926] Function TYPE returns value 8, but that value does not
exist in specification
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123926
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |elish@apache.org
--- Comment #1 from Edwin Sharp <el...@apache.org> ---
Created attachment 82183
--> https://issues.apache.org/ooo/attachment.cgi?id=82183&action=edit
Calc vs Excel 2010 vs Gnumeric 1.10.16
--
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.
[Issue 123926] Function TYPE returns value 8, but that value does
not exist in specification
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123926
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Already reproducible with sever installation of "OOo 3.3.0 English UI / German
locale [OOO330m20 (Build 9567)]" on WIN7 Home Premium (64bit) DE
--
You are receiving this mail because:
You are on the CC list for the issue.
You are the assignee for the issue.
You are watching all issue changes.
[Bug 123926] Function TYPE returns value 8, but that value does not
exist in specification
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=123926
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #2 from Edwin Sharp <el...@apache.org> ---
Confirmed with
AOO410m1(Build:9750) - Rev. 1552994
Rev.1552994
Win 7
--
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.