The datatype has records which contain values like 1.0, 2.0, 3.0. But on exporting these to excel, the same values are displayed as 1, 2, 3 respectively. Is it possible to retain the same format while exporting the records to excel?
I am not generating excel based on excel template.
In the data type we have records which are having 1.0, 2.0 values. There is an export button towards left where you can download the excel with all the entries. In the downloaded excel, the values are displayed as 1 and not as 1.0. Is there any solution for this?
Looks like There is no solution for this,even if you ignore formatting while exporting it to excel and even if you keep rounding off to default (when column format as number) in the options(gear icon), after the export to excel it will remove the decimal values & it will display 1.0 as 1 and 1.80 as 1.8
Posted: 7 months ago
Posted: 8 Jul 2022 11:44 EDT
Byshu Ayyappaswamy (Byshu_Ayyappaswamy)
pxDownloadDataRecordsAsCSV activity calls another activity pzExportDataUsingResultSet & it uses Engine API to export the data from database table using native SQL. So what ever is stored in table gets exported as is. Hence data conversion could not be done.