ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: gopigupta on January 18, 2024, 02:22:35 pm

Title: Data exported as text for numeric column
Post by: gopigupta on January 18, 2024, 02:22:35 pm

Hello,

I need one help for export.

I am exporting grid into excel file. The data for grid is coming from server side(.net code) and it is coming in text format for all columns even for numeric columns. I have kept datatype as "float" and format as "##,###.00" for numeric columns in grid but still when I export data, numeric columns are exported as text in excel file.

Is there any easy way to change data into numeric before we export it into grid.

Thanks.   

Title: Re: Data exported as text for numeric column
Post by: paramvir on January 18, 2024, 02:34:15 pm

you need to correct the server side code to return numbers for numeric columns.

or

convert string values to numbers in dataModel.getData callback.

Title: Re: Data exported as text for numeric column
Post by: gopigupta on January 18, 2024, 03:29:39 pm

Thanks you for quick response :)