2.1.8 Common Productions
Record sequence fragments that are common to multiple parts are specified in this section. If a fragment cannot be found under its part, it can be found in the following ABNF grammar.
The FRT rule can contain any number of other valid Records (section 2.1.4) between BrtFRTBegin (section 2.4.684) and BrtFRTEnd (section 2.4.685).
WSVIEWS = BrtBeginWsViews 1*WSVIEW *FRT BrtEndWsViews
WSVIEW = BrtBeginWsView [BrtPane] *4BrtSel *FRT BrtEndWsView
WSFMTINFO = [ACWSFMTINFO] BrtWsFmtInfo
ACWSFMTINFO = BrtACBegin BrtWsFmtInfoEx14 BrtACEnd
COLINFOS = BrtBeginColInfos 1*BrtColInfo BrtEndColInfos
CELLTABLE = BrtBeginSheetData *1048576([ACCELLTABLE] BrtRowHdr *16384CELL *FRT) BrtEndSheetData
ACCELLTABLE = BrtACBegin BrtRwDescent BrtACEnd
CELL = (DATACELL / FMLACELL / SHRFMLACELL / TABLECELL) *FRT
DATACELL = CELLMETA (BrtCellBlank / BrtCellRk / BrtCellError / BrtCellBool / BrtCellReal / BrtCellIsst / BrtCellSt)
FMLACELL = CELLMETA (BrtFmlaString / BrtFmlaNum / BrtFmlaBool / BrtFmlaError)
SHRFMLACELL = FMLACELL (BrtShrFmla / BrtArrFmla)
TABLECELL = BrtTable CELLMETA (BrtCellRk / BrtCellError / BrtCellBool / BrtCellReal / BrtCellSt)
CELLMETA = [BrtCellMeta] [BrtValueMeta]
AUTOFILTER = [ACUID] BrtBeginAFilter *FILTERCOLUMN [SORTSTATE] *FRT BrtEndAFilter
FILTERCOLUMN = BrtBeginFilterColumn [BrtDynamicFilter / BrtTop10Filter / BrtColorFilter / BrtIconFilter / CUSTOMFILTERS / FILTERS / ACFILTERCONTENT / RICHFILTERCONTENT] *FRT BrtEndFilterColumn
CUSTOMFILTERS = BrtBeginCustomFilters 1*2BrtCustomFilter BrtEndCustomFilters
FILTERS = BrtBeginFilters *BrtFilter *BrtAFilterDateGroupItem BrtEndFilters
ACFILTERCONTENT = (ACFILTERS / ACCUSTOMFILTER / ACICONFILTER) BrtACBegin CUSTOMFILTERS BrtACEnd
ACCUSTOMFILTER = BrtBeginCustomFilters14 1*2BrtCustomFilter14 BrtEndCustomFilters
ACFILTERS = BrtACBegin BrtBeginFilters *BrtFilter14 BrtEndFilters BrtACEnd
ACICONFILTER = BrtACBegin BrtIconFilter14 BrtACEnd
RICHFILTERCONTENT = BrtBeginRichFilterColumn (RICHFILTERS / BrtDynamicRichFilter / CUSTOMRICHFILTERS / BrtTop10RichFilter / *FRT) BrtEndRichFilterColumn
RICHFILTERS = BrtBeginRichFilters *BrtRichFilter *BrtRichFilterDateGroupItem *FRT BrtEndRichFilters
CUSTOMRICHFILTERS = BrtBeginCustomRichFilters 1*2BrtCustomRichFilter *FRT BrtEndCustomRichFilters
SORTSTATE = BrtBeginSortState (SORTCONDS / ACSORTCONDS / RICHSORTCONDITION) *FRT BrtEndSortState
SORTCOND = BrtBeginSortCond BrtEndSortCond
ACSORTCONDS = BrtACBegin *64SORTCOND14 BrtACEnd
SORTCOND14 = BrtBeginSortCond14 BrtEndSortCond14
RICHSORTCONDITION = BrtBeginRichSortCondition BrtEndRichSortCondition
DCON = BrtBeginDCon [DREFS] BrtEndDCon
DREFS = BrtBeginDRefs *BrtDRef BrtEndDRefs
USERSHVIEWS = BrtBeginUserShViews 1*USERSHVIEW BrtEndUserShViews
USERSHVIEW = BrtBeginUserShView [BrtPane] [BrtSel] [RWBRK] [COLBRK] [BrtMargins] [BrtPrintOptions] [BrtPageSetup] [HEADERFOOTER] [AUTOFILTER] *FRT BrtEndUserShView
HEADERFOOTER = BrtBeginHeaderFooter BrtEndHeaderFooter
CONDITIONALFORMATTING = BrtBeginConditionalFormatting 1*65534CFRULE *FRT BrtEndConditionalFormatting
CFRULE = BrtBeginCFRule [COLORSCALE / DATABAR / ICONSET] FRTCFRULE BrtEndCFRule
FRTCFRULE = [BrtFRTBegin BrtCFRuleExt BrtFRTEnd] *FRT
COLORSCALE = BrtBeginColorScale ((2CFVO 2BrtColor) / (3CFVO 3BrtColor)) BrtEndColorScale
DATABAR = BrtBeginDatabar 2CFVO BrtColor BrtEndDatabar
ICONSET = BrtBeginIconSet 3*5CFVO BrtEndIconSet
CFRULE14 = BrtBeginCFRule14 [COLORSCALE14 / DATABAR14 / ICONSET14] *FRT BrtEndCFRule14
CONDITIONALFORMATTING14 = BrtBeginConditionalFormatting14 1*65534CFRULE14 *FRT BrtEndConditionalFormatting14
COLORSCALE14 = BrtBeginColorScale14 ((2CFVO14 2BrtColor14) / (3CFVO14 3BrtColor14)) BrtEndColorScale14
DATABAR14 = BrtBeginDatabar14 2CFVO14 *5BrtColor14 BrtEndDatabar14
ICONSET14 = BrtBeginIconSet14 3*5CFVO14 [3*5BrtCFIcon] BrtEndIconSet14
RWBRK = BrtBeginRwBrk *BrtBrk BrtEndRwBrk
COLBRK = BrtBeginColBrk *BrtBrk BrtEndColBrk
OLEOBJECTS = BrtBeginOleObjects 1*BrtOleObject BrtEndOleObjects
WEBPUBITEMS = BrtBeginWebPubItems 1*WEBPUBITEM BrtEndWebPubItems
WEBPUBITEM = BrtBeginWebPubItem BrtEndWebPubItem
PIVOTRULE = BrtBeginPRule [PRFILTERS] *FRT BrtEndPRule
PRFILTERS = BrtBeginPRFilters 1*PRFILTER BrtEndPRFilters
PRFILTER = BrtBeginPRFilter *PRFITEM BrtEndPRFilter
PRFITEM = BrtBeginPRFItem BrtEndPRFItem
PCDCALCMEMSEXT = BrtBeginPCDCalcMemsExt 1*2147483647PCDCALCMEMEXT BrtEndPCDCalcMemsExt
PCDCALCMEM14 = BrtBeginPCDCalcMem14 [SXTUPLESET] BrtEndPCDCalcMem14
PCDCALCMEMEXT = BrtBeginPCDCalcMemExt [BrtFRTBegin PCDCALCMEM14 BrtFRTEnd] [PCDCALCMEM15] *FRT BrtEndPCDCalcMemExt
SXTUPLESET = BrtBeginSXTupleSet SXTUPLESETHEADER SXTUPLESETDATA BrtEndSXTupleSet
SXTUPLESETHEADER = BrtBeginSXTupleSetHeader 1*3000BrtSXTupleSetHeaderItem BrtEndSXTupleSetHeader
SXTUPLESETDATA = BrtBeginSXTupleSetData 1*3000SXTUPLESETROW BrtEndSXTupleSetData
SXTUPLESETROW = BrtBeginSXTupleSetRow 1*3000BrtSXTupleSetRowItem BrtEndSXTupleSetRow
PCDCALCMEM15 = BrtFRTBegin BrtPCDCalcMem15 BrtFRTEnd
ACUID = BrtACBegin BrtUid BrtACEnd