2.6.203 CT_Person

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2018/threadedcomments

Referenced by: CT_PersonList

This complex type specifies the information about an author of a comment or a person mentioned in a comment.

Child Elements:

extLst: A CT_ExtensionList ([ISO/IEC29500-4:2016] section A.2) element that specifies future extensibility for this element.

Attributes:

displayName: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the display name of the person.

id: An ST_Guid ([ISO/IEC29500-1:2016] section 22.9.2.4) attribute that specifies a unique identifier for the person.

userId: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies a provider issued user identifier for the person.

providerId: An ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the provider type of the person’s information.

This table lists example values of the providerId attribute and the corresponding meanings of the userId attribute.

Identity Provider

providerId

value

userId

value

Description of userId value

No Provider

"None"

"Name"

Author’s name

Active Directory

"AD"

SID

Active Directory Security Identifier (as specified in [MS-DTYP] section 2.4.2)

Windows Live ID

"Windows Live"

CID

A 64-bit signed decimal that uniquely identifies a user on Windows Live.

Office 365

"AD"

O365ID

A string that uniquely identifies a user. It SHOULD be comprised of three individual values separated by a "::" character delimiter.

People Picker

"PeoplePicker"

"Email address"

An email address provided by People Picker

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_Person">
   <xsd:sequence>
     <xsd:element name="extLst" type="x:CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
   </xsd:sequence>
   <xsd:attribute name="displayName" type="x:ST_Xstring" use="required"/>
   <xsd:attribute name="id" type="x:ST_Guid" use="required"/>
   <xsd:attribute name="userId" type="x:ST_Xstring" use="optional"/>
   <xsd:attribute name="providerId" type="x:ST_Xstring" use="optional"/>
 </xsd:complexType>

See section 5.23 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).