Issue 94150

Summary: sumif function problem after document import from excel
Product: Calc Reporter: mareksm <mareksm>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: elish, issues
Version: OOo 3.0 RC2   
Target Milestone: ---   
Hardware: Sun   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 3.4.1
Developer Difficulty: ---
Attachments:
Description Flags
sample excel document
none
excel screen shoot none

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
argument.

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.