ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: cosconit on January 18, 2021, 01:32:48 pm

Title: How avoid scientific notation when Excel export
Post by: cosconit on January 18, 2021, 01:32:48 pm

How avoid scientific notation when Excel export

Title: Re: How avoid scientific notation when Excel export
Post by: paramvir 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.

Title: Re: How avoid scientific notation when Excel export
Post by: cosconit on January 20, 2021, 06:19:21 am

Could you show me some examples?

Title: Re: How avoid scientific notation when Excel export
Post by: cosconit 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

Title: Re: How avoid scientific notation when Excel export
Post by: paramvir 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.

Title: Re: How avoid scientific notation when Excel export
Post by: irshaid on May 10, 2021, 05:44:25 pm

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

Title: Re: How avoid scientific notation when Excel export
Post by: paramvir 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.