2.1.7.20.3 Globals Substream

The Globals Substream specifies global properties and data in a workbook.

There MUST be exactly one Globals Substream in a Workbook Stream (section 2.1.7.20), and the Globals Substream MUST be the first substream in the Workbook Stream.

Record sequence<5><6>ABNF:

WORKBOOKCONTENT = [WriteProtect] [FilePass] [Template] INTERFACE WriteAccess [FileSharing] CodePage *2047LelDSF [Excel9File] RRTabId [ObProj] [ObNoMacros] [CodeName] [FNGROUPS] *Lbl [OleObjectSize] PROTECTION 1*Window1BackupHideObjDate1904CalcPrecisionRefreshAllBookBool FORMATTING *(PIVOTCACHEDEFINITION) [DOCROUTE] *UserBViewUsesELFs 1*BUNDLESHEET METADATA [MTRSettings] [ForceFullCalculation] Country *SUPBOOK *LBL *RTD [RecalcId] *HFPicture *MSODRAWINGGROUP [SHAREDSTRINGS] ExtSST *WebPub [WOpt] [CrErr] [BookExt] *FeatHdr *DConn [THEME] [CompressPictures] [Compat12] [GUIDTypeLib] EOF

WORKBOOK = BOF WORKBOOKCONTENT

INTERFACE = InterfaceHdrMmsInterfaceEnd

FNGROUPS = BuiltInFnGroupCount *FnGroupName *FnGrp12

PROTECTION = WinProtectProtectPasswordProt4RevProt4RevPass

FORMATTING = 1*510Font 8*218Format XFS *DXF STYLES [TABLESTYLES] [Palette] [ClrtClient]

XFS = 16*XF [XFCRC 16*4050XFExt]

STYLES = 1*(Style [StyleExt])

TABLESTYLES = TableStyles *(TableStyle *28TableStyleElement)

PIVOTCACHEDEFINITION = SXStreamIDSXVS [SXSRC] [SXADDLCACHE]

SXSRC = DREF / SXTBL / DBQUERY

DREF = DConName / DConBin / DConRef

SXTBL = SXTbl *DREF *SxTbpg *(SXTBRGIITM *SXString)

DBQUERY = DbOrParamQry [1*SXString [DbOrParamQry *(SXString DbOrParamQry)]] *SXString

DOCROUTE = DocRoute 1*65535RecipName

BUNDLESHEET = BoundSheet8

METADATA = *MDTINFO *MDXSTR *(MDXTUPLESET / MDXProp / MDXKPI) *MDBLOCK

MDTINFO = MDTInfo *ContinueFrt12

MDXSTR = MDXStr *ContinueFrt12

MDXTUPLESET = (MDXTuple / MDXSet) *ContinueFrt12

MDBLOCK = MDB *ContinueFrt12

SUPBOOK = SupBook [*ExternName *(XCT *CRN)] [ExternSheet] *Continue

LBL = Lbl [NameCmt] [NameFnGrp12] [NamePublish]

RTD = RealTimeData *ContinueFrt

MSODRAWINGGROUP = MsoDrawingGroup *Continue

SHAREDSTRINGS = SST *Continue

THEME = Theme *ContinueFrt12

SXADDLCACHE = SXAddl_SXCCache_SXDIdSXAddl_SXCCache_SXDVer10Info [SXAddl_SXCCache_SXDVerSXMacro] [SXADDLCACHE12] [SXADDLDBQUERY] *UNKNOWNFRT SXAddl_SXCCache_SXDEnd

SXADDLCACHE12 = SXAddl_SXCCache_SXDVerUpdInvSXAddl_SXCCache_SXDInfo12SXAddl_SXCCache_SXDInvRefreshReal *SXADDLCACHEFIELD [SXADDLSXDH] [SXADDLSXMGS] SXAddl_SXCCache_SXDVerUpdInv

SXADDLSXDH = SXAddl_SXCSXDH_SXDId *SXAddl_SXCSXDH_SXDSxdhSXAddl_SXCSXDH_SXDEnd

SXADDLSXMGS = SXAddl_SXCSXMgs_SXDId *SXADDLSXMG *SXAddl_SXCSXMgs_SXDMGrpSXDHMap *UNKNOWNFRT SXAddl_SXCSXMgs_SXDEnd

SXADDLSXMG = SXAddl_SXCSXMg_SXDId *Continue_SxaddlSxString [SXAddl_SXCSXMg_SXDUserCaption *Continue_SxaddlSxString] *UNKNOWNFRT SXAddl_SXCSXMg_SXDEnd

SXADDLCACHEFIELD = SXAddl_SXCCacheField_SXDId *Continue_SxaddlSxString [SXAddl_SXCCacheField_SXDCaption *Continue_SxaddlSxString] [SXAddl_SXCCacheField_SXDProperty [SXAddl_SXCCacheField_SXDPropName *Continue_SxaddlSxString]] [SXAddl_SXCCacheField_SXDIfdbMpMapCountSXAddl_SXCCacheField_SXDIfdbMempropMap] [SXAddl_SXCCacheField_SXDSxrmitmCount *SXADDLCACHEITEM SXAddl_SXCCacheItem_SXDEnd] SXAddl_SXCCacheField_SXDEnd

SXADDLCACHEITEM = SXAddl_SXCCacheItem_SXDId [SXAddl_SXCCacheItem_SXDSxrmitmDisp *Continue_SxaddlSxString] *(SXAddl_SXCCacheItem_SXDItmMpMapCountSXAddl_SXCCacheItem_SXDItmMpropMap)