Report Definition formatting incorrect on export to Excel
Some data is not formatted as expected on the Report Definition (RD) when exported to Excel.
Steps to Reproduce
1. Create RD with date, some text type properties and make sure text property contains number values
2. Check the 'ignore formatting' option on the Export to Excel.
3. Run the RD.
A software use or operation error.
When the ignore formatting option is selected, the report values are not formatted and export the stored values to the CSV file. Excel then applies its default formatting.
Here’s the explanation for the reported behavior:
The system is working as designed. Developer can format properties for the report using functions.
Published February 7, 2017 - Updated October 8, 2020
Was this useful?
0% found this useful
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.