Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
DisplayValueForCenterAcrossSelection {27425C3C-E7D6-4155-BE0F-75A78AEE06BE} |
Specifies the value and bounds of the selected range. Minimum version 2309 (build 16827.XXXXX) Variant type: VT_BSTR Default value: empty string |
ConditionalFormattingIcon {EC06F0BE-30D6-48F8-B6F7-791C610C6C04} |
Specifies the conditional formatting icon associated with the element. Minimum version 2404 (build 17531.XXXXX) Variant type: VT_BSTR Default value: empty string |
HasPhoneticText {C599FE13-FC14-4841-94B8-355E1DED76FB} |
Specifies whether the element contains phonetic text. Minimum version 2404 (build 17531.XXXXX) Variant type: VT_BOOL Default value: FALSE |
AdjacentToHiddenCells {21EFC037-12A0-4CE8-923B-2FBBE49AD6C6} |
Specifies whether the element is adjacent to a hidden cell. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_BOOL Default value: FALSE |
DataBarPercent {873F7BA3-D54C-4762-902A-087EFC0021F0} |
Specifies the percentage value of the databar in the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_I4 Default value: 0 |
DynamicArraySpilledColumns {AABF03B2-7380-4B35-90E3-908261D839F3} |
Specifies the count of spilled columns for the dynamic array in the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_I4 Default value: 0 |
DynamicArraySpilledRows {08365E28-0D3E-4A36-8522-B661C841BE83} |
Specifies the count of spilled rows for the dynamic array in the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_I4 Default value: 0 |
LinkedEntityDomain {E19BC2BA-FABD-4B2F-8AD8-7213B6D28103} |
Specifies the linked entity domain for the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_BSTR Default value: empty string |
RichValueType {FA140C41-4CE3-48BD-B82D-D973C2EAA095} |
Specifies the value of the RichValueType for the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_BSTR Default value: empty string |
SpilledFromAnchor {D02E2EF6-2D91-420A-BBFC-6C34295883ED} |
Specifies the anchor address of the spilled cell for the element. Minimum version 2405 (build 17628.XXXXX) Variant type: VT_BSTR Default value: empty string |
Requirements
Microsoft 365 Version 2102 (Build 13729.xxxxx)
See also
UI Automation Properties Overview