Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||SUMIF Bug when Comparing Against "" (For Blank Cells)|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||elish, issues, oliver.brinzing|
|Issue Type:||DEFECT||Latest Confirmation in:||4.0.0|
Description dgm0814 2010-12-19 22:52:14 UTC
Example: =sumif(C1:C3,"",B1:B3) This should sum up B1:B3 if the cells C1:C3 are blank. This does work in Excel but does not work in Open Office. NOTE: If you do =if(A2="","IsBlank","IsNotBlank") the "" works to compare for a blank cell. SumIf should do the same.
Comment 1 Oliver Brinzing 2010-12-20 17:28:45 UTC
Comment 2 dgm0814 2010-12-21 00:20:16 UTC
This did resolve my issue for new excel documents I create, but does not help with documents that are sent to me. Hopefully this is resolved in a future release as this has caused some problems in financial documents that have been sent to me for review. Thanks for the workaround.
Comment 3 Edwin Sharp 2013-08-22 18:18:36 UTC
Created xls with Excel 2010. Opened with Rev. 1513819. =sumif(C1:C3,"",B1:B3) gives 0 instead 21 when C1:C3 are empty and B1:B3=7,7,7.