Excel Custom Properties
This topic describes the custom properties of Microsoft UI Automation elements provided by Excel.
| Name/GUID | Description |
|---|---|
AreGridlinesVisible {4BB56516-F354-44CF-A5AA-96B52E968CFD} |
Specifies whether sheet gridlines are on for the element. Variant type: VT_BOOL Default value: FALSE |
CellFormula {E244641A-2785-41E9-A4A7-5BE5FE531507} |
Specifies the cell formula for the element. Variant type: VT_BSTR Default value: empty string |
CellNumberFormat {626CF4A0-A5AE-448B-A157-5EA4D1D057D7} |
Specifies the cell number format for the element. Variant type: VT_BSTR Default value: empty string |
CommentReplyCount {312F7536-259A-47C7-B192-AA16352522C4} |
Specifies the comment reply count for the annotation. Variant type: VT_I4 Default value: 0 |
DataValidationPrompt {7AAEE221-E14D-4DA4-83FE-842AAF06A9B7} |
Specifies the data validation prompt for the element. Variant type: VT_BSTR Default value: empty string |
HasConditionalFormatting {DFEF6BBD-7A50-41BD-971F-B5D741569A2B} |
Specifies whether there is conditional formatting for the element. Variant type: VT_BOOL Default value: FALSE |
HasDataValidation {29F2E049-5DE9-4444-8338-6784C5D18ADF} |
Specifies whether there is data validation for the element. Variant type: VT_BOOL Default value: FALSE |
HasDataValidationDropdown {1B93A5CD-0956-46ED-9BBF-016C1B9FD75F} |
Specifies whether there is a data validation dropdown for the element. Variant type: VT_BOOL Default value: FALSE |
TableFullRowCount {D0DC7570-FE91-4FA6-A92B-66AB49211EDF} |
Specifies the number of rows in a table, including any hidden rows. The grid row count on a table indicates the number of non-hidden rows. Variant type: VT_I4 Default value: 0 |
TableFullColumnCount {3A20668F-D66E-4FCF-878D-FBC3B54B35F3} |
Specifies the number of columns in a table, including any hidden columns. The grid column count on a table indicates the number of non-hidden columns. Variant type: VT_I4 Default value: 0 |
TableFullRowPosition {0E4B8FA7-2C81-4DF8-A390-935633EE10E5} |
Specifies the row position of a table cell relative to the set of all rows in a table, including any hidden rows. The grid item row table item is the row relative to the set of non-hidden rows. Variant type: VT_I4 Default value: 0 |
TableFullColumnPosition {81FB2803-ECA3-470A-B636-F2DCC46B9361} |
Specifies the column position of a table cell relative to the set of all columns in a table, including any hidden columns. The grid item column on a table item is the column relative to the set of non-hidden columns. Variant type: VT_I4 Default value: 0 |
InFilteredRange {D3A4F745-5A35-4077-ADA1-BE8B49B3A7F7} |
Specifies whether an element is within a filtered range. Minimum version 2302 (build 16130.xxxxx) Variant type: VT_BOOL Default value: FALSE |
HasFilterDropdown {0097284B-3573-4AAB-8E22-6092B87F8FDD} |
Specifies whether there is a filter dropdown for the element. Minimum version 2302 (build 16130.xxxxx) Variant type: VT_BOOL Default value: FALSE |
IsStaleFormula {755C0B45-6309-41F7-B368-3B57A45ED5B5} |
Indicates the cell formula is stale. Minimum version 2307 (build 16626.xxxxx) Variant type: VT_BOOL Default value: FALSE |
CellPythonFormula {C9C816CA-ACC7-4E34-9C14-AEC0B60F0FB0} |
Indicates the cell contains a python formula. Minimum version 2307 (build 16626.xxxxx) Variant type: VT_BOOL Default value: FALSE |
Requirements
Microsoft 365 Version 2102 (Build 13729.xxxxx)
See also
UI Automation Properties Overview