Results 1 to 3 of 3

Thread: Exel spreadsheet copy/paste autocad 2006 loosing color information

  1. #1
    Member
    Join Date
    2005-09
    Posts
    11
    Login to Give a bone
    0

    Question Exel spreadsheet copy/paste autocad 2006 loosing color information

    Hallo Cad-users
    I try to copy/paste a MS Exel spreadsheet into Autocad 2006.
    The spreadsheet is make with a "conditional formatting" on the cells
    By this way I can give the values in the cells a different color.
    Cell value is greater than or equal to =$c14
    The color for the value becomes than for example "red"
    Cell value is between - a formula than the value becomes than for example "blue"
    After selecting the spreadsheet (cells values with colors green. red, blue, black)
    and then a copy to clipboard.
    I do the following in Autocad, Edit, Paste Special, Microsoft a Exel Spreadsheet.
    (try both paste and paste link)
    The spreadsheet is placed into the autocad drawing, 100% looks in Exel, the colors
    in the cells are the same as in Exel.
    But I was very surprised when I print to PDF or Postcript I loose the color information
    of the cells. (it disappears)
    On the Screen/Monitor everything looks good.
    When I choose paste special "AutoCAD entities" I also see strange things a lot of the cells
    becomes green and the formulas becomes #
    When I have to modify the hole spreadsheet with a lot of columns and rows for much
    cells on a manual way than that is a lot of work.
    Is there someone with a solution for this question ?
    thanks in advance,
    Theo van Rossum
    ros@geodelft.nl
    Attached Images Attached Images

  2. #2
    100 Club Olaf.Banckaert's Avatar
    Join Date
    2006-02
    Location
    Belgium
    Posts
    133
    Login to Give a bone
    0

    Default Re: Exel spreadsheet copy/paste autocad 2006 loosing color information

    Hy ros,

    Are you using ADT or plain AutoCAD?
    With ADT I have no problems. Tried it you're way and with C&P and both works fine.
    The only thing I can think of right now, maybe you’re plottingpens are set to black.

    GreetZzz

  3. #3
    Member
    Join Date
    2005-09
    Posts
    11
    Login to Give a bone
    0

    Default Re: Exel spreadsheet copy/paste autocad 2006 loosing color information

    Hallo Olaf,
    I use plain Autocad 2006, the pens for plotting are in color, because the rest of the
    drawing is in color when I plot it. ( both pdf and a plot to a color plotter the only thing
    not in color is the spreadsheet)

    Thanks for your reaction on my question, regards Theo

Similar Threads

  1. Copy/Paste AutoCAD 2010 MDT
    By LightCutter in forum MDT - General
    Replies: 0
    Last Post: 2009-07-14, 07:33 PM
  2. AutoCAD 2006 - Tool Palettes loosing blocks order
    By derek.96018 in forum AutoCAD Customization
    Replies: 14
    Last Post: 2008-03-31, 02:40 PM
  3. Copy/Paste From Autocad
    By inventor.wishlist1738 in forum Inventor Wish List
    Replies: 0
    Last Post: 2006-08-07, 03:33 PM
  4. Spreadsheet distorted in AutoCAD 2006 after editing
    By mhollar in forum AutoCAD General
    Replies: 3
    Last Post: 2006-02-01, 03:40 PM
  5. Copy and Paste Special from spreadsheet
    By simbenghai in forum AutoCAD Tables
    Replies: 1
    Last Post: 2006-02-01, 02:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •