Export CDT to Excel Smart Service

Question

Hi, 
 I am using the 'Export CDT To Excel' smart service to export report data to excel. There are multiple tabs in my template/output document which gets generated. I have a requirement to update my column header in second tab from tab1 cell (cell gets updated by smart service). I am just referring cell value in another tab header using excel formula 'firsttabname'!cell. 
 The header is not getting updated with cell value. Is this smart service support this? any pointers will be appreciated. 
 
 Thanks.

Josh · Answer

I believe the third party library used in this shared component does not re-evaluate cell formulas as it writes data to improve performance. I ran into a similar issue some time ago and the solution was to update the shared component to trigger a formula re-evaluation on the entire spreadsheet. These links may be of help: stackoverflow.com/.../using-apache-poi-hssf-how-can-i-refresh-all-formula-cells-at-once poi.apache.org/.../eval.html

Josh · Answer

My recommendation is to enhance the existing smart service. You can do so by requesting to update the component here: forum.appian.com/.../actions