tFileExcelWorkbookSave - recalculate

_AnonymousUser — Thu, 27 Feb 2014 12:02:43 GMT

Hi Experts,
I have a problem with my Excelupdate. The Job runs well, but the formulas e.g. simple sum() is not being recalculated after writing my values into the sheet.
When I try to use the "Calculate all formulas" checkbox in the tFileExcelWorkbookSave, i always get dumps.
Any ideas?
See dumps below.

Exception in component tFileExcelWorkbookSave_1
org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell 'Deckblatt NT Blätter'!D70
	at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:357)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:298)
	at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:230)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:351)
	at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCell(HSSFFormulaEvaluator.java:2

To see the whole post, download it here

Re: tFileExcelWorkbookSave - recalculate

Anonymous — Thu, 27 Feb 2014 21:37:49 GMT

Yes, the Apache POI API does not cover all possibilities of Excel. Thats why you get these Exceptions. Formula evaluation is indeed only possible within the same sheet and also not all (but mostly all) functions.
The Apache project adds with every new release more and more functions. Thats why I update these components when ever a new release is available.
Sorry, but the components are limited to the POI features.
Please refer to the Apache POI doc to check which function is implemented and which is not:
Here the current list:
Address
AggregateFunction
BaseNumberUtils
Bin2Dec
BooleanFunction
CalendarFieldFunction
Choose
Code
Column
Columns
Complex
Count
Counta
Countblank
Countif
Countif.StringMatcher
Countifs
DateFunc
Days360
Dec2Bin
Dec2Hex
Delta
EDate
Errortype
Even
FactDouble
Finance
FinanceFunction
FinanceLib
Fixed0ArgFunction
Fixed1ArgFunction
Fixed2ArgFunction
Fixed3ArgFunction
Fixed4ArgFunction
Hex2Dec
Hlookup
Hyperlink
IfFunc
Imaginary
ImReal
Index
Indirect
Intercept
IPMT
Irr
LinearRegressionFunction
LogicalFunction
Lookup
Match
MinaMaxa
Mirr
Mode
MultiOperandNumericFunction
Na
NotImplementedFunction
Now
Npv
NumericFunction
NumericFunction.OneArg
NumericFunction.TwoArg
Oct2Dec
Odd
Offset
PPMT
Quotient
Rank
Rate
Replace
Rept
Roman
RowFunc
Rows
Slope
Substitute
Subtotal
Sumif
Sumifs
Sumproduct
Sumx2my2
Sumx2py2
Sumxmy2
T
TextFunction
TimeFunc
Today
Value
Vlookup
WeekdayFunc
WeekNum
XYNumericFunction
And here the URL:
http://poi.apache.org/spreadsheet/index.html

topic tFileExcelWorkbookSave - recalculate in Talend Studio

tFileExcelWorkbookSave - recalculate

Re: tFileExcelWorkbookSave - recalculate