[sc-issues] [Issue 11383] Special SUM function which gives empty as a result of only empty cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11383 User drking changed the following: What|Old value |New value CC|'oc' |'drking,oc' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 11383] Special SUM function which gives empty as a result of only empty cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11383 --- Additional comments from [EMAIL PROTECTED] Sat Nov 25 07:39:37 -0800 2006 --- 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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 11383] Special SUM function which gives empty as a result of only empty cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11383 --- Additional comments from [EMAIL PROTECTED] Tue Feb 8 16:37:56 -0800 2005 --- 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. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 11383] Special SUM function which gives empty as a result of only empty cells
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=11383 --- Additional comments from [EMAIL PROTECTED] Thu Jan 20 16:11:37 -0800 2005 --- Why not use the COUNT() to kown if all cells are empty. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
