https://bugs.documentfoundation.org/show_bug.cgi?id=59905
Jean-Baptiste Faure <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED CC| |[email protected] Resolution|--- |NOTABUG --- Comment #14 from Jean-Baptiste Faure <[email protected]> --- If you modify the formula in I8 to =DSUM($B$6:$G$30;$E$6;J8:O9) it does not return an error anymore because G6 is empty. The problem is to know where is the error, did you forgot the column G in the database range, or did you add an erroneously empty search criteria? I tend to prefer clear error message than trying to interpret user typing errors. empty/empty is a valid search criteria. If you do not have an empty header in you database range, it is not the role of Calc to decide if you made an error in the database range, in the search criteria or elsewhere. So closing as NotABug. Feel free to reopen if you disagree. In such a case please argue. Best regards. JBF -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
