Cell Object Members

  • Article
Visio Automation Reference

Holds a formula that evaluates to some value.

Methods

  Name Description
Aa342188.methods(en-us,office.12).gif GlueTo Glues one shape to another, from a cell in the first shape to a cell in the second shape.
Aa342188.methods(en-us,office.12).gif GlueToPos Glues one shape to another from a cell in the first shape to an x,y position in the second shape.
Aa342188.methods(en-us,office.12).gif Trigger Evaluates the formula of a cell.

Properties

  Name Description
Aa342188.properties(en-us,office.12).gif Application Read-only. Returns the instance of Microsoft Office Visio that is associated with an object.
Aa342188.properties(en-us,office.12).gif Column Returns the column index of a cell. Read-only.
Aa342188.properties(en-us,office.12).gif ContainingMasterID Returns the ID of the Master object that contains an object. Read-only.
Aa342188.properties(en-us,office.12).gif ContainingPageID Returns the ID of the page that contains an object. Read-only
Aa342188.properties(en-us,office.12).gif ContainingRow Returns the row that contains a cell. Read-only.
Aa342188.properties(en-us,office.12).gif Dependents Returns an array of ShapeSheet cells that are dependent on a particular cell of a Microsoft Office Visio shape. Read-only.
Aa342188.properties(en-us,office.12).gif Document Gets the Document object that is associated with an object. Read-only.
Aa342188.properties(en-us,office.12).gif Error Gets the error code generated by the last evaluation of a cell's formula. Read-only.
Aa342188.properties(en-us,office.12).gif EventList Returns the EventList collection of an object or the EventList collection that contains an Event object. Read-only.
Aa342188.properties(en-us,office.12).gif Formula Gets or sets the formula for a Cell object. Read/write.
Aa342188.properties(en-us,office.12).gif FormulaForce Sets the formula in a Cell object, even if the formula is protected with a GUARD function. Read/write.
Aa342188.properties(en-us,office.12).gif FormulaForceU Sets the universal syntax formula in a Cell object, even if the formula is protected with a GUARD function. Read/write.
Aa342188.properties(en-us,office.12).gif FormulaU Gets or sets the universal syntax formula for a Cell object. Read/write.
Aa342188.properties(en-us,office.12).gif InheritedFormulaSource Returns the cell from which this cell inherited its formula. Read-only.
Aa342188.properties(en-us,office.12).gif InheritedValueSource Returns the cell from which this cell inherited its value. Read-only.
Aa342188.properties(en-us,office.12).gif IsConstant Determines whether a formula of the cell is a constant expression. Read-only.
Aa342188.properties(en-us,office.12).gif IsInherited Determines whether a formula of the cell is inherited from a master or a style. Read-only.
Aa342188.properties(en-us,office.12).gif LocalName Returns the local name of a cell. Read-only.
Aa342188.properties(en-us,office.12).gif Name Specifies the name of an object. Read-only.
Aa342188.properties(en-us,office.12).gif ObjectType Returns an object's type. Read-only.
Aa342188.properties(en-us,office.12).gif PersistsEvents Indicates whether an object is capable of containing persistent events in its EventList collection. Read-only.
Aa342188.properties(en-us,office.12).gif Precedents Returns an array of ShapeSheet cells upon which the formula of another cell depends. Read-only.
Aa342188.properties(en-us,office.12).gif Result Gets or sets a cell's value. Read/write.
Aa342188.properties(en-us,office.12).gif ResultForce Sets a cell's value, even if the cell's formula is protected with the GUARD function. Read/write.
Aa342188.properties(en-us,office.12).gif ResultFromInt Sets the value of a cell to an integer value. Read/write.
Aa342188.properties(en-us,office.12).gif ResultFromIntForce Sets the value of a cell to an integer value, even if the cell's formula is protected with the GUARD function. Read/write.
Aa342188.properties(en-us,office.12).gif ResultInt Gets the value of a cell expressed as an integer. Read-only.
Aa342188.properties(en-us,office.12).gif ResultIU Gets or sets a cell's value in internal units. Read/write.
Aa342188.properties(en-us,office.12).gif ResultIUForce Sets a cell's value in internal units, even if the cell's formula is protected with the GUARD function. Read/write.
Aa342188.properties(en-us,office.12).gif ResultStr Gets the value of a ShapeSheet cell expressed as a string. Read-only.
Aa342188.properties(en-us,office.12).gif ResultStrU Gets the value of a ShapeSheet cell expressed as a universal string. Read-only.
Aa342188.properties(en-us,office.12).gif Row Returns the row index of a cell. Read-only.
Aa342188.properties(en-us,office.12).gif RowName Gets or sets the name of the row that contains the Cell object. Read/write.
Aa342188.properties(en-us,office.12).gif RowNameU Gets or sets the universal name of the row that contains the Cell object. Read/write.
Aa342188.properties(en-us,office.12).gif Section Returns the index of the cell's section. Read-only.
Aa342188.properties(en-us,office.12).gif Shape Returns the Shape object that owns a Cell, Characters, Row, or Section object or that is associated with a Hyperlink or OLEObject object or with the Hyperlinks collection. Read-only.
Aa342188.properties(en-us,office.12).gif Stat Returns status information for an object. Read-only.
Aa342188.properties(en-us,office.12).gif Style Gets the style that contains a Cell object. Read-only.
Aa342188.properties(en-us,office.12).gif Units Indicates the unit of measure associated with a Cell object. Read-only.

Events

  Name Description
Aa342188.events(en-us,office.12).gif CellChanged Occurs after the value changes in a cell in a document.
Aa342188.events(en-us,office.12).gif FormulaChanged Occurs after a formula changes in a cell in the object that receives the event.