incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Hart <jh...@testra.com>
Subject Re: [Calc][Discuss]Interoperability with Excel for SUMIF, COUNTIF, COUNTBLANK, DCOUNT, DSUM, ... with empty cells and "" and ="" empty string criteria.
Date Mon, 02 Jul 2012 10:31:09 GMT
What would excite me would be an option to vector cell functions to user 
code and translate existing functions into macros. This would make 
compatibility a user solvable problem and open up new markets not served 
by MS. such as PCB design with a spread sheet. I have the macros.



On 7/2/2012 2:53 AM, Oliver-Rainer Wittmann wrote:
> Hi,
>
> 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.
>>
>> There is some discussion about it, but no conclusion. Some people think
>> Excel does not do well, so simply mimicking Excel behavior might not 
>> be the
>> best idea. Some people think self-consistency in Calc is more important.
>> Some people think compatibility with Excel is a huge concern.
>>
>> IMHO, compatible with Excel is very important. I suggest changing these
>> formulas behavior according to Excel. Following is my consideration
>> 1)Most people use Excel, compatible with Excel is very important. Excel
>> does not show self-consistency in some scenarios, Calc doe not show
>> self-consistency either.
>> 2)Some frequently used function, such as calculating empty cells, can 
>> not
>> be implemented by Calc, while Excel can.
>> 3)Although Excel does not show self-consistency in some scenarios. These
>> scenarios are all related with pure empty cell. Excel use following 
>> rules
>>    When empty cell is criteria, only cells with value 0 meet it. This is
>> true for COUNTIF, SUMIF. But not true for DSUM/DCOUNT/IF.
>>    When an empty cell in a cell range, it can meet empty string 
>> criteria.
>> This is true for COUNTIF, SUMIF. But not true for DSUM/DCOUNT.
>>
>
> first, I am not familar with spreadsheet formulas.
>
> I agree that interoperability with Microsoft Excel is important. But 
> also important and from my point of view even more important is the 
> conformance to ODF 1.2.
> I do not know, if the needed changes would cause an unconformance with 
> ODF 1.2. If yes, things will be complicated.
>
> just my thoughts from an ODF perspective.
>
>
> Best regards, Oliver.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message