ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: omerix on October 01, 2019, 05:14:08 pm

Title: View cell format (Excel, Editable)
Post by: omerix on October 01, 2019, 05:14:08 pm

Hello,

I am using "dataType: 'xml'" to load my data.

I am using Microsoft SQL to prepare the xml file.

SQL gives me such output. : https://yadi.sk/i/tD0hZNuQDgasrQ

Columns with datatype "float" are unfortunately listed this way. 1.800000e+002 etc.

When viewing data in the Grid, dataType: 'float', format: '#, ###. 00 'makes it easier to view because I use it this way.
The screen output is very good.
Screen Picture: https://yadi.sk/i/1aEjTtBjS404Ag

But when I want to edit the cell, it looks like this picture.
Screen Picture: https://yadi.sk/i/7qHymFIXYiGvyQ

When I export to Excel, I get a similar image.
Screen Picture: https://yadi.sk/i/JdwRARlPZvwaWQ

Can I change the display of data when editing Excel and Cell?

Thanks

Title: Re: View cell format (Excel, Editable)
Post by: paramvir on October 01, 2019, 10:43:27 pm

Numbers with e notation are not supported in grid. Please convert them to number values.