Jump to content

OLE Plots as black box


rickats

Recommended Posts

I'm using AutoCAD 2008 and Excel 2007.

 

I tried importing a spreadsheet into AutoCAD, which worked great, everything is there that needs to be. But when I plot to PDF my spreadsheet is a black box.

 

When I open the PDF the data is still there from the spread sheet. I am able to highlight cells in the black box where they should be and copy+paste the data to another program.

 

When I do a plot preview there is no black box, the spreadsheet OLE shows up fine.

 

I don't know how to fix this issue. Any ideas?

 

Rick S.

Link to comment
Share on other sites

I figured out a work around.

 

It was the way I was importing the excel data apparently.

 

In AutoCAD 2008 I was going to Insert-> OLE Object... and point it at my spreadsheet. and the plot as black boxes.

 

Now, in excel I highlight what I want and copy, then paste special in AutoCAD, and it magically plots normal.

 

I have no idea what the difference is in doing it this way. But I don't have black boxes anymore.

Link to comment
Share on other sites

Glad you found a workaround. I've found that OLE's were just AutoDesk's way of adding interesting and random glitches into AutoCAD. I highly recommend you take a look at the Datalinked tables. Biggest difference is they are an autocad table element (vector) and not a raster image prone to wonky resizing at their own choosing.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...