Issue 119698 - <Formula>The result of formula(COUNT) is error.
Summary: <Formula>The result of formula(COUNT) is error.
Status: CLOSED DUPLICATE of issue 58572
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-04 06:33 UTC by Du Jing
Modified: 2012-06-04 14:55 UTC (History)
1 user (show)

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

Attachments
sample file (15.50 KB, application/vnd.ms-excel)
2012-06-04 06:33 UTC, Du Jing 		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 Du Jing 2012-06-04 06:33:43 UTC 
Created attachment 77910 [details]
sample file

build info:AOO3.4_1327774

Steps:
1.open the sample file in AOO3.4
2.check the result in the sample

defect:
the result is different with in MS Office
Comment 1 Regina Henschel 2012-06-04 14:55:48 UTC 
For AOO the data type boolean is not a separate type but a subtype of number. This allowed in ODF. But Excel has a separate type boolean. ODF allows to treat boolean as number.

The problem of not having a data type boolean is already tracked in issue 58572.

*** This issue has been marked as a duplicate of issue 58572 ***