Export (0) Print
Expand All
Expand Minimize

2.4.30 BuiltInFnGroupCount

Office

The BuiltInFnGroupCount record specifies the beginning of a collection of records as defined by the Globals SubstreamABNF. The collection of records specifies information about the built-in function categories in the workbook.


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

count

count (2 bytes): An unsigned integer that specifies the number of built-in function categories in the workbook. The sum of count, the count of FnGroupName (section 2.4.120) records and the count of FnGrp12 (section 2.4.121) records in the current workbook MUST be less than or equal to 256. The user-defined function categories include those defined in FnGroupName records and FnGrp12 records. The value MUST be one of the following:

Value

Meaning

0x0E

There are 14 built-in function categories in the workbook. This implies that the file was last saved by a specific version of the application<46>.

The following 9 built-in function categories are visible to the end-user: Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, Logical, Information.

The following 5 built-in function categories are not visible to the end-user: UserDefined, Commands, Customize, MacroControl, DDEExternal.

0x10

There are 16 built-in function categories in the workbook. This implies that the file was last saved by a specific version of the application<47>.

The following 11 built-in function categories are visible to the end-user: Financial, Date & time, Math & Trig, Statistical, Lookup & Reference, Database, Text, Logical, Information, Engineering, Cube.

The following 5 built-in function categories are not visible to the end-user: UserDefined, commands, Customize, MacroControl, DDEExternal

Show:
© 2014 Microsoft