export to CSV - file is not displayed in proper format for 25 digits

Answered
pallavi.yadav asked on March 22, 2022

when data is entered maximum 25 digits in the field then exported csv file is not displayed in proper format.
We have added mapping as well as mentioned below, but still its not support for csv file. Please refer attachment to refer how data shown on both files(csv & excel) for comparison.

mapping:{ "textNumber" : {type: "string"} }
data added to excel/csv file = 1234567890123456789012345
vesion => "ng-flexmonster": "^2.8.17"

Please guide us, how to show data on csv file properly as same as excel file.
Thanks,
Pallavi Y.

1 answer

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster March 23, 2022

Hello!
Thank you for contacting us!
 
Our team wants to inform you that we have checked the export with long numbers using your mapping example. The resulting CSV file had no floating-point representation.
To check your CSV, you can open the file in a plain text editor(like Notepad or Wordpad) and have a look at your numbers there.
 
As to the way Excel displays your CSV, please note that according to the CSV format specifications, CSV files contain only plain text without formatting(you can read more about the CSV format here).
 
We suggest either changing the data format after opening the file in Microsoft Excel or simply using export to Excel instead of CSV.
 
Please let us know if it works for you.
 
Regards,
Solomiia

Please login or Register to Submit Answer