2.5.113 Feat11FieldDataItem

  • Article

The Feat11FieldDataItem structure specifies a column of a table.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

idField

lfdt

lfxidt

ilta

cbFmtAgg

istnAgg

A

B

C

D

E

F

G

H

I

J

K

unused2

cbFmtInsertRow

istnInsertRow

strFieldName (variable)

...

strCaption (variable)

...

dxfFmtAgg (variable)

...

dxfFmtInsertRow (variable)

...

AutoFilter (variable)

...

rgXmap (variable)

...

fmla (variable)

...

totalFmla (variable)

...

strTotal (variable)

...

wssInfo (variable)

...

qsif (optional)

dskHdrCache (variable)

...

idField (4 bytes): An unsigned integer that specifies the identifier of the column. MUST be nonzero and MUST be unique within the FieldData array in the containing TableFeatureType structure.

lfdt (4 bytes): An unsigned integer that specifies the column’s Web based data provider data type. If the lt field of the containing TableFeatureType structure is not set to 0x00000001, this field MUST be 0x00000000; otherwise it MUST be a value from the following table. For more information about the data types, see [MS-WSSTS] section 2.3.

Value

Web Based Data Provider Data Type

0x00000001

Text

0x00000002

Number

0x00000003

Boolean

0x00000004

Date Time

0x00000005

Note

0x00000006

Currency

0x00000007

Lookup

0x00000008

Choice

0x00000009

URL

0x0000000A

Counter

0x0000000B

Multiple Choices

lfxidt (4 bytes): An unsigned integer that specifies the column’s XML data type. If the lt field of the containing TableFeatureType structure is not set to 0x00000002, this field MUST be 0x00000000; otherwise it MUST be a value from the following table. For more information about the data types, see [MSDN-SOM].

Value

MS-XML Data Type

0x00001000

SOMITEM_SCHEMA

0x00001001

SOMITEM_ATTRIBUTE

0x00001002

SOMITEM_ATTRIBUTEGROUP

0x00001003

SOMITEM_NOTATION

0x00001100

SOMITEM_IDENTITYCONSTRAINT

0x00001101

SOMITEM_KEY

0x00001102

SOMITEM_KEYREF

0x00001103

SOMITEM_UNIQUE

0x00002000

SOMITEM_ANYTYPE

0x00002100

SOMITEM_DATATYPE

0x00002101

SOMITEM_DATATYPE_ANYTYPE

0x00002102

SOMITEM_DATATYPE_ANYURI

0x00002103

SOMITEM_DATATYPE_BASE64BINARY

0x00002104

SOMITEM_DATATYPE_BOOLEAN

0x00002105

SOMITEM_DATATYPE_BYTE

0x00002106

SOMITEM_DATATYPE_DATE

0x00002107

SOMITEM_DATATYPE_DATETIME

0x00002108

SOMITEM_DATATYPE_DAY

0x00002109

SOMITEM_DATATYPE_DECIMAL

0x0000210A

SOMITEM_DATATYPE_DOUBLE

0x0000210B

SOMITEM_DATATYPE_DURATION

0x0000210C

SOMITEM_DATATYPE_ENTITIES

0x0000210D

SOMITEM_DATATYPE_ENTITY

0x0000210E

SOMITEM_DATATYPE_FLOAT

0x0000210F

SOMITEM_DATATYPE_HEXBINARY

0x00002110

SOMITEM_DATATYPE_ID

0x00002111

SOMITEM_DATATYPE_IDREF

0x00002112

SOMITEM_DATATYPE_IDREFS

0x00002113

SOMITEM_DATATYPE_INT

0x00002114

SOMITEM_DATATYPE_INTEGER

0x00002115

SOMITEM_DATATYPE_LANGUAGE

0x00002116

SOMITEM_DATATYPE_LONG

0x00002117

SOMITEM_DATATYPE_MONTH

0x00002118

SOMITEM_DATATYPE_MONTHDAY

0x00002119

SOMITEM_DATATYPE_NAME

0x0000211A

SOMITEM_DATATYPE_NCNAME

0x0000211B

SOMITEM_DATATYPE_NEGATIVEINTEGER

0x0000211C

SOMITEM_DATATYPE_NMTOKEN

