alhazmy13/angular-csv-ext

Json members that are decimals getting cut off

Jamanya opened this issue · 1 comments

when exporting a dataset that has a float or decimal, it appears that this is truncating the numbers:

for example, we have a dataset field that follows a 7.5 pattern i. e 1234567.12345 in the csv, it appears like this '

231380.0023

where the above number should be 231380.00231

or if the number after the decimal place starts with 0, it completely removed everything after the decimal, for example,

it should be this:
2071090.00005

but getting this:
2071090

our dataset even though it looks like a float, this pattern is actually a string from the api

Looks like it was an issue with the default behavior of Microsoft Excel and how it treats data