Export (0) Print
Expand All
Expand Minimize

2.5.238 SheetExtOptional

Office

The SheetExtOptional structure specifies sheet specific data including sheet tab color and the published state of this sheet.


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

icvPlain12

A

B

reserved

color (16 bytes)

...

icvPlain12 (7 bits): An unsigned integer that specifies the tab color of this sheet. If the tab has a color assigned to it, the value of this field MUST be greater than or equal to 0x08 and less than or equal to 0x3F, as specified in the color table for Icv. If this value does not equal to icvPlain of the associated SheetExt, the value of icvPlain takes precedence. If the tab has no color assigned to it, the value of this field MUST be 0x7F, and MUST be ignored.

A - fCondFmtCalc (1 bit): A bit that specifies whether conditional formatting formulas are evaluated. MUST be one of the following:

Value

Meaning

0

Conditional formatting formulas in this workbook are not evaluated.

1

Conditional formatting formulas in this workbook are evaluated.

B - fNotPublished (1 bit): A bit that specifies whether this sheet is published. MUST be ignored when this sheet is a chart sheet, dialog sheet, or macro sheet. MUST be a value from the following table:

Value

Meaning

0

The sheet is published.

1

The sheet is not published.

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

color (16 bytes): A CFColor that specifies the tab color. Used only when the tab color was not modified by earlier versions of the application.

Show:
© 2014 Microsoft