Placing a worksheet on the drawing

To place an image of a worksheet on the drawing:

If the worksheet is part of another file, first import it into the current file. See Importing worksheets from another Vectorworks file.

From the worksheet window, select Place on Drawing from the General tab. A preview of the worksheet image displays with the cursor; click to place the image where desired. Alternatively, do one of the following from the Resource Manager:

Right-click on the resource, and select Worksheet On Drawing.

Double-click on the resource.

Drag the resource to the desired location in the drawing file.

The worksheet is now included in the drawing as a graphic object. If the worksheet is currently open, the contents of the worksheet in the drawing are replaced with an X.

Use the options on the Format tab of the tool bar to format individual rows, columns, and cells of the worksheet. The format is retained when the worksheet is included on the drawing. Alternatively, with the worksheet window closed, select the worksheet object on the drawing, and use the Attributes palette to modify the fill, pen, and line thickness attributes for the entire object.

Editing a worksheet image

To edit a worksheet image, do one of the following:

To edit the underlying worksheet, from the Resource Manager, right-click on the resource, and select Open. Alternatively, double-click the worksheet image in the drawing.

The worksheet opens for editing. The contents of the worksheet image are replaced with an X. Close the worksheet to display the worksheet contents in the drawing.

To display the database header rows in the worksheet image, click Show database headers from the Object Info palette. This does not affect the visibility of the database headers in the worksheet window.

To recalculate the worksheet image, click Recalculate from the Object Info palette, or right-click on the image and select Recalculate All Worksheets or Recalculate Selected Worksheet.

Scaling worksheet images

There are multiple ways to scale a worksheet image within the drawing area; all scaling operations scale the image symmetrically and preserve the aspect ratio.

From the Object Info palette for a selected worksheet image, enter a Scale Factor; for example, enter 2 to double or 0.5 to halve the scale.

Alternatively, select Modify > Scale Objects and perform one of the symmetric operations (see Scaling objects).

A selected worksheet image can also be scaled less precisely by dragging a reshape handle with the Selection tool.

When a selected worksheet image has been scaled, that is reflected in the object's name at the top of the Object Info palette: "Worksheet Image - Scaled." Scaled images will revert to their unscaled size if the file is saved to a Vectorworks version prior to 2017.

In addition to scaling worksheets images in the drawing area, you can scale them to fit to printed pages. See Worksheet: Printing tab.

Splitting worksheet images

If you have a large worksheet image that spans multiple pages, you can crop columns and rows, or split it into smaller images to fit as desired within the printing area. See Cropping or splitting worksheet images.