<phoneticPr> (Phonetic Properties)

This element represents a collection of phonetic properties that affect the display of phonetic text for this String Item (si).

Phonetic text is used to give hints as to the pronunciation of an East Asian language, and the hints are displayed as text within the spreadsheet cells across the top portion of the cell. Since the phonetic hints are text, every phonetic hint is expressed as a <phonetic run (rPh>)<, >and these properties specify how to display that phonetic run.

example:
<si>
  <t>課きく 毛こ</t>
  <rPh sb="0" eb="1">
    <t></t>
  </rPh>
  <rPh sb="4" eb="5">
    <t></t>
  </rPh>
  <phoneticPr fontId="1"/>
</si>

The above example shows a String Item that displays some Japanese text "課きく 毛こ." It also displays some phonetic text across the top of the cell. The phonetic text character, "カ" is displayed over the "課" character and the phonetic text "ケ" is displayed above the "毛" character, using the font record in the style sheet at index 1.

Parent Elements

<is>3.3.1.50); <si>3.4.8); <text>3.7.6); <worksheet>3.3.1.96)

Attributes

Description

<alignment> (Alignment)

Specifies how the text for the phonetic run is aligned across the top of the cells, with respect to the main text in the body of the cell.

The possible values for this attribute are defined by the ST_PhoneticAlignment simple type (§3.18.58).

<fontId> (Font Id)

An integer that is a zero-based index into the font record in the style sheet. Represents the font to be used to display this phonetic run.

If this index is out of bounds, then the default font of the Normal style should be used in its place. This default font should be at index 0.

The possible values for this attribute are defined by the ST_FontId simple type (§3.18.33).

<type> (Character Type)

An enumeration which specifies which type of East Asian character set should be used to display the phonetic run

The possible values for this attribute are defined by the ST_PhoneticType simple type (§3.18.59).

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

<complexType name="CT_PhoneticPr">
	<attribute name="fontId" type="ST_FontId" use="required"/>
	<attribute name="type" type="ST_PhoneticType" use="optional" default="fullwidthKatakana"/>
	<attribute name="alignment" type="ST_PhoneticAlignment" use="optional" default="left"/>
</complexType>