Issue 123926 - Function TYPE returns value 8, but that value does not exist in specification
Summary: Function TYPE returns value 8, but that value does not exist in specification
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 4.1.0-dev
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL: http://docs.oasis-open.org/office/v1....
Keywords:
Depends on:
Blocks:
 
Reported: 2013-12-28 00:38 UTC by Regina Henschel
Modified: 2014-04-16 11:24 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Some cases with wrong results of TYPE function (14.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-28 00:38 UTC, Regina Henschel 		no flags Details
Calc vs Excel 2010 vs Gnumeric 1.10.16 (325.45 KB, image/jpeg)
2013-12-28 15:51 UTC, Edwin Sharp 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Regina Henschel 2013-12-28 00:38:22 UTC 
Created attachment 82182 [details]
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."
Comment 1 Edwin Sharp 2013-12-28 15:51:09 UTC 
Created attachment 82183 [details]
Calc vs Excel 2010 vs Gnumeric 1.10.16
Comment 2 Edwin Sharp 2013-12-28 15:51:36 UTC 
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1552994
Rev.1552994
Win 7
Comment 3 Rainer Bielefeld 2014-04-16 11:24:57 UTC 
Already reproducible with sever installation of "OOo 3.3.0 English UI / German locale [OOO330m20 (Build 9567)]" on WIN7 Home Premium (64bit) DE