Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Special SUM function which gives empty as a result of only empty cells|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, oc, openoffice|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description ooo 2003-02-11 10:22:29 UTC
Issue 11144 concerning chancing the SUM function so it returns nothing when all cells where empty will not be fixed because of compatibility to Microsoft Excel. So instead I will propose a new special SUM function which will return nothing and not a zero when all the cells are empty. Suggestion is SUM_EMPTY() Which works as SUM except that it returns nothing if all cells are empty.
Comment 1 oc 2003-03-05 12:36:03 UTC
Hi Bettina, one4you
Comment 2 mariosv 2005-01-21 00:11:37 UTC
Why not use the COUNT() to kown if all cells are empty.
Comment 3 ooo 2005-02-09 00:37:56 UTC
The COUNT() function doesn't gives the wanted result. If all the cells in the area are empty then the result should be empty. If at least one cell in the area has a value then the result should be the sum of all the cells in the area.
Comment 4 drking 2006-11-25 15:39:37 UTC
My humble suggestion would be that Calc has enough functions as it is. One way to achieve the desired result with existing functions would be: =IF(COUNTBLANK(range)=no_of_cells_in_range;"";SUM(range)) eg =IF(COUNTBLANK(A1:B2)=4;"";SUM(A1:B2)) Does that mean the issue can be closed? HTH
Comment 5 bettina.haberer 2010-05-21 14:49:24 UTC
To grep the issues easier via "requirements" I put the issues currently lying on my owner to the owner "requirements".