AutoCAD Electrical General Discussion

AutoCAD Electrical General Discussion

Reply
Distinguished Contributor
CAD-ICE
Posts: 306
Registered: ‎02-21-2009
Message 1 of 3 (215 Views)

Importing from spreadsheet

215 Views, 2 Replies
12-05-2012 09:07 AM

Hi there,

I´m using ACADE2013.

When importing from spreadsheet I have inserted some values on the Rating2 attribute that have fractions like 5,2 etc..

When I import the values back from spreadsheet the value on my drawing are shown with 4 decimals like 5,2000 (see attached image). I´m sure that this has something to do with some settings either in Excel og Autocad Electrical.

Anyone have a clue what´s causing this behaviour ?

Thx, regards, Gary

*Expert Elite*
rhesusminus
Posts: 982
Registered: ‎09-21-2007
Message 2 of 3 (196 Views)

Re: Importing from spreadsheet

12-06-2012 05:54 AM in reply to: CAD-ICE

Hi Gary.

 

I can't reproduce this here, with AcadE 2013 and Excel 2013 Preview.

If you try to "force" the value to be a text value and not a numerical value, does this help?
You can do this by adding an apostrophe in front of the value in excel.

Like this:

 

'2,5

 

 


Trond Hasse Lie

ECAD Consultant, CtrlAltEl

Please select "Accept As Solution" if this post answers your question. Kudos don't hurt either. ;-)
Distinguished Contributor
CAD-ICE
Posts: 306
Registered: ‎02-21-2009
Message 3 of 3 (145 Views)

Re: Importing from spreadsheet

12-13-2012 02:42 AM in reply to: rhesusminus

Hi RhesusMinus... and sorry for the late reply.

Thank´s for the advice but somehow it doesn´t help changing the format  of the cell to a textvalue.

I´m using Excel 2007 and that might be the cause of this issue.

I´m seeing some strange issues with ACADE2013 especially regarding database issues for instance when using the import/export utility.

I´m upgrading soon to a new pc...hopefully these issues will vanish when that´s over :smileyhappy:

 

Regards, Gary

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.