2.4.3 AreaFormat

Office

The AreaFormat record specifies the patterns and colors used in a filled region of a chart (section 2.2.3.3). If this record is not present in the sequence of records that conforms to the SS rule (section 2.1.7.20.1) of the Chart Sheet Substream ABNF, the patterns and colors used are specified by the default values of the fields of this record.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

rgbFore

rgbBack

fls

A

B

reserved

icvFore

icvBack

rgbFore (4 bytes): A LongRGB structure (section 2.5.177) that specifies the foreground color of the fill pattern.<23> The default value of this field is automatically selected from the next available color in the chart (section 2.2.3.3) color table.

rgbBack (4 bytes): A LongRGB structure (section 2.5.177) that specifies the background color of the fill pattern.<24> The default value of this field is 0xFFFFFF.

fls (2 bytes): An unsigned integer that specifies the type of fill pattern. If fls is neither 0x0000 nor 0x0001, this record MUST be immediately followed by a corresponding GelFrame record (section 2.4.131) that specifies the fill pattern. The fillType as specified in [MS-ODRAW] section 2.3.7.1 of the OPT1 field of the corresponding GelFrame record (section 2.4.131) MUST be msofillPattern as specified in [MS-ODRAW] section 2.4.11. The default value of this field is 0x0001. fls MUST be a value from the following table:

Value

Meaning

0x0000

The fill pattern is none (no fill). When rgbFore or rgbBack are specified, a pattern of 'none' overrides and means there is no fill.

0x0001

The fill pattern is solid. When solid is specified, rgbFore is the only color rendered, even when rgbBack is also specified.

0x0002

The fill pattern is medium gray. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following gray patterns is used.

Medium gray 50% hatch Percent50 - Specifies a 50 percent hatch. The ratio of foreground color to background color is 50:100.

0x0003

The fill pattern is dark gray. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following dark gray patterns is used.

Dark gray 60 percent hatch Percent60 - Specifies a 60 percent hatch. The ratio of foreground color to background color is 60:100.

Dark gray 70 percent hatch Percent70 - Specifies a 70 percent hatch. The ratio of foreground color to background color is 70:100.

Dark gray 75 percent hatch Percent75 - Specifies a 75 percent hatch. The ratio of foreground color to background color is 75:100.

Dark gray 80 percent hatch Percent80 - Specifies a 80 percent hatch. The ratio of foreground color to background color is 80:100.

Dark gray 90 percent hatch Percent90 - Specifies a 90 percent hatch. The ratio of foreground color to background color is 90:100.

0x0004

The fill pattern is light gray. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light gray patterns is used.

Light gray 25 percent hatch Percent25 - Specifies a 25 percent hatch. The ratio of foreground color to background color is 25:100.

0x0005

The fill pattern is horizontal stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following horizontal stripe pattern is used.

Dark horrizontal stripes DarkHorizontal - Specifies a pattern of horizontal lines.

0x0006

The fill pattern is vertical stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following vertical stripes patterns is used.

Dark vertical stripes DarkVertical - Specifies a pattern of vertical lines.

0x0007

The fill pattern is downward diagonal stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following diagonal stripes patterns is used.

Dark downward diagonal stripes DarkDownwardDiagonal - Specifies diagonal lines that slant to the right from top points to bottom points. This hatch pattern is not anti-aliased.

Wide downward diagonal stripes WideDownwardDiagonal - Specifies diagonal lines that slant to the right from top points to bottom points, are 1.5 times the width of DarkDownwardDiagonal, but are not anti-aliased.

0x0008

The fill pattern is upward diagonal stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following diagonal stripes patterns is used.

Dark upward diagonal stripes DarkUpwardDiagonal - Specifies diagonal lines that slant to the left from top points to bottom points, but the lines are not anti-aliased.

Dark wide upward diagonal stripes WideUpwardDiagonal - Specifies diagonal lines that slant to the left from top points to bottom points, are 1.5 times the width of DarkUpwardDiagonal, but are not anti-aliased.

0x0009

The fill pattern is grid. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following grid patterns is used.

Large checker board pattern LargeCheckerBoard - Specifies a hatch that has the appearance of a checkerboard with squares that are twice the size of SmallCheckerBoard.

Plaid hatch looks like  plaid material Plaid - Specifies a hatch that has the appearance of a plaid material.

Small checker board hatch SmallCheckerBoard - Specifies a hatch that has the appearance of a checkerboard.

Solid diamond hatch looks like checkerboard placed diagonally SolidDiamond - Specifies a hatch that has the appearance of a checkerboard placed diagonally.

Sphere hatch looks like spheres laid adjacent to one another Sphere - Specifies a hatch that has the appearance of spheres laid adjacent to one another.

0x000A

The fill pattern is trellis. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following trellis patterns is used.

Trellis hatch Trellis - Specifies a hatch that has the appearance of a trellis.

0x000B

