Format Cell (Custom Properties Section) [Visio 2003 SDK Documentation]
Specifies the formatting of a custom property that is a string, a fixed list, a number, a variable list, a date or time, a duration, or a currency.
Remarks
| Custom property type | Value | Format cell contents |
|---|---|---|
String |
0 |
A format picture appropriate for the data type. |
Fixed list |
1 |
The items to appear in the list, separated by semicolons. |
Number |
2 |
A format picture appropriate for the data type. |
Variable list |
4 |
The items to appear in the list, separated by semicolons. |
Date or time |
5 |
A format picture appropriate for the data type. |
Duration |
6 |
A format picture appropriate for the data type. |
Currency |
7 |
A format picture appropriate for the data type. |
As an example of specifying a format picture appropriate for the data type, the format picture "# #/4 UU" formats the number 12.43 in. as 12 2/4 INCHES. For more information about specifying a format picture, see About format pictures.
An example of specifying items for a list is "Engineering;Human Resources;Sales;Marketing".
Date values (type = 5) are displayed in the short date format. Currency values (type = 7) are displayed using the user's current setting for Currency on the Regional Options tab in the Regional and Language Options item in Control Panel.
A number (type = 2) can represent a dimension, scalar, angle, date, time, or currency. To ensure that an input number is always evaluated as a date, time, or currency, use the DATETIME or CY function in the Format cell instead of a format picture.
To reference the Format cell by name from another formula, or from a program using the CellsU property, use:
Cell name: |
Prop.name.Format |
To reference the Format cell by index from a program, use the CellsSRC property with the following arguments:
Section index: |
visSectionProp |
Row index: |
visRowProp + i |
Cell index: |
visCustPropsFormat |