ImageGear for .NET
Worksheets

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.

Picture Specifies the existence of an embedded picture. ImageGear supports raster pictures only.
Shape Specifies the existence of a shape.

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.

Chart Specifies the existence of a chart.

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)

 Chart Rendering Properties

The DrawingML charts rendered by ImageGear and rendered by MS Office may have visual differences, because OpenXML specification does not contain rendering details for some chart elements. These differences include the relative positions of chart elements such as: title, axes, axes ticks, labels, legend, order of series in a legend, number of major and minor gridlines, and number of labels per axis. Also, combined charts axes maximum and minimum values (chart scaling) may differ from MS Office; as a result, the combined charts (relative positions of chart data series) rendered by ImageGear in the same plot area may visually differ from MS Office rendering. These differences do not have strict definition in OpenXML specification, and their rendering details are left up to the implementers.

Property dialogs of XLSX Charts have various customization settings. For those properties there are a few limitations in ImageGear that should be considered. Please note that only the supported properties/features are listed below; features not listed are not currently supported.

Chart Area Properties

Plot Area Properties

Value Axis Properties

Category Axis Properties

Chart Axis Title (Horizontal and Vertical) Properties

Legend Properties

Gridlines Properties

Data Series Properties

Line Charts

Bar/Column Charts

Data Labels Properties

Line Charts

Bar/Column Charts

 

 


©2014. Accusoft Corporation. All Rights Reserved.

Send Feedback