Characteristic Class

Single Characteristic.When the object is serialized out as xml, its qualified name is ac:characteristic.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.AdditionalCharacteristics.Characteristic

Namespace:  DocumentFormat.OpenXml.AdditionalCharacteristics
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
Public Class Characteristic _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As Characteristic
public class Characteristic : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

22.7.2.2 characteristic (Single Characteristic)

This element specifies a single characteristic. The type of characteristic is defined by the name attribute.

[Example: A producer can inform the consumer that the computations used to calculate the stored numbers in the formulas belong to a value space expressed by ranges of the binary mantissa and exponent. A consumer can optionally check those characteristics to determine whether, for example, the values should be recalculated. The XML for this would be:

<additionalCharacteristics>
<characteristic name='precisionMantissa' relation='gt'
val='-9007199254740992'/>
<characteristic name='precisionMantissa' relation='lt'
val='9007199254740992'/>
<characteristic name='precisionExponent' relation='ge' val='-1075'/>
<characteristic name='precisionExponent' relation='le' val='970'/>
</additionalCharacteristics>

end example]

Parent Elements

additionalCharacteristics (§22.7.2.1)

Attributes

Description

name (Name of Characteristic)

Specifies the name of the characteristic. There are no constraints on the value of the name attribute, but each name shall be associated with a specific vocabulary via the vocabulary attribute.

The values defined by ISO/IEC 29500 shall be associated with a null vocabulary value, and are as follows:

Name Value

Property Specified

numColumns

Number of Columns supported by the spreadsheet producer.

numRows

Number of Rows supported by the spreadsheet producer.

functionVersion

Version of the function specification used

precisionMantissa

Allowed values of the mantissa of numbers within spreadsheet cells/formulas when expressed in base 2.

precisionExponent

Allowed values of the exponent of numbers within spreadsheet cells/formulas when expressed in base 2.

numWorkbookColors

Number of Workbook colors

numConditionalFormatConditions

Number of condition format conditions on a workbook cell

nummaxSortLevels

Number of level of sorting on a range or table

numAutoFilterItems

Number of items shown in the Auto-filter dropdown

numDisplayCellChars

Number of characters that can display in a cell

numPrintCellChars

Number of characters per cell that Excel can print

numUnqiueCellStyles

Number of unique cell styles in a workbook (combinations of all cell formatting)

numFormulaLengthChars

Length of formulas in characters

numFormulaNestingLevel

Number of levels of formula nesting

numFunctionArguments

Number of arguments to a function

numPivotTableRows

Number of rows in a pivot table

numPivotTableColumns

Number of columns in a pivot table

numUniquePivotFieldItems

Number of unique items in a pivot field

numPivotTableMDXNameChars

Number of characters in a MDX name for a pivot table item

numPivotTableRelationChars

String length for a relationship pivot table

numPivotTableFieldLabelChars

Length of field labels in PivotTable including caption length limitations

numPivotTableFields

Number of fields in a pivot table

numSheetXRefArrayFormulas

The number of array formulas in a worksheet that can refer to another (given) worksheet

The possible values for this attribute are defined by the W3C XML Schema string datatype.

relation (Relationship of Value to Name)

Specifies how the contents of the value attribute should be interpreted in the context of this characteristic.

[Example: The following would specify that the application supports from 0 to 10,000 columns, and that column ranges should be interpreted accordingly:

<additionalCharacteristics>
<characteristic name="numColumns" relation="le" val="10000"/>
<characteristic name="numColumns" relation="ge" val="0"/>
</additionalCharacteristics>

end example]

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

val (Characteristic Value)

Specifies the value of the characteristic.

The possible values for this attribute are defined by the W3C XML Schema string datatype.

vocabulary (Characteristic Grammar)

Specifies a URI defining the characteristic grammar with which the name attribute value shall be interpreted.

If this attribute is omitted, then the default grammar (as defined above) shall be used.

The possible values for this attribute are defined by the W3C XML Schema anyURI datatype.

[Note: The W3C XML Schema definition of this element’s content model (CT_Characteristic) is located in §A.6.7. end note]

© ISO/IEC29500: 2008.

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Characteristic Members

DocumentFormat.OpenXml.AdditionalCharacteristics Namespace