2.4.162 MDTInfo
The MDTInfo record specifies the information about a single type of metadata.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
frtHeader |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
T |
U |
V |
W |
unused1 |
X |
Y |
Z |
a |
||||
|
stName (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
frtHeader (12 bytes): An FrtHeader structure. The frtHeader.rt field MUST be 0x0884.
A - fGhostRow (1 bit): A bit that specifies whether the metadata is applied to all cells in newly inserted rows.
B - fGhostCol (1 bit): A bit that specifies whether the metadata is applied to all cells in newly inserted columns.
C - fEdit (1 bit): A bit that specifies whether the metadata is preserved when the cell is edited.
D - fDelete (1 bit): A bit that specifies whether the metadata is preserved when the cell's value is deleted.
E - fCopy (1 bit): A bit that specifies whether the metadata is copied when the cell is copied. MUST be 1 if one or more of the values of fPasteAll, fPasteFormulas, fPasteValues, fPasteFormats, fPasteComments, fPasteDataValidation, fPasteBorders, fPasteColWidths, or fPasteNumberFormats is 1.
F - fPasteAll (1 bit): A bit that specifies whether the metadata is pasted when all formulas, values, formatting, comments, and data validation rules are pasted from the previously copied cell.
G - fPasteFormulas (1 bit): A bit that specifies whether the metadata is pasted when only formulas are pasted from the previously copied cell.
H - fPasteValues (1 bit): A bit that specifies whether the metadata is pasted when only values are pasted from the previously copied cell.
I - fPasteFormats (1 bit): A bit that specifies whether the metadata is pasted when only formatting is pasted from the previously copied cell.
J - fPasteComments (1 bit): A bit that specifies whether the metadata is pasted when only comments are pasted from the previously copied cell.
K - fPasteDataValidation (1 bit): A bit that specifies whether the metadata is pasted when only data validation rules are pasted from the previously copied cell.
L - fPasteBorders (1 bit): A bit that specifies whether the metadata is pasted when only borders are pasted from the previously copied cell.
M - fPasteColWidths (1 bit): A bit that specifies whether the metadata is pasted when only column widths are pasted from the previously copied cell.
N - fPasteNumberFormats (1 bit): A bit that specifies whether the metadata is pasted when only number formatting is pasted from the previously copied cell.
O - fMerge (1 bit): A bit that specifies whether the metadata is preserved after cells are merged. If the value of this bit is 1, and the cell has the smallest row and column number of the cells that are being merged, the metadata is preserved.
P - fSplitFirst (1 bit): A bit that specifies whether, when a cell is split, the metadata is copied to the cell with the smallest row and column number. If fSplitAll is set to 1, fSplitAll takes precedence.
Q - fSplitAll (1 bit): A bit that specifies whether, when a cell is split, the metadata is copied to all the resulting cells. If the value is 1, the value of fSplitFirst MUST be ignored.
R - fRowColShift (1 bit): A bit that specifies whether the metadata is preserved when the cell is shifted because of row or column deletion or insertion.
S - fClearAll (1 bit): A bit that specifies whether the metadata is preserved when the contents, formatting, and comments of the cell are cleared.
T - fClearFormats (1 bit): A bit that specifies whether the metadata is preserved when the formatting of the cell is cleared.
U - fClearContents (1 bit): A bit that specifies whether the metadata is preserved when the contents of the cell is cleared.
V - fClearComments (1 bit): A bit that specifies whether the metadata is preserved when the comments of the cell are cleared.
W - fAssign (1 bit): A bit that specifies whether the metadata is preserved when the cell's value is changed by formula (section 2.2.2) assignment.
unused1 (5 bits): Undefined and MUST be ignored.
X - fCoerce (1 bit): A bit that specifies whether the metadata is preserved when the cell's value is coerced to a different type.
Y - fAdjust (1 bit): A bit that specifies whether the metadata is updated when the cell's location is changed.
Z - fCellMeta (1 bit): A bit that specifies whether this metadata type is cell metadata or value metadata. MUST be 0 from the following table:
-
Value
Meaning
0
Metadata is value metadata.
1
Metadata is cell metadata.
a - unused2 (1 bit): Undefined and MUST be ignored.
stName (variable): An LPWideString type that specifies the name of the metadata type.