Apache OpenOffice (AOO) Bugzilla – Issue 94150
sumif function problem after document import from excel
Last modified: 2013-03-01 10:52:55 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.
Created attachment 56700 [details] sample excel document
Created attachment 56701 [details] excel screen shoot
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.