FSG Formatting in Excel using FSGXML: Basic Excel Template
Hi,
We are upgrading from 11.5.10.2 to 12.1.3 and at the same time switching from using Report Manager for publishing our FSG's, to using the concurrent programs "Program – Publish FSG Report" & "Program – Publish FSG Report Set". However I am having some issues with the resulting number formatting in Excel and am hoping for some help.
As per note 1472787.1 there are 2 standard Excel templates available for formatting FSG's - "FSGXML: Basic Excel Template" & "FSGXML: Basic Excel Template (Raw Amounts)".
Publishing a report using "FSGXML: Basic Excel Template (Raw Amounts)" means that the exact figures are displayed with no formatting.
Publishing a report using "FSGXML: Basic Excel Template" leads to numbers being formatted as per the report definition, including thousands separators.