DesignSeries.pngInserting images in worksheet cells

If Vectorworks Design Series is installed, add images to both spreadsheet and database cells to provide graphic views of the objects in a drawing. The images can be either thumbnail versions of objects, or samples of the 2D attributes of objects. For example, you might create a window schedule that shows top and front thumbnail views of each type of window in your drawing, in addition to data about each window.

To insert an image in a cell, use the image function, which works the same as other standard worksheet functions; see Entering formulas in worksheet cells.

For plant images, you can also use the PlantImage functions.

Like other functions, you can enter an image function manually on the Formula bar, or use commands and dialog boxes to build a formula that uses the image function.

A cell that uses the image function in a formula can include either a text expression or an image, but not both.

To manually enter an image formula:

1.      Select the cell.

2.Enter the image function (=IMAGE). The entry automatically displays in the worksheet Formula bar. If the cell is in a database header row, no further entry is required.

3.If the cell is in a spreadsheet row, enter the rest of the formula to specify which object to display. For example, to display an image of the symbol called K-02221, enter this:

=IMAGE(S='K-02221')

4.When the formula is complete, click the green check mark to validate the entry. To cancel an entry, click the red X.

5.The formula executes, and the image displays (Auto-recalc must be selected in the worksheet preferences).

6.Customize the image display from the Image tab of the Format Cells dialog box as described in Formatting worksheet cells.

Inserting an image function

Command

Path

Image Function

Insert (worksheet menu)

To enter a formula with the Image Function and Criteria commands:

1.      Select the cell.

2.Select the command. Alternatively, right-click the cell and select Insert Image Function.

The image function is placed in the worksheet Formula bar and the cursor is placed between the parentheses, awaiting an argument. If the cell is in a database header row, no further entry is required.

3.If the cell is in a spreadsheet row, enter criteria to specify which drawing object to display. Select Insert > Criteria from the Worksheet menu.

4.If an object is selected when the Criteria command is selected, the Paste Attributes dialog box opens. Otherwise, proceed to step 5.

Do one of the following:

       To use attributes of the selected object as the only selection criteria, select the attributes.

       To specify other criteria, or to use attributes of other objects in the drawing, click Custom.

5.The Criteria dialog box opens. Specify the criteria for the function.

6.When the formula is complete, click the green check mark to validate the entry. To cancel the entry, click the red X.

7.The formula executes, and the image displays (Auto-recalc must be selected in the worksheet preferences).

8.Customize the image from the Image tab of the Format Cells dialog box as described in Formatting worksheet cells.

Worksheets00010.png 

~~~~~~~~~~~~~~~~~~~~~~~~~

Entering constant values in worksheet cells

Entering formulas in worksheet cells

 

Was this page helpful?