Exporting to XLS

Applications Grid / Reports
#1

Hi, I have some grids where I need to export data to a xls file, the problem is that some fields are being formatted and change its value.

I have 4 fields, id - brand - model - serial, the last one (serial) consists in numeric digits like 2350099430329024390, but when I export the grid to xls, the serial numbers are formatted in 2350099430329024000 (last 3 or 4 digits change to 0000).

How can I fix this?

#2

Re: Exporting to XLS

Are these numeric fields that contain the numeric digits? If you change the type to a string, do you get the same thing?
If you export to XLS using phpMyAdmin (or the DB manager that you use), does this happen as well?
Does this happen if you export to another format? (csv,pdf, etc).

I suspect that XLS is truncating and padding, but it could be the export as well. See if you can narrow it down using the options above.

Regards,
Scott.

#3

Re: Exporting to XLS

If I change the field to string, same thing happens. If I export to PDF the serial number is OK. It only happens with XLS

#4

Re: Exporting to XLS

Not to repetitive, but does it happen from any app to XLS or just SC5 export? ie, using a DB manager export to XLS?

Regards,
Scott.

#5

Re: Exporting to XLS

let me try with other app…

#6

Re: Exporting to XLS

I tried exporting with PhpMyAdmin and it was ok.

#7

Re: Exporting to XLS

I would contact support@netmake.com.br and report it to bugs@netmake.com.br

btw, perhaps the decimal precision might be set to cause this? have you tried changing it to a high value, or looking at other field formatting?

Regards,
Scott.