2.4.90 Dimensions
The Dimensions record specifies the used range of the sheet. It specifies the row and column bounds of used cells in the sheet. Used cells include all cells with formulas (section 2.2.2) or data. Used cells also include all cells with formatting applied directly to the cell. Cells can also be formatted by default row or column formatting. If a row has default formatting then the used range includes that row in its row bounds, but does not affect the used range column bounds, unless the used range would otherwise be empty, in which case the column bounds are set to include the first column. If a column has default formatting then the used range includes that column in its column bounds, but does not affect the used range row bounds, unless the used range would otherwise be empty, in which case the row bounds are set to include the first row.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
rwMic |
|||||||||||||||||||||||||||||||
|
rwMac |
|||||||||||||||||||||||||||||||
|
colMic |
colMac |
||||||||||||||||||||||||||||||
|
reserved |
|||||||||||||||||||||||||||||||
rwMic (4 bytes): A RwLongU structure that specifies the first row in the sheet that contains a used cell.
rwMac (4 bytes): An unsigned integer that specifies the zero-based index of the row after the last row in the sheet that contains a used cell. MUST be less than or equal to 0x00010000. If this value is 0x00000000, no cells on the sheet are used cells.
colMic (2 bytes): A ColU structure that specifies the first column in the sheet that contains a used cell.
colMac (2 bytes): An unsigned integer that specifies the zero-based index of the column after the last column in the sheet that contains a used cell. MUST be less than or equal to 0x0100. If this value is 0x0000, no cells on the sheet are used cells.
reserved (2 bytes): MUST be zero, and MUST be ignored.