Share via

2.7.25 ST_CalcMemNumberFormat

  • Article

Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2010/11/main

Referenced by: CT_CalculatedMember

An enumeration that specifies the display format for a CT_CalculatedMember.

Value

Meaning

default

Specifies that the number will be displayed using its current format.

number

Specifies that the number will be displayed using a comma as a thousands separator.

percent

Specifies that the number will be displayed as a percentage with two decimal places.

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

 <xsd:simpleType name="ST_CalcMemNumberFormat">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="default"/>
     <xsd:enumeration value="number"/>
     <xsd:enumeration value="percent"/>
   </xsd:restriction>
 </xsd:simpleType>

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