topic Re: Excel: Formulas not updated in Talend Studio

Excel: Formulas not updated

Anonymous — Thu, 09 Jun 2016 16:34:33 GMT

Hi,
I have some issues when updating an excel template containing formulas.
I update the first two columns of my excel file, and I have some formulas that use these data.
My issue is that after I run my job and updated the datas, when I open my excel file, my formulas are not automatically updated. I need to perform a bulk update of the sheet (using control-maj-alt-F9 for example) to get the right calculation.
Small example to explain :
In A1, I have a value : 1 for example
In B1, I have a formula : =A1*2
I run my job and update A1 with the value 2
When I opened the excel sheet, I still get 2 in B1
Do you have any idea to ensure that my formula are recalculated when opening excel sheet ?
Thanks for your advises

Re: Excel: Formulas not updated

Anonymous — Wed, 15 Jun 2016 08:34:52 GMT

Hi,
What does your current job design look like? Are you using tfileoutputexcel component?
Have you already checked option "Recalculate formula" which is used to recalculate formula(s) in the specified Excel file?
Please take a look at component reference:TalendHelpCenter:tFileOutputExcel.
Best regards
Sabrina

Re: Excel: Formulas not updated

Anonymous — Thu, 21 May 2020 05:33:03 GMT

Hi @xdshi ,

where I can find the checkbox for Recalculate Formula?

is there a specific version for this feature in tFileOutputExcel?

Please help, This is what exactly I need.

Thank you

Re: Excel: Formulas not updated

Anonymous — Thu, 21 May 2020 05:45:12 GMT

I found it in advance settings

but is there another way to do recalculate formula without

appending existing sheet?

because this option is only available when

append existing file and sheet are checked.

Thank you