2.5.140 SrvFmtData

The SrvFmtData structure specifies the number format on the server.


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

cb

dwSrvFmtNum

cb (4 bytes): An unsigned integer that specifies the size in bytes of the data that follows this field. Its value MUST be equal to 0x00000004.

dwSrvFmtNum (4 bytes): An unsigned integer that specifies the number format on the server, and whose value is dictated by the value of sff.fSrvFmtNumStr of the associated BrtBeginMdxTuple (section 2.4.110) record, as specified in the following table.

Value of sff.fSrvFmtNumStr

Meaning of dwSrvFmtNum

0

Value specifies one of the built-in number formats as described in the following table.

1

Value is an index to a string in the metadata string store (section 2.2.4.7). That string contains information about how to format the number. For more information about how format strings are interpreted, see [ISO/IEC29500-1:2016], section 18.8.31. The ABNF grammar for the format string is specified in [MS-XLS] section 2.4.126.

The value of dwSrvFmtNum MUST be a value from the following table when the value of sff.fSrvFmtNumStr is 0.

Value

Format specification

Example formatted data

0x00000000

General

3.14159

0x0000000E

0.00%

20.73%

0x00000013

m/d/yyyy

1/13/1999