topic tFileExcelWorkbook - existing formulas are broken in Talend Studio

tFileExcelWorkbook - existing formulas are broken

Anonymous — Sun, 08 Nov 2015 08:21:38 GMT

I have a excel sheet (xls) with formulas inside and when I update it with tFileExcelWorkbookopen - save, the formula are not recalculating when open the file. All the options are setup to automatic calculation.

Any idea what to do for having the formula calculating after update with the components?

thanks,

Re: tFileExcelWorkbook - existing formulas are broken

Anonymous — Tue, 10 Nov 2015 03:30:13 GMT

Hi,
This is a custom component developed and shared by jlolling. We have notified your quesiton to jlolling, hope that he will come back to you soon.

Best regards
Sabrina

Re: tFileExcelWorkbook - existing formulas are broken

Anonymous — Tue, 10 Nov 2015 07:38:12 GMT

Did you checked the option "Evaluate all formulas" in the tFileExcelWorkbookSave component?
And actually Excel calculates all formulas also while opening the file.
Can you please describe a bit deeper where is your problem.
I got you open a file with formulas and you cannot access the values, correct?
I which way you have written the formulas, Excel immediately calculates so called shadow values and these values are what you will get in my components when you have access to such a field.