Page 1 of 1
Exporting to Excel as XLS
Posted: Tue Dec 09, 2014 10:56 am
by Anne_Phillips
When we export to CSV the fields are correct. But if we export to XLS then the character fields are truncated to 39 characters? We set printername=CSV for CSV files and printername=W for XLS. Any help would be greatly appreciated.
=> RE: Exporting to Excel as XLS
Posted: Thu Dec 11, 2014 5:49 am
by Anne_Phillips
I can answer my own question. When you export to CSV the field size in the report is irrelevant. But XLS behaves like a displayed report and therefore you have to specify an appropriately large field size__
==> RE: Exporting to Excel as XLS
Posted: Mon Jan 12, 2015 12:58 pm
by cstrasser
I^ve noticed this within Excel as well. If you still have Excel 2003, and can create your own DBFs, you need to make the columns wide enough to display all the data, otherwise Excel uses some sort of algorithm to determine how wide the field is intended to be and you might wind up with truncation.