Formula[U] property
Returns or sets the formula for a Cell object.
Version added
2.0
Syntax
| |
| |
|
strRet |
String. The cell's formula. |
|
object |
Required. An expression that returns a Cell object. |
|
stringExpression |
Required String. The new formula for the cell. |
Remarks
If a cell's formula is protected with the GUARD function, you must use the FormulaForce property to change the cell's formula.
Note Beginning with Visio 2000, you can refer to Visio shapes, masters, styles, pages, rows, and layers using local and universal names. When a user names a shape, for example, the user is specifying a local name. Universal names are not visible through 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 Formula property to get a cell's formula string in local syntax or to set it using a mix of local and universal syntax. Use the FormulaU property to get or parse the formula using universal syntax. When using FormulaU, the decimal point is always "." and the delimiter is always "," and universal unit strings must be used (for details on universal strings, see About units of measure).