Author Topic: How avoid scientific notation when Excel export (Read 2310 times)

cosconit · « **on:** January 18, 2021, 01:32:48 pm »

How avoid scientific notation when Excel export

paramvir · « **Reply #1 on:** January 19, 2021, 03:14:16 pm »

you can try adding format: "0" to such cells in the js workbook.

1) Export the grid to intermediate js workbook

2) Add format: "0" to such cells with large values.

3) Export js workbook to Excel.

cosconit · « **Reply #2 on:** January 20, 2021, 06:19:21 am »

Could you show me some examples?

cosconit · « **Reply #3 on:** January 20, 2021, 07:49:24 am »

The actual value is 34300E7 which is string, how can I avoid scientific notation when Excel export

paramvir · « **Reply #4 on:** January 20, 2021, 03:21:32 pm »

"34300E7" is exported as "34300E7" by grid but the problem lies in how Excel interprets such strings.

and I don't see any way in Excel to interpret 34300E7 or any strings composed of numbers with letter "E" in them as string.

irshaid · « **Reply #5 on:** May 10, 2021, 05:44:25 pm »

Hello
i have same problem my value is 234234234234234234234234 but is a string not number

paramvir · « **Reply #6 on:** May 11, 2021, 06:30:26 pm »

irshaid

Currently there is no solution for it. I'm looking into it to add support for it in upcoming versions.

Author Topic: How avoid scientific notation when Excel export (Read 2310 times)

cosconit

How avoid scientific notation when Excel export

paramvir

Re: How avoid scientific notation when Excel export

cosconit

Re: How avoid scientific notation when Excel export

cosconit

Re: How avoid scientific notation when Excel export

paramvir

Re: How avoid scientific notation when Excel export

irshaid

Re: How avoid scientific notation when Excel export

paramvir

Re: How avoid scientific notation when Excel export