Feature

Description

Comment

Alignment

This element describes the text alignment in cells. There are a variety of choices for how text is aligned both horizontal and vertically, as well as indentation settings, rotation, and so on.

ImageGear supports only the following alignment attributes:

• Horizontal Alignment
  • General
  • Center
  • Justify
  • Left
  • Right
• Vertical Alignment
  • Top
  • Center
  • Bottom
• Indent
• Reading Order
• Wrap Text

Other alignment properties not mentioned here are not supported and will be ignored.

Background Color

This element describes the background color of the cell fill pattern. Cell fill patterns operate with two colors: a background color and a foreground color. These combine to make a patterned cell fill.

ImageGear only supports the solid fill pattern. In this case, only the foreground color is used to produce the fill effect. This means that the background color is, effectively, ignored.

Borders

The border element expresses a single set of cell border formats (left, right, top, bottom, diagonal). Color is optional. When missing, ‘automatic’ is implied.

ImageGear supports all border sides, including both diagonal directions. 

The following border types are supported:

• Thin
• Thick
• Medium
• Hair
• MediumDashDot
• DashDot
• MediumDashDotDot
• DashDotDot
• MediumDashed
• Dashed
• Dotted
• Double

The SlantDashDot is not supported and will be rendered as the regular DashDot border type.

Fills

This element defines the cell, which consists of a background color, foreground color, and pattern to be applied across the cell.

ImageGear only supports the Solid pattern fill. Other fill types, like gradients, are ignored.

Fonts

This element defines the properties for one of the fonts used in a workbook.

The following font attributes are supported:

• Bold
• Font Family (Supported True Type fonts only)
• Italic
• Font Name
• Strike Through
• Font Size
• Underline

Foreground Color

This element describes the foreground color of the cell fill pattern. Cell fill patterns operate with two colors: a background color and a foreground color. These combine to make a patterned cell fill.

ImageGear supports the following foreground color sources and effects:

• Automatic
• Indexed
• RGB
• Theme Color
• Tint

Indexed Colors

This element collection defines the legacy indexing scheme for colors that are still required for some records, and for backwards compatibility with legacy formats.

All indexed colors are fully supported. Specifically, the colors are: 

• "0"  00000000   
• "1"  00FFFFFF   
• "2"  00FF0000   
• "3"  0000FF00   
• "4"  000000FF   
• "5"  00FFFF00   
• "6"  00FF00FF   
• "7"  0000FFFF   
• "8"  00000000   
• "9"  00FFFFFF   
• "10"  00FF0000   
• "11"  0000FF00   
• "12"  000000FF   
• "13"  00FFFF00   
• "14"  00FF00FF   
• "15"  0000FFFF   
• "16"  00800000   
• "17"  00008000   
• "18"  00000080   
• "19"  00808000   
• "20"  00800080   
• "21"  00008080   
• "22"  00C0C0C0   
• "23"  00808080   
• "24"  009999FF   
• "25"  00993366   
• "26"  00FFFFCC   
• "27"  00CCFFFF   
• "28"  00660066   
• "29"  00FF8080   
• "30"  000066CC   
• "31"  00CCCCFF   
• "32"  00000080   
• "33"  00FF00FF   
• "34"  00FFFF00   
• "35"  0000FFFF   
• "36"  00800080   
• "37"  00800000   
• "38"  00008080   
• "39"  000000FF   
• "40"  0000CCFF   
• "41"  00CCFFFF   
• "42"  00CCFFCC   
• "43"  00FFFF99   
• "44"  0099CCFF   
• "45"  00FF99CC   
• "46"  00CC99FF   
• "47"  00FFCC99   
• "48"  003366FF   
• "49"  0033CCCC   
• "50"  0099CC00   
• "51"  00FFCC00   
• "52"  00FF9900   
• "53"  00FF6600   
• "54"  00666699   
• "55"  00969696   
• "56"  00003366   
• "57"  00339966   
• "58"  00003300   
• "59"  00333300   
• "60"  00993300   
• "61"  00993366   
• "62"  00333399   
• "63"  00333333
• "64"  System Foreground
• "65"  System Background

Number Format

This element defines the number formats in a workbook, consisting of a sequence of numFmt records, where each numFmt record defines a particular number format, indicating how to format and render the numeric value of a cell.

The number formatting system of the SpreadsheetML defines an extensive architecture for formatting numbers. ImageGear currently only support a small subset of number formats. These include all of the built-in formats, which are: 

• General
• 0
• 0.00
• #,##0
• #,##0.00
• 0%
• 0.00%
• 0.00E+00
• # ?/?
• # ??/??
• mm-dd-yy
• d-mmm-yy
• d-mmm
• mmm-yy
• h:mm AM/PM
• h:mm:ss AM/PM
• h:mm
• h:mm:ss
• m/d/yy h:mm
• #,##0 ;(#,##0)
• #,##0 ;[Red](#,##0)
• #,##0.00;(#,##0.00)
• #,##0.00;[Red](#,##0.00)
• mm:ss
• [h]:mm:ss
• mmss.0
• ##0.0E+0
• @ 

In additional to the built-in formats, ImageGear also supports a handful of special case formats, which are: 

• 0.0
• 0.00
• 0.000
• 0.0000
• 0.00000
• $#,##0,00
• m/d/yy
• [$-F800]dddd, mmmm dd, yyyy
• [$-F400]h:mm:ss AM/PM