[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

si (String Item)

This element is the representation of an individual string in the Shared String table.

If the string is just a simple string with formatting applied at the cell level, then the String Item (si) should contain a single text element used to express the string. However, if the string in the cell is more complex - i.e., has formatting applied at the character level - then the string item shall consist of multiple rich text runs which collectively are used to express the string.

Parent Elements

sst3.4.9)

 

Child Elements

Subclause

phoneticPr (Phonetic Properties)

§3.4.3

r (Rich Text Run)

§3.4.4

rPh (Phonetic Run)

§3.4.6

t (Text)

§3.4.12

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Rst">

   <sequence>

   <element name="t" type="ST_Xstring" minOccurs="0" maxOccurs="1"/>

   <element name="r" type="CT_RElt" minOccurs="0" maxOccurs="unbounded"/>

   <element name="rPh" type="CT_PhoneticRun" minOccurs="0" maxOccurs="unbounded"/>

   <element name="phoneticPr" minOccurs="0" maxOccurs="1" type="CT_PhoneticPr"/>

   </sequence>

</complexType>