From Vectorworks Developer
Jump to navigation Jump to search

.Worksheets|Worksheets ..Search Criteria Format|Search Criteria Format ..Worksheet Functions|Worksheet Functions ..Worksheets#Version_Information|Version Information

Worksheet Functions

The entire list of worksheet functions can be found here: Worksheet Functions.

There are two basic types of functions: those that use the values you enter, and those that use information from objects in the drawing. The arguments required by the two function types are different.

  • Number or text arguments: Functions that begin with a lower case letter typically require a number value or a cell address as the argument. For example, the acos function returns the arccosine of the value that is specified in the function argument. The argument you enter can be a mathematical expression (such as 3/5), an address of a cell that contains a number (such as A12), or an actual number. The argument for all trigonometry functions must be in radians.
  • Criteria arguments: Functions that begin with a capital letter must be applied to one or more specific objects in the drawing. In a cell in a database header row, a function is automatically applied to the object listed in each sub-row, so no criteria argument is required. However, in a spreadsheet cell, you must enter criteria to select the objects the function applies to. For example, the Area function returns the combined area of all 2D objects that meet the criteria. To specify which objects to obtain the area of, either use the Insert > Criteria command on the Worksheet menu, or enter the criteria manually.

Worksheet Criteria

For details about how to specify criteria such as the object type, class, or visibility, refer to the following page: Search Criteria Format.

Version Information