OLE object question

[rgbcad]

Ok, I've brought into model space an Excel file as an OLE object. It shows up in model space, paper space, and on the plot preview. For some reason it DOES NOT plot. The frame plots but not the contents of the Excel file.

I missing something simple here but what am I not doing to get this object to plot?

[Glenn Pope]

Try setting the plot quality in the OLE's properties. Change it to monochrome and see if that fixes it.

[Capt. Computer Crasher]

Ok, I've brought into model space an Excel file as an OLE object. It shows up in model space, paper space, and on the plot preview. For some reason it DOES NOT plot. The frame plots but not the contents of the Excel file.

I missing something simple here but what am I not doing to get this object to plot?


Check your OPTIONS>>>>>Plot and Publish Tab. Look on the right hand side middle. Ole plot quality. See if changing that setting helps.

Also does it have to be an OLE object? Why don't you Copy/Paste Special as an AutoCAD Entities? If you have AutoCAD2008 or better you can even link them so if you update one the other is updated automatically.

[rgbcad]

Try setting the plot quality in the OLE's properties. Change it to monochrome and see if that fixes it.

Just tried that and it didn't change things.

here is the listing on one of the objects:

OLE Layer: "TB"
Space: Model space
Handle = 58f1a
Type: Embedded
Source Application: Microsoft Office Excel Workshee
At Point: X=2525465.48, Y=7044422.91, Z= 0.00
Width: 499.39
Height: 505.94
Rotation angle: 0.00
Plot Quality: Monochrome (e.g. spreadsheet)
Plot Frame: Yes

[rgbcad]

Also does it have to be an OLE object? Why don't you Copy/Paste Special as an AutoCAD Entities? If you have AutoCAD2008 or better you can even link them so if you update one the other is updated automatically.

Tried this and it worked.


Still don't understand why I can't get it to plot as an OLE object....

[scott.wilcox]

Make sure your ms viewport is set to 2D wireframe.

[cadtag]

Tried this and it worked.


Still don't understand why I can't get it to plot as an OLE object....

Think of OLE as the dancing bear of computing. The amazing thing is not that it dances well, but that it dances at all!. You've got multiple applications running, and it's (sometimes) possible to plug arbitrary information from one program into a completely different program that doesn't even work with the same kinds of information. It's really awsome.

Flip side being that it's fragile, trouble prone, not all that reliable (and especially with the Linking part) useless in a lot of corporate environments.

Anytime you can convert OLE into native objects, it's going to be more reliable.

[sandeep_koodal]

Just tried that and it didn't change things.

here is the listing on one of the objects:

OLE Layer: "TB"
Space: Model space
Handle = 58f1a
Type: Embedded
Source Application: Microsoft Office Excel Workshee
At Point: X=2525465.48, Y=7044422.91, Z= 0.00
Width: 499.39
Height: 505.94
Rotation angle: 0.00
Plot Quality: Monochrome (e.g. spreadsheet)
Plot Frame: Yes


Right click the OLE object and select properties; then change the OLE plot quality to Text (e.g. text document)
Try it

[murrayc.49304]

Here [after a long time of fiddling over the years] is what works for me:


1. Set OLEQUALITY to 0 (zero)
2. In Spreasheet, set all text format to TrueTypeFont.
3. After using the PASTESPEC command, select the OLE object and change properties to "Low Graphics"

The technique above is probably just a truncated of list of what others here have already suggested. But I've discovered this trick has to been done in the specific order listed above (well - it's what I have to do anyway)

[gleiper]

Had the same problem in 2007. Changed to monochrome in OLE printy quality properties. Prints great now.