CadTools and xTurn (Vehicle Turning Software) Forum

CadTools General Category => CadTools General => Topic started by: Branka on June 28, 2011, 02:05:44 PM

Title: Export blocks to excel
Post by: Branka on June 28, 2011, 02:05:44 PM

I have a problem when using command "Export block coordinates/attributes to Excel".
In fact, one of the export attributes is the name of the cadastral parcel which is usually written as a fraction 2/8 or 4/5 or 12/11 but after export some of these names are displayed as a date in excel.
For example 1/5 is displayed as 5.jan

The confusing thing is that most of the data is correctly displayed but a but few records (not same records) is always shown as the date.
Does anyone know what the problem is?
Thanks.

Title: Re: Export blocks to excel
Post by: Lars on June 28, 2011, 02:38:15 PM

Probably this is due formatting in Excel. When CadTools creates the Excel worksheet no formatting is done. You could try to change the formatting for the column to "text" in Excel but I don't think that will help, you will probably end up with a cell with a value. (5/2=2.5)

I'll change the code so CadTools creates text fields in Excel for all attributes and hope that will solve the problem.

Probably there will be a fix for this tomorrow.

/Lars

Title: Re: Export blocks to excel
Post by: Branka on June 28, 2011, 03:12:57 PM

You are right I try to change formatting for the column to "text" in Excel but it didn´t help.
Thanks for your quick response.