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.

ImageGear supports a limited set of shapes.

• Line shapes: Line/Straight Connector, Elbow Connector, Curved Connector, Curve, Freeform, Scribble.
• Rectangle shapes: Rectangle, Rounded Rectangle, Snip Single Corner Rectangle, Snip Same Side Corner Rectangle, Snip Diagonal Corner Rectangle.
• Basic shapes: Oval, Isosceles Triangle, Right Triangle, Parallelogram, Trapezoid, Diamond, Regular Pentagon, Hexagon, Heptagon, Octagon, Decagon, Dodecagon, Can, Cube, Folded Corner, Cloud.
• Block Arrow shapes: Right Arrow, Left Arrow, Down Arrow, Up Arrow, Left-Right Arrow, Up-Down Arrow, Left-Up Arrow, Bent-Up Arrow, Curved Right Arrow, Curved Left Arrow, Curved Up Arrow, Curved Down Arrow, Pentagon, Chevron.
• Flow Chart shapes: Process, Alternate Process, Decision, Data, Predefined Process, Internal Storage, Document, Multidocument, Terminator, Preparation, Manual Input, Manual Operation, Connector, Off-page Connector, Card, Punched Tape, Magnetic Disk, Direct Access Storage.
• Callout shapes: Rectangular Callout, Rounded Rectangular Callout, Oval Callout, Cloud Callout.
• Group shapes (many shapes grouped together).

The shapes not listed above will not be rendered by ImageGear.

ImageGear supports a limited set of charts:

• Line
• Stacked Line
• 100% Stacked Line
• Line With Markers
• Stacked Line With Markers
• 100% Stacked Line With Markers
• Scatter with Straight Lines
• Scatter with Only Markers
• Scatter with Straight Lines and Markers
• Clustered Column
• Stacked Column
• 100% Stacked Column
• Clustered Bar
• Stacked Bar
• 100% Stacked Bar

ImageGear supports all possible combinations of above mentioned Charts.

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)