poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Krupets" <pkrup...@yahoo.com>
Subject HSSF Functions Evaluations...
Date Wed, 26 Sep 2007 21:38:21 GMT
Hello,

1) Not sure why but you store parsed function in Excel file. When you load
it and want to calculate you parse it again. Why?
2) Parsed function stored in file is different from the one you get when
parse it using FormulaParser. As I understand you change it when you save it
so it will be in Excel format (or Excel stores them differently).

Maybe we should execute excel format? I mean make our internal format the
same as Excel format.


For instance -> SUM(A:B):

Our:

Area(A:B)
SUM()

Excel:

Area(A:B)
Attr(Sum)

In formula evaluator Attr is ignored ({ continue; }). And we have an error.

With regards,
Pavel Krupets


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message