The fill pattern is light horizontal stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light horizontal stripes patterns is used.

Dashed horizontal lines DashedHorizontal - Specifies dashed horizontal lines.

Light horizontal lines LightHorizontal - Specifies a pattern of horizontal lines.

Narrow light horizontal lines NarrowHorizontal - Specifies horizontal lines that are spaced 25 percent closer together than LightHorizontal.

0x000C

The fill pattern is light vertical stripes. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light vertical stripes patterns is used.

Light dashed vertical lines DashedVertical - Specifies dashed vertical lines.

Light vertical lines LightVertical - Specifies a pattern of vertical lines.

Narrow light vertical lines NarrowVertical - Specifies vertical lines that are spaced 25 percent closer together than LightVertical.

0x000D

The fill pattern is light down. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light down patterns is used.

Dashed downward diagonal lines DashedDownwardDiagonal – Specifies dashed diagonal lines that slant to the right from top points to bottom points.

Diagonal brick hatch DiagonalBrick – Specifies a hatch that has the appearance of layered bricks that slant to the left from top points to bottom points.

Dotted grid lines DottedGrid – Specifies horizontal and vertical lines (each of which is composed of dots) that cross.

Light downward diagonal lines LightDownwardDiagonal - Specifies diagonal lines that slant to the right from top points to bottom points, but are not anti-aliased.

Outlined diamond pattern OutlinedDiamond - Specifies forward diagonal and backward diagonal lines that cross but are not anti-aliased.

Shingle hatch looks like diagonally layered shingles Shingle - Specifies a hatch that has the appearance of diagonally layered shingles that slant to the right from top points to bottom points.

Horizontal wave lines Wave - Specifies horizontal lines that is composed of tildes.

Horizontal zig zag lines ZigZag - Specifies horizontal lines that are composed of zigzags.

0x000E

The fill pattern is light up. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light up patterns is used.

Dashed upward diagonal lines DashedUpwardDiagonal – Specifies dashed diagonal lines that slant to the left from top points to bottom points.

Divot hatch. Divots look like small holes Divot - Specifies a hatch that has the appearance of divots.

Light upward diagonal lines LightUpwardDiagonal - Specifies diagonal lines that slant to the left from top points to bottom points, but they are not anti-aliased.

Weave hatch looks like woven material Weave - Specifies a hatch that has the appearance of a woven material.

0x000F

The fill pattern is light grid. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light grid patterns is used.

Horizontal brick hatch HorizontalBrick - Specifies a hatch that has the appearance of horizontally layered bricks.

Large grid lines LargeGrid - Specifies horizontal and vertical lines that cross.

Small grid lines SmallGrid - Specifies horizontal and vertical lines that cross and are spaced 50 percent closer together than hatch style LargeGrid.

0x0010

The fill pattern is light trellis. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following light trellis patterns is used.

30 percent hatch Percent30 - Specifies a 30 percent hatch. The ratio of foreground color to background color is 30:100.

40 percent hatch Percent40 - Specifies a 40 percent hatch. The ratio of foreground color to background color is 40:100.

Large confetti hatch LargeConfetti - Specifies a hatch that has the appearance of confetti, and is composed of larger pieces than SmallConfetti.

0x0011

The fill pattern is grayscale of 0.125 (1/8) value. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following grayscale patterns is used.

20 percent hatch Percent20 - Specifies a 20 percent hatch. The ratio of foreground color to background color is 20:100.

Dotted diamond pattern DottedDiamond - Specifies forward diagonal and backward diagonal lines (each of which is composed of dots) that cross.

Small confetti hatch SmallConfetti - Specifies a hatch that has the appearance of confetti.

0x0012

The fill pattern is grayscale of 0.0625 (1/16) value. Additional properties in the corresponding GelFrame record (section 2.4.131) specify which of the following grayscale patterns is used.

5 percent hatch Percent5 - Specifies a 5 percent hatch. The ratio of foreground color to background color is 5:100.

Ten percent hatch Percent10 - Specifies a 10 percent hatch. The ratio of foreground color to background color is 10:100.

A - fAuto (1 bit): A bit that specifies whether the fill colors are automatically set. If fls is equal to 0x1 formatting is automatic. The default value of this field is 1.

B - fInvertNeg (1 bit): A bit that specifies whether the foreground and background are swapped when the data value of the filled area is negative. This field MUST be ignored if the formatting is not being applied to a data points (section 2.2.3.10) on a bar or column chart group (section 2.2.3.7). The default value of this field is 0.

reserved (14 bits): MUST be zero, and MUST be ignored.

icvFore (2 bytes): An IcvChart structure (section 2.5.162) that specifies the foreground color of the fill pattern. The default value of this field is automatically selected from the next available color in the chart (section 2.2.3.3) color table.

icvBack (2 bytes): An IcvChart structure (section 2.5.162) that specifies the background color of the fill pattern. The default value of this field is 0x0009.

Show: