grid export and print

[lightonbParticipant]

When I am printing or exporting a grid to csv, it is turning my large ID numbers into decimals with commas.
eg.
It turns Id 999999, into 999,999.00 when it is printed or exported.
The number appears correct inside the grid.

[Ivo ZhulevParticipant]

Hi lightonb,

We cant see such behavior. Are you using the latest version of jQWidgets(4.1.2) ?

Best Regards,
Ivo

jQWidgets Team
http://www.jqwidgets.com/

[lightonbParticipant]

Hi, yes I am using 4.1.2, downloaded last week.
Does it have something to do with the way the data is being displayed in the grid on load?

Should I be defining some kind of datatype when setting up the columns below?

columns: [
     {text: 'Key ID', datafield: 'key_id', width: 80},
     {text: 'Emp ID', datafield: 'emp_id', width: 60},
     {text: 'Full Name', datafield: 'fullname', width: 150},
     {text: 'Key Cut', datafield: 'key_cut', width: 80},		
     {text: 'Key Date', datafield: 'key_date', cellsformat: 'MM/dd/yyyy', width: 100},		
     {text: 'Key Status', datafield: 'key_status', width: 80},
     {text: 'Last Updated', datafield: 'last_updated', width: 110},
     {text: 'Last Updated By', datafield: 'last_updated_by', width: 130}
]	

[lightonbParticipant]

I’ve looked at the database and additional info:
emp_id is number(6). – This value displays correctly when exported or printed.
key_cut and key_id are varchar(7), and are being converted to 00,000.00
All 3 display fin in the grid, just being vonverted when exported or printed.

[lightonbParticipant]

Thanks for all the help.
Glad I tested before purchasing anything.

[Author]

Posts