Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||sumif function problem after document import from excel|
|Component:||formatting||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Version:||OOo 3.0 RC2|
|Issue Type:||DEFECT||Latest Confirmation in:||3.4.1|
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 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.