Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

2.1.7.20.3 Globals Substream

Office

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)

Show:
© 2015 Microsoft