• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Civil 3D

    Reply
    Active Member
    Posts: 7
    Registered: ‎11-18-2009

    Paste Special from Excel

    240 Views, 3 Replies
    11-16-2012 09:26 AM

    We have Autocad C3D2012 64 bit and Microsoft Excel 2010. I have never had a problem with copying a spreadsheet to the clipboard and pasting special as autocad entities with previous versions until 2012. It has to be a setting in autocad somewhere but I can't figure it out. When I paste special. the text comes in at color 0,0,0 instead of by layer or index color 7 (white). If I have a black screen 0,0,0 cannot be seen. One of my coworkers tried my spreadsheet on his computer and it comes in color 7. What can I do to fix this?  Thanks!

    Please use plain text.
    *Expert Elite*
    antoniovinci
    Posts: 1,096
    Registered: ‎06-03-2011

    Re: Paste Special from Excel

    11-16-2012 11:42 AM in reply to: jbonin

    At home I've neither Autocad nor Excel, so I cannot try it, but.. what happens if you set as "Automatic" the table color in Excel, before copying?

    Please use plain text.
    Active Member
    Posts: 7
    Registered: ‎11-18-2009

    Re: Paste Special from Excel

    11-16-2012 11:47 AM in reply to: antoniovinci

    I gave that a try and it is still the same. Color 0,0,0 Thanks for trying!

    Please use plain text.
    *Pro
    Posts: 1,390
    Registered: ‎12-14-2006

    Re: Paste Special from Excel

    11-21-2012 11:01 AM in reply to: jbonin

    try pasting the text into a mtext object.

     

     

    Dan

    Civil 3D 2013
    Win 7 Pro x64
    Intel Xeon 2.0GHz
    6Gb Ram
    ATI Firepro 4800
    Dell T5500
    www.preinnewhof.com
    Please use plain text.