poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From avik.sengu...@itellix.com
Subject Re:FormulaEvaluator Partial Implementation
Date Tue, 10 May 2005 18:24:43 GMT
[Moving to the list, since bugzilla is bad for conversation]

Comments inline.

> **** As a result, you may have to apply the   ****
> **** patch to /src/scratchpad/src instead of  ****
> **** the root folder                          ****

That's ok. For the initial bit, can you just zip/tgz the directory. Provide
patches after the initial additions have been comitted. I am waiting to commit
till the dummy method javadocs are removed (maybe an awk script might be

> 1. Ptg and Eval: Delegating or extending?
> <snip> But I guess extending from Ptg could also work...

Just to clarify, by extend, i meant have a separate class that interits 
from the
Ptgs.. ie, `class AddEval extends AddPtg` .. but as I said, just a suggestion,
you'll know best.

> 2. Functions in one class or one class per function?

Yeah, sure.

> 3. Testing...
> Unit testing would be a big effort. Almost as big as writing individual
> functions, a distributed effort would be great!

Certainly, probably bigger. So once again, this is a call for everybody
interested in this functionality to write unit tests for it. Its easy!

> 4. My eclipse...

Please try and remove the extraneous comments, i dont want to put that in CVS.
I'll commit it as soon as that's done, I'm happy with everything else.

> 5. Under contruction:
> The work on core eval classes is not yet "complete". I think there is 
> need for a
> BlankEval class to handle empty cells - which are currently being handled as
> StringEval("").

Yeah, sure, thats understood, and no issues. But your 'empty cell'  
comment made
me think, the function implementations should probably follow Excel 
for eg, in the average function, empty cells do not add to the number of
elements (ie, the denominator). Also, these semantics might be different for
different versions of excel. How do we handle that.

A final thoguht on error handling. Your error handling is modelled after OO.o.
In excel however, errors are a more limited set.. #REF, #VALUE, etc. Do 
we need
to think about how to handle/map those. Maybe it doesnt matter?

Once again, to everybody out there, this is a big and important piece of work
that can certainly do with more evaluation/comments/unit tests. Thanks!


To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/

View raw message