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.
Discussion posts and replies are publicly visible
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