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

cosconit

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 11
    • View Profile
How avoid scientific notation when Excel export
« on: January 18, 2021, 01:32:48 pm »
How avoid scientific notation when Excel export

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile
Re: How avoid scientific notation when Excel export
« 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

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: How avoid scientific notation when Excel export
« Reply #2 on: January 20, 2021, 06:19:21 am »
Could you show me some examples?

cosconit

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 11
    • View Profile
Re: How avoid scientific notation when Excel export
« 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

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile
Re: How avoid scientific notation when Excel export
« 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.
« Last Edit: January 20, 2021, 03:26:14 pm by paramvir »

irshaid

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 1
    • View Profile
Re: How avoid scientific notation when Excel export
« 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

  • Administrator
  • Hero Member
  • *****
  • Posts: 6113
    • View Profile
Re: How avoid scientific notation when Excel export
« 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.