Excel Annotations
This topic describes the custom properties of Microsoft UI Automation annotation providers in Excel.
| Annotation Type Identifier | Pattern Properties | Provider Properties |
|---|---|---|
AnnotationType_FormulaError |
Type name: Formula Error | Name: Short description from error card. Full Description: Long description from error card. |
AnnotationType_DataValidationError |
Type name: Data Validation Error Only if data validation "Circle Invalid Data" option is enabled. |
Name: Error title (if defined). Full Description: Error prompt(if defined). |
AnnotationType_Comment |
Class Name: XLComment Type name: Comment Author: Initiating author. Date: date+time thread initiated. |
Name: Comment on cellname. Full Description: Initial thread content. Custom Property: CommentReplyCount |
AnnotationType_Comment or Custom (see below) |
Class Name: XLNote Type name: Note. Author: Note author. |
Name: Note on cellname. Full Description: Note content. |
AnnotationType_Author |
Type name: Editing or Selected Author: Author name. |
Name: Author. Full Description: Editing or Selected cellname |
AnnotationType_CircularReferenceError |
Type name: Circular Reference Error | Name: Circular reference error. Full Description: Circular reference to next cell in circle. |
Custom Annotations
On windows platforms that support custom annotations, Excel supports these custom annotation types.
| Name/GUID | Description |
|---|---|
XlNote {4E863D9A-F502-4A67-808F-9E711702D05E} |
Note annotation. |
Requirements
Microsoft 365 Version 2103 (Build 13901.xxxxx)