@Dennis,
I agree that conforming to ODFF is first goal. I add comments and
attachment in https://issues.apache.org/ooo/show_bug.cgi?id=65221
From my understanding of ODFF, I give ODFF expect result for some formula
related with empty cell in the attachment(xls). If there is any mistake,
please
Hi all,
There is an old bug i65221(
https://issues.apache.org/ooo/show_bug.cgi?id=65221). It is about
interoperability with Excel for SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM,
... with empty cells and and = empty string criteria.
There is some discussion about it, but no conclusion. Some people
Hi,
[resend to ooo-dev]
On 02.07.2012 10:50, Lei Wang wrote:
Hi all,
There is an old bug i65221(
https://issues.apache.org/ooo/show_bug.cgi?id=65221). It is about
interoperability with Excel for SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM,
... with empty cells and and = empty string criteria.
On 02.07.2012 04:50, Lei Wang wrote:
Hi all,
There is an old bug i65221(
https://issues.apache.org/ooo/show_bug.cgi?id=65221). It is about
interoperability with Excel for SUMIF, COUNTIF, COUNTBLANK, DCOUNT,
DSUM,
... with empty cells and and = empty string criteria.
There is some discussion
@Andrew,
See latest comments on https://issues.apache.org/ooo/show_bug.cgi?id=65221
I agree with orw that the first goal should be to align with OpenFormula, and
that is specific about the use of Criteria in SUMIF, COUNTIF, etc., as you saw
in section 4.11.8.
In the case that there needs to