Main page /  Useful info about ShapeSheet™  / Visio ShapeSheet reference / ShapeSheet™. List of functions by category

ShapeSheet. Category Cell manipulations control flow

Note

This table contain only functions which included in table for similar category in the book MS Visio 2003 Developer’s Survival Pack by Graham Wideman (see chapter 37).

The version information in which the function was added is taken from John's Goldsmith article Visio ShapeSheet Functions by Version

Name

Details

DEPENDSON

Version Added: Pre 2003

Creates a cell reference dependency.

Syntax

DEPENDSON(cellref[,cellref2,...])

Read more about function DEPENDSON

FORMULAEXISTS

Version Added: 2003

Indicates whether the referenced cell contains a formula.

Syntax

FORMULAEXISTS (cellref)

Read more about function FORMULAEXISTS

GETREF

Version Added: Pre 2003

References a cell and doesn't recalculate the formula when the referenced cell changes.

Syntax

GETREF(cellname)

Read more about function GETREF

GETVAL

Version Added: Pre 2003

Gets the value of a cell and doesn't recalculate the formula when the cell's value changes.

Syntax

GETVAL(cellname)

Read more about function GETVAL

GUARD

Version Added: Pre 2003

Protects expression from deletion and change by actions performed in the drawing window, for example, moving, sizing, grouping, or ungrouping shapes.

Syntax

GUARD(expression)

Read more about function GUARD

LOCALFORMULAEXISTS

Version Added: 2003

Indicates whether the referenced cell contains a local formula.

Syntax

LOCALFORMULAEXISTS (cellref)

Read more about function LOCALFORMULAEXISTS

SETATREF

Version Added: 2003

Redirects updated values resulting from actions in the user interface (UI) or Automation to another cell.

Syntax

SETATREF(reference [,set_expression [,ignore_eval]])

Read more about function SETATREF

SETATREFEVAL

Version Added: 2003

Used in the set_expression parameter of the SETATREF function to indicate that set_expression should be evaluated before assigning to the reference parameter in SETATREF.

Syntax

SETATREFEVAL(expr)

Read more about function SETATREFEVAL

SETATREFEXPR

Version Added: 2003

Stores a value that is set through an action in the user interface (UI) or Automation.

Syntax

SETATREFEXPR ([expr_opt])

Read more about function SETATREFEXPR

SETF

Version Added: Pre 2003

Sets a cell's formula.

Syntax

SETF( GETREF(cell), formula)

Read more about function SETF

USE

Version Added: Pre 2003

Applies the line pattern, fill pattern, or line end called name to the shape when placed in the LinePattern, FillPattern, BeginArrow, or EndArrow cell.

Syntax

USE("name")

Read more about function USE