Hi Dave,

To be perfectly honest with you, OLE has its limitations - really it is geared towards very simple operations like embedding an image.  It is not intended for hosting large spreadsheets in drawings, and in fact I think you may be attacking this from the wrong angle altogether.

Forget for a minute what you are trying do and think about what is the problem you are trying to solve.  For instance, is the problem that you want the spreadsheet data and the drawing to be printed on the same piece of paper?  Or is it that you want a simple, self-contained way for people to be able to cross reference the text and the drawing? 

Note that these are statements are not 'leading' in the way that "I want to insert a spreadsheet" is.  By looking at what you need to achieve we can usually figure out the best solution for any particular task.  For example, it may be that you'll get what you need by simply pasting the drawing into the spreadsheet.

So, what is the problem you're trying to solve?

Kind regards,
Rob Robinson
Stardraw.com

Rob -

No go on the suggestions I am afraid.  Neither approach seems to work.   I get a 7X10 grid when I initially insert the object (either new or file) and I am unable to resize to accomodate the area I need on the original spreadsheet.   When I attempt to change the object size, it simply enlarges the grid and does not increase the area.  

I am under pressure to insert this wire chart for submittal on a project.   Please see the attached spreadsheet file that I am trying to insert.   I need an answer to this problem ASAP.

Yes, that's right.

You could try a couple of different techniques to get the spreadsheet info in:

1. Copy your spreadsheet then in Stardraw select Edit | Insert New Object, then Create New | Microsoft Office Excel Worksheet and paste in the data from your spreadsheet.
2. Select Edit | Insert New Object, then Create from File, navigate to your spreadsheet and choose OK (will require re-sizing)

Kind regards,
Rob Robinson
Stardraw.com

Rob -



Are you referring to the black rectangle that is in the background after inserting the object?



dg

Yes, it can be done but it is fiddly and appropriate sizing/scaling can only be achieved through trial and error.  Unfortunately I can't offer any further advice other than to try and get the proportions of the OLE window (the rectangle that hosts the spreadsheet) the same as the area being inserted then, to scale, hold down the Shift key while dragging a corner handle as this will maintain those exact proportions.

Kind regards,
Rob Robinson
Stardraw.com

I am working on a set of drawings that need to have a Excel spreadsheet inserted. I have been struggling with this for a couple of days and can't seem to make the scale and sizing work properly. Is there documentation that could assist me with this task? Can it be done?



dg