Exported Structure sets all character fields to 48 width

Forum for DBF Commander discussing.

Exported Structure sets all character fields to 48 width

Postby FluidEdge » Thu Sep 25, 2014 5:34 pm

2014-09-25_10-18-42.jpg
2014-09-25_10-18-42.jpg (71.46 KiB) Viewed 26561 times
I am exporting the DBF structure using the structure command I have submitted the before and after of the file structure. No matter what the original field length is, all the exported field lengths are 48.
Attachments
2014-09-25_10-20-59.jpg
2014-09-25_10-20-59.jpg (99.58 KiB) Viewed 26561 times
FluidEdge
 
Posts: 2
Joined: Wed Sep 24, 2014 10:44 pm

Re: Exported Structure sets all character fields to 48 width

Postby Admin » Thu Sep 25, 2014 9:06 pm

The issue related to showing the data in Excel - the actual data in the sheet's cell is correct. Please select the entire column (e.g. Width), right-click on it and select 'Format Cells...' context menu item. Set number format with 0 decimal places and click OK. The cells will have correct appearance.
The issue will be fixed in one of the next releases.

P.S. You can also export to XLS instead of XLSX to avoid the issue.
Best regards,
Oleg Zhechkov
User avatar
Admin
Site Admin
 
Posts: 124
Joined: Wed Apr 21, 2010 7:27 pm

Re: Exported Structure sets all character fields to 48 width

Postby FluidEdge » Fri Sep 26, 2014 2:22 am

It worked! Awesome.
FluidEdge
 
Posts: 2
Joined: Wed Sep 24, 2014 10:44 pm


Return to DBF Commander Professional

Who is online

Users browsing this forum: No registered users and 11 guests

cron