https://community.qlik.com/t5/Talend-Studio/Excel-cell-formula-not-getting-calculated/m-p/2335531#M104080 <P>I am able to paste the excel formula in last column thru talend, after the successful transformation when i open the excel the formula is not showing the result. But, it was just displaying the formula i have hard-coded in talend tMap component. Please suggest.</P> Mon, 21 May 2018 09:50:22 GMT Anonymous 2018-05-21T09:50:22Z https://community.qlik.com/t5/Talend-Studio/Excel-cell-formula-not-getting-calculated/m-p/2335531#M104080 <P>I am able to paste the excel formula in last column thru talend, after the successful transformation when i open the excel the formula is not showing the result. But, it was just displaying the formula i have hard-coded in talend tMap component. Please suggest.</P> Mon, 21 May 2018 09:50:22 GMT https://community.qlik.com/t5/Talend-Studio/Excel-cell-formula-not-getting-calculated/m-p/2335531#M104080 Anonymous 2018-05-21T09:50:22Z https://community.qlik.com/t5/Talend-Studio/Excel-cell-formula-not-getting-calculated/m-p/2335532#M104081 <P>You cannot write formulas using the default Talend Excel components. You will need to use a Talend Exchange Component like the tFileExcelSheetOutput written by&nbsp;<A href="https://community.qlik.com/s/profile/0053p000007LKk8AAG">@lli</A></P> <P>&nbsp;</P> <P><A href="http://jan-lolling.de/talend/components/help/tFileExcelSheetOutput.pdf" target="_blank" rel="nofollow noopener noreferrer">http://jan-lolling.de/talend/components/help/tFileExcelSheetOutput.pdf</A></P> Mon, 21 May 2018 13:05:20 GMT https://community.qlik.com/t5/Talend-Studio/Excel-cell-formula-not-getting-calculated/m-p/2335532#M104081 Anonymous 2018-05-21T13:05:20Z