Author Topic: Export blocks to excel  (Read 13773 times)

Branka

  • Newbie
  • *
  • Posts: 6
Export blocks to excel
« 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.

Lars

  • Administrator
  • Hero Member
  • *****
  • Posts: 664
Re: Export blocks to excel
« Reply #1 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

Branka

  • Newbie
  • *
  • Posts: 6
Re: Export blocks to excel
« Reply #2 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.