Share via

2.5.4 AutoFormatID

  • Article

The AutoFormatID structure is a 2-byte unsigned integer that specifies the AutoFormat to be applied. The value of this structure MUST be a value from the following table.<59>

Value

Meaning

0x0000

Table style value 0x0000. All text black on white background, column headers bold, row header for total row bold, row header and total row have borders

0x0001

Table style value 0x0001. All text black on white background, column headers italic, column header for total column bold, row header for total row bold, row and column heads have borders

0x0002

Table style value 0x0002. Column headers white text on purple background, row headers black bold text on gray background, row header for total row blue bold text

0x0003

Table style value 0x0003. Column headers white italic on blue background, row headers black bold on gray background, total row white background with black bold header, values area blue text on gray background

0x0004

Table style value 0x0004. Column headers gray italic text, total row and column headers italic text, row header and total row have borders, table has white background

0x0005

Table style value 0x0005. All text black on white background, column headers purple border, total row purple border

0x0006

Table style value 0x0006. All text black on white background, column headers italic text, column header blue bottom border, total row header bold, total row has black borders

0x0007

Table style value 0x0007. All text black on white background, column headers underlined, total row has thick bottom border

0x0008

Table style value 0x0008. Column headers white italic text on black background, row headers white bold italic text on blue background, values area light turquoise text on dark turquoise background, turquoise border between rows

0x0009

Table style value 0x0009. Column headers white bold italic text on dark red background, row headers black bold italic text on yellow background, total column has gray background

0x000A

Table style value 0x000A. Column headers gray bold italic text, total column header light blue bold italic text, row headers light purple bold italic text, total row header gray bold text, table has black background

0x000B

Table style value 0x000B. Column headers dark red italic text on gray background, total row header black bold text. Rows alternate gray and white background. Table has outside turquoise border

0x000C

Table style value 0x000C. Column headers white bold text on dark green background, total row header black bold text, total row has dark gray borders, values area background alternates two light green two white

0x000D

Table style value 0x000D. Column headers blue bold text, total row header blue italic text, gray borders between rows, table has white background

0x000E

Table style value 0x000E. Column headers purple text, row headers black bold text, total row header blue bold text, values area (not including Total row and column) appears indented, table has gray background

0x000F

Table style value 0x000F. All text black on a gray background. Column headers bold text, total row header bold text, values area alternate rows appear indented

0x0010

Table style value 0x0010. All text black on white background, no borders

0x0011

Table style value 0x0011. All text black on white background, column and row headers localized, column headers and total row have black border

0x0012

Table style value 0x0012. Black text, column and row headers localized, rows alternate tan and white, total row has light purple background

0x0013

Table style value 0x0013. Black text, column and row headers are localized, row headers have light green background, values in total column have tan background, headers and total areas have black borders

0x0014

Table style value 0x0014. Black text on a white background, column and row headers are localized, table has a black grid border

0x1000

PivotTable style value 0x1000 using Outline Layout. Column headers white bold text on black background, subtotals at top of each group with black text on gray background, black border below first level row

0x1001

PivotTable style value 0x1001 using Outline Layout. Column headers white bold text on black background, first level row headers black bold text on yellow background, black border above total row

0x1002

PivotTable style value 0x1002 using Outline Layout. Column headers and first level row headers white bold text on black background, third level row headers black bold text on gray background, subtotals at top of each group, black borders below first and third levels

0x1003

PivotTable style value 0x1003 using Outline Layout. Column headers white bold text on purple background, first level row headers black bold text on light purple background, third and fourth level row headers purple bold text, subtotal row purple bold text, some purple borders

0x1004

PivotTable style value 0x1004 using Outline Layout. Column headers white bold text on black background, first level row headers black bold text on gray background, third and fourth levels row headers and subtotal row gray bold text, some black borders

0x1005

PivotTable style value 0x1005 using Outline Layout. Column headers brown bold text on white background, first level row headers white bold text on dark blue background, second level row subtotal is white bold text on gray background, third and fourth level row headers dark blue bold text, subtotals at top of each group, red and blue borders

0x1006

PivotTable style value 0x1006 using Outline Layout. Column headers are white bold text on black background, first level row headers white bold text on black background, second level row headers and total row black text on gray background, black border under header levels

0x1007

PivotTable style value 0x1007 using Outline Layout. Column headers are white bold text on black background, first level row headers white bold text on purple background, third and fourth level header and subtotal row gray text, some black borders

0x1008

PivotTable style value 0x1008 using Outline Layout. Column headers white bold text on black background, first level rows white bold text on dark gray background, second level row header black bold text on gray background, third level row header white text on black background, fourth level row header black italic text, black borders

0x1009

PivotTable style value 0x1009 using Outline Layout. Column headers white bold text on black background, first level row is large font black bold text, second level row green background with white bold text, fourth level row green text, black and green borders

0x100A

PivotTable style value 0x100A using Tabular Layout. First level column headers white bold text on black background, first level row headers and total rows white bold text on black background, black borders

0x100B

PivotTable style value 0x100B using Tabular Layout. First level column headers purple bold text on gray background, first level row headers purple bold text on gray background, total rows white bold text on purple background, black borders

0x100C

PivotTable style value 0x100C using Tabular Layout. First level column headers and columns alternate white text on black background and black text on white background, second level row headers and values area italic text, black borders

0x100D

PivotTable style value 0x100D using Tabular Layout. First level column headers and columns alternate white and gray backgrounds, first level row headers and totals row black bold text on yellow background, black borders

0x100E

PivotTable style value 0x100E using Tabular Layout. First level column headers vertical black bold text, second level column headers white bold text on black background, second level rows and values area (not including total rows) italic text, black borders

0x100F

PivotTable style value 0x100F using Tabular Layout. First level column headers light green bold text on dark green background, total rows dark green text on a light green background, black and red borders

0x1010

PivotTable style value 0x1010 using Tabular Layout. First level column headers black bold text on gray background, second level column headers white bold text on black background, total rows black bold text on gray background, black borders

0x1011

PivotTable style value 0x1011 using Tabular Layout. First level column headers vertical green bold text, first two second level column headers red bold text, total rows have black bold text on gray background, black and red borders

0x1012

PivotTable style value 0x1012 using Tabular Layout. First level column headers vertical black bold text on gray background, total rows white bold text on black background, black borders

0x1013

PivotTable style value 0x1013 using Tabular Layout. First level column headers orange text on black background, total rows black bold text on orange background, black borders

0x1014

PivotTable style value 0x1014 using Tabular Layout. Black text on white background, first two second level column headers have gray background, black borders

0x1015

PivotTable style value 0x1015 using Tabular Layout. Black text on white background, first two second level column headers have gray background, black borders only around first two second level column headers