2.5.95 MdtFlags
The MdtFlags structure specifies properties and behaviors of a cell metadata (section 2.2.4.2) or value metadata (section 2.2.4.3) type. In general, the behaviors specify that when operations are performed on a cell, the metadata remains associated with the cell or with the value stored in this cell.<69>
The following packet diagram specifies this structure.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
T |
U |
V |
W |
X |
Y |
Z |
a |
b |
c |
|||
A - fGhostRw (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 (1).
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 value is deleted. The value of this field MUST be equal to fClearContents.
E - fCopy (1 bit): A bit that specifies whether the metadata is copied when the cell is copied. The value of this field MUST be 1 if the value of one of the following is 1: fPasteAll, fPasteFmlas, fPasteValues, fPasteFmts, fPasteComments, fPasteDv, fPasteBorders, fPasteColWidths, or fPasteNumFmts.
F - fPasteAll (1 bit): A bit that specifies whether the metadata is pasted when formulas (section 2.2.2), values, formatting, comments, and data validation rules are pasted all at once from the previously copied cell.
G - fPasteFmlas (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 - fPasteFmts (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 - fPasteDv (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 (1) widths are pasted from the previously copied cell.
N - fPasteNumFmts (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 when cells are merged. If the value of this bit is 1, the metadata is preserved for the cell with the smallest row number and the smallest column (1) number among the cells being merged.
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 number and the smallest column (1) number. If fSplitAll is set to 1, this field MUST be ignored.
Q - fSplitAll (1 bit): A bit that specifies whether, when a cell is split, the metadata is copied to all the resulting cells.
R - fRwColShift (1 bit): A bit that specifies whether the metadata is preserved when the cell is shifted because of row or column (1) 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 - fClearFmts (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 are cleared. The value of this field MUST be equal to fDelete.
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 value is propagated through an assignment operation or by a function that returns one of the referenced values.<70>
X - reserved1 (4 bits): This value MUST be 0 and MUST be ignored.
Y - reserved2 (1 bit): This value MUST be 0 and MUST be ignored.<71>
Z - fCanCoerce (1 bit): A bit that specifies whether the metadata is preserved when the cell value is cast to a different type. If the value of this bit is 0, the metadata is not preserved, and the destination cell value is set to the BErr (section 2.5.98.2) #VALUE! (0x0F) error.
a - fAdjust (1 bit): A bit that specifies whether the metadata is updated when the cell location is changed.
b - fCellMeta (1 bit): A bit that specifies whether this metadata type (section 2.2.4.1) is cell metadata or value metadata (section 2.2.4.3).
-
The following table specifies values for this bit.
-
Value
Meaning
0
Metadata is value metadata.
1
Metadata is cell metadata.
-
c - reserved3 (1 bit): MUST be 1 and MUST be ignored.