Issue 94150 - sumif function problem after document import from excel
Summary: sumif function problem after document import from excel
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 3.0 RC2
Hardware: Sun All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-09-22 08:47 UTC by mareksm
Modified: 2013-03-01 10:52 UTC (History)
2 users (show)

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

sample excel document (6.00 KB, application/
2008-09-22 08:48 UTC, mareksm
no flags Details
excel screen shoot (80.18 KB, image/jpeg)
2008-09-22 08:48 UTC, mareksm
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description mareksm 2008-09-22 08:47:30 UTC
created sample xls document to show the problem with sumif (and most likely
other functions) - how it handles text, number and number-stored-as-text values.

In sample document - D3 contains (as excel calls it) number-stored-as-text, E3 -
contains number. In excel - sumif works fine (cells D3 and E3 show correct
result). Calc works OK if number is stored as text (because A3-A7 has also
textual values), but not working if there is a plain number only for it's second

Attached is a screen shoot from excel.
Comment 1 mareksm 2008-09-22 08:48:03 UTC
Created attachment 56700 [details]
sample excel document
Comment 2 mareksm 2008-09-22 08:48:38 UTC
Created attachment 56701 [details]
excel screen shoot
Comment 3 Edwin Sharp 2013-03-01 10:52:55 UTC
In Excel 2010, both criteria cells D2 and E2 are in general format.
In Calc, D2 is '3 and E2 is 3, so when comparing range to criteria in E3 error results since range is in same format as D2.