Pasting an object into a worksheet MathCad Help

Instead of inserting an object through the Insert Object dialog box, you can copy an object from a source application to the clipboard and paste it into Mathcad. This method is particularly useful when you’ve already created the object in another application and you don’t want to insert an entire file. To insert an embedded or linked object into a worksheet via the clipboard:
• Open the source application containing the object.
• Copy the object to the clipboard in the source application. You typically do this by choosing Copy from the Edit menu, or by pressing [Ctrl]C.
• Click in the Mathcad worksheet where you’d like to place the object.
• Choose Paste or Paste Special from Mathcad’s Edit menu.
If you choose Paste, the object will be pasted in your Mathcad worksheet in a format that depends on what the source application has placed on the clipboard. The behavior may differ depending on whether you have selected a math placeholder or are pasting into a blank space in the worksheet. Mathcad will create one of the following:
• A matrix, if you are pasting numeric data from the clipboard into an empty math placeholder. (See Chapter 19, “Data Management.”)
• A text region, if you are pasting text that does not contain numeric data exclusive very. ,A
• A bitmap or picture (meta file), if the originating application generates graphics. (See Chapter 28, “Importing and Exporting Graphics.”)
• An embedded object, if the originating application supports OLE.
If you choose Paste Special from the Edit menu, you have the option of pasting the object in one of the available formats, which depend on the object you’ve copied. Typically you can choose to paste the object as an embedded or linked OLE object (if the object was stored in a saved file in an OLE-compatible source application), a picture (meta file), or a bitmap.

Dragging and dropping an object into a worksheet

A third way to insert an OLE object into a Mathcad worksheet is to drag it from the source application and drop it into the worksheet. This is very similar to copying and pasting, but does not allow you to create a link to an object. To do so:
• Open both Mathcad and the source application and arrange the two windows side by side on the screen.
• Select the object in the source application, usually by drag-selecting.

• Hold the mouse button down. For some applications, it may be necessary to press the [Ctrl] key and hold the mouse button down to ensure that the object will be copied (rather than cut) from the source application.
• Drag the cursor onto a blank space in the Mathcad worksheet.
• Let go of the mouse button to drop the object into the worksheet.

Editing an object

To edit either an embedded or linked object in a Mathcad worksheet, double-click the object. Mathcad’s menus and toolbar will change to those of the source application, and a hatched border will surround the object so that you can edit it. This OLE editing mechanism is called in-place activation. For example, you can use in-place activation to edit objects created by Microsoft Office 95 or 97 applications such as Excel and Word inside Mathcad If the source application does not support in-place activation inside Mathcad, the behavior will differ. In the case of an embedded object, a copy of the object is placed into a window from the other application. If the object is linked, the source application opens the file containing the object

Editing a link.

If you’ve inserted a linked object into a Mathcad worksheet, you can update the link, eliminate it, or change the source file to which the object is linked. To do so, choose Links from the Edit menu. You’ll see the following dialog box:


Choose the link you want to edit from the list of links. Then make any of the following changes: Automatic: Click this radio button to make the link update whenever you open the worksheet and any time the source information changes while the worksheet is open.
Manual: Click this radio button to make the link update only when you press the “Update Now” button. Update Now: Click this button to update a manual link. Open Source: Opens the application in which the linked object was created.Change Source: Links the object with a different source file. The new source file must have been created in the same application as the original source file. Break Link: Breaks the link between an object’s original source and the copy of the object in the worksheet.

Posted on November 20, 2015 in Worksheet Management

Share the Story

Back to Top
Share This