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: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
