Big number is showing exponential value after upload to CSV using Angular2Csv library

[vishnu siddareddy]

I am using Angular2Csv library for upload JSON data to CSV form. But the big number is showing in exponential format in excel sheet.

Number 3530123456789010 becomes like, 3.53012E+15

Is there any solution to avoid that?

exportToCSV = function (dataobj) {    
const options = {
          fieldSeparator: ',',
          quoteStrings: '"',
          decimalseparator: '.',
          showLabels: true,
          showTitle: true,
          headers: Object.keys(dataobj.data[0])
        };
       // console.log(JSON.stringify(data));
       new Angular2Csv(dataobj.data, 'My Report', options);
}

[abhay dhar]

Thats a normal issue i ncsv/excel. Try opening a blank document in excel and put the number 3530123456789010  it will change to Exp format

I think you should check if you can specify the type of column or cell type , so that csv can properly format and hold the data

[Charul Chavda]

Hi,

Change data type of your big number as string and not number, should resolve the issue 

Regards,

Charul

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.
To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.
To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

[Lucas Lacroix]

I just want to say:

This is not an issue with Angular but a limitation of Javascript. Javascript uses double floating point numbers internally which means you're limited to that formats precision for integer:

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Number/MAX_SAFE_INTEGER

This is a limitation of the standard and not specific to Angular or any plugin/addon.

On Wed, Aug 8, 2018 at 10:12 AM Charul Chavda <charu...@gmail.com> wrote:

Hi,

Change data type of your big number as string and not number, should resolve the issue 

Regards,

Charul

On Wednesday, August 8, 2018, vishnu siddareddy <vishnu...@gmail.com> wrote:

I am using Angular2Csv library for upload JSON data to CSV form. But the big number is showing in exponential format in excel sheet.

Number 3530123456789010 becomes like, 3.53012E+15

Is there any solution to avoid that?

exportToCSV = function (dataobj) {    
const options = {
          fieldSeparator: ',',
          quoteStrings: '"',
          decimalseparator: '.',
          showLabels: true,
          showTitle: true,
          headers: Object.keys(dataobj.data[0])
        };
       // console.log(JSON.stringify(data));
       new Angular2Csv(dataobj.data, 'My Report', options);
}

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--

Lucas Lacroix

Computer Scientist

Advanced Technology Division, MEDITECH

781-774-2293

                

Subscribe to receive emails from MEDITECH or to change email preferences.

[vishnu siddareddy]

But the value is coming from server. Can u please tell where I can able change the type?

On Wed, Aug 8, 2018, 7:42 PM Charul Chavda <charu...@gmail.com> wrote:

Hi,

Change data type of your big number as string and not number, should resolve the issue 

Regards,

Charul

On Wednesday, August 8, 2018, vishnu siddareddy <vishnu...@gmail.com> wrote:

I am using Angular2Csv library for upload JSON data to CSV form. But the big number is showing in exponential format in excel sheet.

Number 3530123456789010 becomes like, 3.53012E+15

Is there any solution to avoid that?

exportToCSV = function (dataobj) {    
const options = {
          fieldSeparator: ',',
          quoteStrings: '"',
          decimalseparator: '.',
          showLabels: true,
          showTitle: true,
          headers: Object.keys(dataobj.data[0])
        };
       // console.log(JSON.stringify(data));
       new Angular2Csv(dataobj.data, 'My Report', options);
}

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

[Charul Chavda]

U need to ask ur backend to give it u as astring as this is js limitation. I did the same long back.

Regards,

To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscribe@googlegroups.com.

[vishnu siddareddy]

Thanks, I will ask them to give as string.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.

To post to this group, send email to ang...@googlegroups.com.
Visit this group at https://groups.google.com/group/angular.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group.

To unsubscribe from this group and stop receiving emails from it, send an email to angular+u...@googlegroups.com.