Export (0) Print
Expand All
Expand Minimize

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 GelFramerecord (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 GelFramerecord (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 GelFramerecord (section 2.4.131) specify which of the following gray patterns is used.

Dd951347.91953b17-4be4-470a-ac49-f4249efce6b3(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following dark gray patterns is used.

Dd951347.a6404bfc-3321-41aa-bf90-06e9e7ca2b54(en-us,office.12).jpg Percent60 - Specifies a 60 percent hatch. The ratio of foreground color to background color is 60:100.

Dd951347.81fea233-24d1-4ac4-815d-4780a35d9faf(en-us,office.12).jpg Percent70 - Specifies a 70 percent hatch. The ratio of foreground color to background color is 70:100.

Dd951347.0449f024-c8e0-43b9-9c6a-44f3868022a7(en-us,office.12).jpg Percent75 - Specifies a 75 percent hatch. The ratio of foreground color to background color is 75:100.

Dd951347.c6248e4d-aed5-4346-931b-8a5965d8d578(en-us,office.12).jpg Percent80 - Specifies a 80 percent hatch. The ratio of foreground color to background color is 80:100.

Dd951347.f00efb0e-ac6c-4557-aaae-432b49fcb38a(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following light gray patterns is used.

Dd951347.dc4a0b52-eb13-447e-bbca-fbfcc21fcae2(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following horizontal stripe pattern is used.

Dd951347.dd7b1faa-3e6e-468f-a0f7-9a0f96f5668b(en-us,office.12).jpg DarkHorizontal - Specifies a pattern of horizontal lines.

0x0006

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

Dd951347.eac31272-ec94-47fb-9273-bdf218556922(en-us,office.12).jpg DarkVertical - Specifies a pattern of vertical lines.

0x0007

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

Dd951347.4fac7135-ad98-422a-80e8-af285f2eb3d4(en-us,office.12).jpg DarkDownwardDiagonal - Specifies diagonal lines that slant to the right from top points to bottom points. This hatch pattern is not anti-aliased.

Dd951347.402d287c-1320-42e1-a00d-814457509eed(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following diagonal stripes patterns is used.

Dd951347.a9003789-3a59-4d9d-8fba-d282f95226ba(en-us,office.12).jpg DarkUpwardDiagonal - Specifies diagonal lines that slant to the left from top points to bottom points, but the lines are not anti-aliased.

Dd951347.1c3883dd-c9ba-4d72-8a1f-e19dcb682524(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following grid patterns is used.

Dd951347.4ece63aa-014f-4348-ae91-99a46b5f6269(en-us,office.12).jpg LargeCheckerBoard - Specifies a hatch that has the appearance of a checkerboard with squares that are twice the size of SmallCheckerBoard.

Dd951347.d4bcb8b5-f2c9-40f8-bbdc-abd5296c0d9b(en-us,office.12).jpg Plaid - Specifies a hatch that has the appearance of a plaid material.

Dd951347.615ea650-5c1b-4ceb-a66a-28019a94d52e(en-us,office.12).jpg SmallCheckerBoard - Specifies a hatch that has the appearance of a checkerboard.

Dd951347.b282ee66-fbad-477a-8129-7102b8560c97(en-us,office.12).jpg SolidDiamond - Specifies a hatch that has the appearance of a checkerboard placed diagonally.

Dd951347.f79c43ce-9605-4c01-ac76-722cc974c32a(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following trellis patterns is used.

Dd951347.93797be2-5481-4722-8515-0d6c8c88d2c1(en-us,office.12).jpg Trellis - Specifies a hatch that has the appearance of a trellis.

0x000B

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

Dd951347.65cc9619-4e6e-4d42-ab51-f90060db94e8(en-us,office.12).jpg DashedHorizontal - Specifies dashed horizontal lines.

Dd951347.cbc43169-483f-4596-aae6-36b6e26aed11(en-us,office.12).jpg LightHorizontal - Specifies a pattern of horizontal lines.

Dd951347.381fe44a-4343-423a-be52-90f1ffab05fc(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following light vertical stripes patterns is used.

Dd951347.09a2028c-e397-413b-84d7-cd4e872f6115(en-us,office.12).jpg DashedVertical - Specifies dashed vertical lines.

Dd951347.20428759-6a36-4e68-b891-ccdcd1760ce4(en-us,office.12).jpg LightVertical - Specifies a pattern of vertical lines.

Dd951347.f4c08e36-897d-4fdb-992f-13eacfda1c6b(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following light down patterns is used.

Dd951347.b7dd6a07-41b7-4c71-815a-6a220dcb42ce(en-us,office.12).jpg DashedDownwardDiagonal – Specifies dashed diagonal lines that slant to the right from top points to bottom points.

Dd951347.045efa04-8d16-41c3-a957-a1221fa790dd(en-us,office.12).jpg DiagonalBrick – Specifies a hatch that has the appearance of layered bricks that slant to the left from top points to bottom points.

Dd951347.a62bebde-dc0a-46f9-a7e0-5b8d4c99e494(en-us,office.12).jpg DottedGrid – Specifies horizontal and vertical lines (each of which is composed of dots) that cross.

Dd951347.b18ed8e6-bab6-4b98-9052-4cda14aba72a(en-us,office.12).jpg LightDownwardDiagonal - Specifies diagonal lines that slant to the right from top points to bottom points, but are not anti-aliased.

Dd951347.f3c817df-50d4-46af-b947-82420bf82fcb(en-us,office.12).jpg OutlinedDiamond - Specifies forward diagonal and backward diagonal lines that cross but are not anti-aliased.

Dd951347.f3f4e7d7-e9d7-42dd-868e-12080d36c069(en-us,office.12).jpg Shingle - Specifies a hatch that has the appearance of diagonally layered shingles that slant to the right from top points to bottom points.

Dd951347.b6570bd0-d55d-4daf-b8c5-63089b6e9f5f(en-us,office.12).jpg Wave - Specifies horizontal lines that is composed of tildes.

Dd951347.64e22c06-3efc-4fc5-ba12-b0431b2c45b0(en-us,office.12).jpg ZigZag - Specifies horizontal lines that are composed of zigzags.

0x000E

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

Dd951347.83e01759-afcb-4df0-baed-cd10d628d138(en-us,office.12).jpg DashedUpwardDiagonal – Specifies dashed diagonal lines that slant to the left from top points to bottom points.

Dd951347.ec34fce1-bedf-4523-a07c-e85ac690f297(en-us,office.12).jpg Divot - Specifies a hatch that has the appearance of divots.

Dd951347.24000c51-b5cb-46ab-88dd-aded5cc9d924(en-us,office.12).jpg LightUpwardDiagonal - Specifies diagonal lines that slant to the left from top points to bottom points, but they are not anti-aliased.

Dd951347.ae3fea34-9515-42d6-84dd-6665f4668787(en-us,office.12).jpg Weave - Specifies a hatch that has the appearance of a woven material.

0x000F

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

Dd951347.dee04fc7-8332-49bb-9926-a976c24ef84d(en-us,office.12).jpg HorizontalBrick - Specifies a hatch that has the appearance of horizontally layered bricks.

Dd951347.2e69a879-5a72-4ea6-bcde-49900c5d6be4(en-us,office.12).jpg LargeGrid - Specifies horizontal and vertical lines that cross.

Dd951347.389a4da4-40e6-497b-bbc8-39748b10d347(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following light trellis patterns is used.

Dd951347.330b19a6-9629-4efc-a9f7-4cc31fcd0f4e(en-us,office.12).jpg Percent30 - Specifies a 30 percent hatch. The ratio of foreground color to background color is 30:100.

Dd951347.93db9fbb-ea68-4f94-a620-3741894e0651(en-us,office.12).jpg Percent40 - Specifies a 40 percent hatch. The ratio of foreground color to background color is 40:100.

Dd951347.00f6b59a-76c3-42fa-a8be-857a43a3d335(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following grayscale patterns is used.

Dd951347.931ca277-0ca2-48e9-8d94-10be6fd767a2(en-us,office.12).jpg Percent20 - Specifies a 20 percent hatch. The ratio of foreground color to background color is 20:100.

Dd951347.d022a84e-280f-4ff1-91b0-f089aba2fe44(en-us,office.12).jpg DottedDiamond - Specifies forward diagonal and backward diagonal lines (each of which is composed of dots) that cross.

Dd951347.bc5d8bac-79af-4356-9d34-50d602cbf6d9(en-us,office.12).jpg 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 GelFramerecord (section 2.4.131) specify which of the following grayscale patterns is used.

Dd951347.0f9cc077-a995-4403-a3a8-5e9cf68519c8(en-us,office.12).jpg Percent5 - Specifies a 5 percent hatch. The ratio of foreground color to background color is 5:100.

Dd951347.12ec9c54-2d13-40ea-ae88-01c031f70716(en-us,office.12).jpg 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:
© 2014 Microsoft