0x0000211D

SOMITEM_DATATYPE_NMTOKENS

0x0000211E

SOMITEM_DATATYPE_NONNEGATIVEINTEGER

0x0000211F

SOMITEM_DATATYPE_NONPOSITIVEINTEGER

0x00002120

SOMITEM_DATATYPE_NORMALIZEDSTRING

0x00002121

SOMITEM_DATATYPE_NOTATION

0x00002122

SOMITEM_DATATYPE_POSITIVEINTEGER

0x00002123

SOMITEM_DATATYPE_QNAME

0x00002124

SOMITEM_DATATYPE_SHORT

0x00002125

SOMITEM_DATATYPE_STRING

0x00002126

SOMITEM_DATATYPE_TIME

0x00002127

SOMITEM_DATATYPE_TOKEN

0x00002128

SOMITEM_DATATYPE_UNSIGNEDBYTE

0x00002129

SOMITEM_DATATYPE_UNSIGNEDINT

0x0000212A

SOMITEM_DATATYPE_UNSIGNEDLONG

0x0000212B

SOMITEM_DATATYPE_UNSIGNEDSHORT

0x0000212C

SOMITEM_DATATYPE_YEAR

0x0000212D

SOMITEM_DATATYPE_YEARMONTH

0x000021FF

SOMITEM_DATATYPE_ANYSIMPLETYPE

0x00002200

SOMITEM_SIMPLETYPE

0x00002400

SOMITEM_COMPLEXTYPE

0x00004000

SOMITEM_PARTICLE

0x00004001

SOMITEM_ANY

0x00004002

SOMITEM_ANYATTRIBUTE

0x00004003

SOMITEM_ELEMENT

0x00004100

SOMITEM_GROUP

0x00004101

SOMITEM_ALL

0x00004102

SOMITEM_CHOICE

0x00004103

SOMITEM_SEQUENCE

0x00004104

SOMITEM_EMPTYPARTICLE

0x00000800

SOMITEM_NULL

0x00002800

SOMITEM_NULL_TYPE

0x00004801

SOMITEM_NULL_ANY

0x00004802

SOMITEM_NULL_ANYATTRIBUTE

0x00004803

SOMITEM_NULL_ELEMENT

ilta (4 bytes): An unsigned integer that specifies the aggregation function to use for the total row of the column. MUST be a value from the following table:

Value

Aggregation Formula

0x00000000

No formula (section 2.2.2)

0x00000001

Average

0x00000002

Count

0x00000003

Count Numbers

0x00000004

Max

0x00000005

Min

0x00000006

Sum

0x00000007

Standard Deviation

0x00000008

Variance

0x00000009

Custom formula<164>

cbFmtAgg (4 bytes): An unsigned integer that specifies the size, in bytes, of the dxfFmtAgg field.

istnAgg (4 bytes): An unsigned integer that specifies the zero-based index of the Style record in the Globals Substream ABNF that is used for the total row of the column. If this value equals 0xFFFFFFFF, the total row of the column uses built-in table styles.

A - fAutoFilter (1 bit):  A bit that specifies whether the column has an AutoFilter.

B - fAutoFilterHidden (1 bit): A bit that specifies whether the column has an AutoFilters that is not displayed. When this field is set to 1, fAutoFilter MUST be set to 1.

C - fLoadXmapi (1 bit): A bit that specifies whether the rgXmap field is present. MUST be 0 if the lt field of the containing TableFeatureType structure is not equal to 0x00000002.

D - fLoadFmla (1 bit): A bit that specifies whether the fmla field is present for a table whose data source is a Web based data provider list. MUST be 0 if the lt field of the containing TableFeatureType structure is not equal to 0x00000001.

E - unused1 (2 bits): Undefined, and MUST be ignored.

F - reserved2 (1 bit):  MUST be zero, and MUST be ignored.

G - fLoadTotalFmla (1 bit): A bit that specifies whether the totalFmla field is present. SHOULD<165> be 1 if ilta is 0x00000009, MUST be 0 otherwise.

H - fLoadTotalArray (1 bit): A bit that specifies whether the formula specified by totalFmla is an array formula. MUST be 0 when fLoadTotalFmla is 0.

I - fSaveStyleName (1 bit): A bit that specifies whether the dskHdrCache.strStyleName field is present.

J - fLoadTotalStr (1 bit): A bit that specifies whether the strTotal field is present. MUST be 0 when ilta is not 0x00000000.

K - fAutoCreateCalcCol (1 bit): A bit that specifies whether the column has a calculated column formula. MUST be 0 if the lt field of the containing TableFeatureType structure is set to 0x00000001.

unused2 (20 bits): Undefined, and MUST be ignored.

cbFmtInsertRow (4 bytes): An unsigned integer that specifies the size, in bytes, of the dxfFmtInsertRow field.

istnInsertRow (4 bytes):  An unsigned integer that specifies the zero-based index of the Style record in the Globals Substream ABNF that is used for the insert row of the column. If this value equals 0xFFFFFFFF, the insert row of the column uses built-in table styles.

strFieldName (variable): An XLUnicodeString that specifies the name of the column, as provided by the data source. MUST contain at least one character and less than or equal to 255 characters. MUST be unique within the FieldData array in the containing TableFeatureType structure if the lt field of the containing TableFeatureType structure is set to 0x00000001 or 0x00000003.

strCaption (variable): An XLUnicodeString that specifies the caption of the column. MUST contain at least one character and less than or equal to 255 characters. MUST be unique within the FieldData array in the containing TableFeatureType structure. MUST be equal to the value within the header cell at the location of the column title if the crwHeader field of the containing TableFeatureType structure is greater than 0. This field is present if and only if the fSingleCell field of the containing TableFeatureType structure is set to 0. MUST NOT contain the characters from the following table:

Invalid Characters

Unicode range

Lower control characters

0x0000-0x0031

Invalid Unicode surrogate pairs

High surrogate with a value of 0xD800 to 0xDBFF followed by a low surrogate with a value of 0xDC00 to 0xDFFF.

Reserved characters

0xFFFE, 0xFFFF, 0xF00B

dxfFmtAgg (variable): A DXFN12List that specifies the formatting of the total row of the column, if different from the style specified by istnAgg or built-in table styles. This field is present if and only if the cbFmtAgg field is greater than 0x00000000.

dxfFmtInsertRow (variable): A DXFN12List that specifies the formatting of the insert row of the column, if different from the style specified by istnInsertRow or built-in table styles. This field is present if and only if the cbFmtInsertRow field is more than 0x00000000.

AutoFilter (variable): A Feat11FdaAutoFilter that specifies the characteristics of the AutoFilter for the column. This field is present if and only if the fAutoFilter field of the containing TableFeatureType structure is set to 1.

rgXmap (variable): A Feat11XMap structure that specifies the mapping to the column data within an XML data source. This field is present if and only if the fLoadXmapi bit is set to 1.

fmla (variable): A Feat11Fmla structure that specifies the column formula whose data source is a Web based data provider list. The specified formula applies to every row of the column, except the total row and the header row. This field is present if and only if the fLoadFmla bit is set to 1.

totalFmla (variable): A Feat11TotalFmla structure that specifies the formula to use for the total row of the column. This field is present if and only if the fLoadTotalFmla bit is set to 1.

strTotal (variable): An XLUnicodeString structure that specifies the text to use for the total row of the column. MUST contain less than or equal to 32767 characters. This field is present if and only if the fLoadTotalStr bit is set to 1.

wssInfo (variable): A Feat11WSSListInfo that specifies the relationship between the column and a Web based data provider list. This field is present if and only if the lt field of the containing TableFeatureType structure is set to 0x00000001.

qsif (4 bytes): An unsigned integer that specifies the relationship between the column and its Microsoft Query data source. MUST be equal to the idField field of a Qsif record within the Worksheet Substream. This field is present if and only if the lt field of the containing TableFeatureType structure is set to 0x00000003 (External data source). MUST be greater than zero and MUST be unique within the FieldData array in the containing TableFeatureType structure.

dskHdrCache (variable): A CachedDiskHeader that specifies the column header formatting information. This field is present if and only if the crwHeader field of the containing TableFeatureType structure is set to 0x0000 and the fSingleCell field of the containing TableFeatureType structure is set to 0.