Sheets are the fundamental parts within a workbook, and are where the user does most of their spreadsheet work. The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can contain text, numbers, dates and formulas. Cells can be formatted as well.

For the other sheet types such as chartsheets and dialogsheets, the content is ignored and a blank 8.5” x 11” page will be created in its place.

Feature	Description	Comment
Row	This element expresses information about an entire row of a worksheet, and contains all cell definitions for a particular row in the worksheet.	The following row attributes are supported: Custom Format Row Height Row Index Style Index ImageGear does not support the outline feature, which enables the user to collapse and expand one or more rows in the application.
Cell	This element represents a cell in the worksheet. Information about the cell’s location (reference), value, data type, formatting, and formula is expressed here.	The cell element is fully supported by ImageGear. However, certain cell formatting characteristics are not. See the Styles section for more details.
Merged Cells	The element expressed the ranged of a merged cell in the worksheet.	Merged cells are fully supported in most cases. However, there is a specific limitation of merged cells if they break across page boundaries in the paginated worksheet view (ImageGear.Formats.Office.ImGearExcelSheetPage). In this case, all text of the merged cells will be contained on the page where the first section of the merged cell exists.
Cell Value	This element expresses the value contained in a cell. If the cell contains a string, then this value is an index into the shared string table, pointing to the actual string value. Otherwise, the value of the cell is expressed directly in this element. Cells containing formulas express the last calculated result of the formula in this element.	The cell value element is fully supported by ImageGear. However, certain cell formatting characteristics are not. See the Styles section for more details.  Cells containing formulas will be supported if the last calculated value is included here. Otherwise, the cell’s formula is ignored.
Inline Text	This element allows for strings to be expressed directly in the cell definition instead of implementing the shared string table.	Fully supported.
Break	This element defines individual row or column breaks.	Both horizontal (row) and vertical (column) page breaks are fully supported.
Column Width & Formatting	This element defines the column width and formatting for one or more columns of the worksheet.	SpreadsheetML defines column formatting attributes to allow rows and columns to be expanded and collapsed from the user interface. This feature called outline is not supported by ImageGear.  Supported column attributes are: Width Hidden
Dimension	This element specifies the used range of the worksheet. It specifies the row and column bounds of used cells in the worksheet. This is optional and is not required.	ImageGear will attempt to use the dimension element to correctly size the worksheet page to encompass the active content. If the dimension element does not exist, the worksheet content will be scanned to determine the range of used cells manually.
Page Margins	This element defines the page margins for a sheet.	Supported margins are: Top Left Right Bottom
Page Setup	This element defines the page setup settings for the worksheet.	The page setup collection describes a variety of settings for printing a worksheet. ImageGear currently only uses the page size attribute to automatically determine a size for pages when a worksheet is paginated. Other page setup attributes are ignored.  The following page sizes are supported for automatic detection: Letter (8.5” x 11”) Letter Small (8.5” x 11”) Tabloid (11” x 17”) Ledger (17” x 11”) Legal (8.5” x 14”) Statement (5.5” x 8.5”) Executive (7.25” x 10.5”) A3 (297 mm x 420 mm) A4 (210 mm x 297 mm) A4 Small (210 mm x 297 mm) A5 (148 mm x 210 mm) B4 (250 mm x 353 mm) B5 (176 mm x 250 mm)
Sheet Format Properties	This element defines several formatting properties for a worksheet.	The following sheet formatting properties are supported: Base Column Width Custom Height Default Column Width Default Row Height Thick Bottom Thick Top Zero Height (Hidden)