On Jan 28, 2008 12:55 PM, Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Ain, > > On Monday, 2008-01-28 12:42:38 +0200, Ain Vagula wrote: > > > Does it mean, in OO.o COUNTIF handles only values? > > No, it means that COUNTIF doesn't handle empty cells, as all functions > iterating over a cell range don't. See also > http://qa.openoffice.org/issues/show_bug.cgi?id=65221 > > > Can't this be enhanced in future? > > Sure. Once we settled how to treat "emptiness" in all those functions, > see issue. > > Hm, looks like Excel's handling is even a bit dangerous... when user unfortunately deletes content of criteria cell, then this can lead to unintended results... OO.o just clearly gives empty result...
ain
