CellExists Property [Visio 2003 SDK Documentation]

  • Article

Determines whether a particular ShapeSheet cell exists in the scope of the search.

intRet = object**.CellExists**(localeSpecificCellName, fExistsLocally)

intRet    Integer. False (0) if cell doesn't exist; True (-1) if it does.

object    Required. An expression that returns a Shape or Style object.

localeSpecificCellName    Required String. The local or universal name of the ShapeSheet cell for which you want to search.

fExistsLocally    Required Integer. The scope of the search.

Version added

4.0

Remarks

The localeSpecificCellName argument can specify a cell name in either local or universal syntax. To search for a cell by section, row, and column index, use the CellsSRCExists property.

The fExistsLocally argument specifies the scope of the search.

  • If fExistsLocally is non-zero (True), the CellExists property value is True only if the object contains the cell locally; if the cell is inherited, the CellExists property value is False.
  • If fExistsLocally is zero (False), the CellExists property value is True if the object either contains or inherits the cell.

For a list of cell index values, view the Visio type library for the members of class VisCellIndices.

Note  Beginning with Microsoft Visio 2000, you can use both local and universal names to refer to Visio shapes, masters, documents, pages, rows, add-ons, cells, hyperlinks, styles, fonts, master shortcuts, UI objects, and layers. When a user names a shape, for example, the user is specifying a local name. Beginning with Microsoft Office Visio 2003, the ShapeSheet spreadsheet displays only universal names in cell formulas and values. (In prior versions, universal names were not visible in the user interface.)

As a developer, you can use universal names in a program when you don't want to change a name each time a solution is localized. Use the CellExists property to determine if a cell exists by passing either the cell's local name or its universal name. Use the CellExistsU property to determine if a cell exists by passing the cell's universal name.

Applies to | Shape object | Style object