Browsable SpreadsheetML Worksheet Options Grammar

Grammar extracted by Vadim Zaytsev, see the Grammar Zoo entry for details: doc/office/spreadsheetml/worksheet/extracted
Source used for this grammar: Hugo Brunelière, SpreadsheetMLWorksheetOpt 1.2, MSOfficeExcel_SpreadsheetMLWorksheetOpt.ecore, 2005/07/01

Summary

• Total 41 production rules with 52 top alternatives and 542 symbols.
• Vocabulary: 233 = 35 nonterminals + 2 terminals + 196 labels + 0 markers.
• Total 35 nonterminal symbols: 34 defined (DateTimeType, VersionType, ValueType, StringValue, NumberValue, DateTimeTypeValue, BooleanValue, ErrorValue, DocumentPropertiesCollection, CustomDocumentPropertiesCollection, CustomDocumentProperty, SmartTagType, SmartTagsCollection, Workbook, Worksheet, StyledElement, Table, TableElement, ColOrRowElement, Column, Row, Cell, Comment, Data, ExcelWorkbook, DisplayDrawingObjectsType, CalculationWorkbookType, WorksheetOptionsElt, ExcelWorksheetTypeType, VisibleType, EnableSelectionType, Integer, String, Boolean), 0 root (—), 1 top (StyledElement), 1 bottom (Double ¹²).
• Total 2 terminal symbols: 2 keywords ("true", "false"), 0 letters (—), 0 numerics (—), 0 signs (—).
• Total 196 labels: [year], [month], [day], [hour], [minute], [second], [n], [nn], [value] ⁶, [vt_data], [dp_workbook], [title], [subject], [keywords], [description], [category], [author] ², [lastAuthor], [manager], [company], [hyperlinkBase], [revision], [presentationFormat], [guid], [appName], [version], [totalTime], [lastPrinted], [created], [lastSaved], [pages], [words], [characters], [charactersWithSpaces], [bytes], [lines], [paragraphs], [cdp_workbook], [customDocumentProperties], [customDocumentProperty_cdpe], [name] ⁴, [smartTagType_ste], [namespaceuri], [url], [st_workbook], [st_cell], [smartTagTypes], [wb_smartTags], [wb_docProperties], [wb_customDocProperties], [wb_excelWorkbook], [wb_worksheets], [ws_workbook], [ws_table], [protected], [rightToLeft], [w_worksheetOptions], [t_worksheet], [t_cols], [t_rows], [defaultColumnWidth] ², [defaultRowHeight] ², [expandedColumnCount], [expandedRowCount], [leftCell], [topCell], [fullColumns], [fullRows], [c_table], [autoFitWidth], [width], [r_table], [r_cells], [autoFitHeight], [height], [c_smartTags], [c_row], [arrayRange], [formula], [hRef], [mergeAcross], [mergeDown], [c_data], [c_comment], [c_cell], [com_data], [showAlways], [d_cell], [d_comment], [ew_workbook], [selectedSheets], [windowHidden], [hideHorizontalScrollBar], [hideVerticalScrollBar], [hideWorkbookTabs], [windowHeight], [windowWidth], [windowTopX], [windowTopY], [activeSheet], [activeChart], [firstVisibleSheet], [hidePivotTableFieldList], [protectStructure], [protectWindows], [displayInkNotes], [embedSaveSmartTags], [futureVer], [tabRatio], [windowIconic], [displayDrawingObjects], [createBackup], [calculation], [doNotCalculateBeforeSave], [date1904], [refModeR1C1], [iteration], [maxIterations], [maxChange], [precisionAsDisplayed], [doNotSaveLinkValues], [noAutoRecover], [acceptLabelsInFormulas], [uncalced], [ddot_displayShapes], [ddot_placeHolders], [ddot_hideAll], [cwt_automaticCalculation], [cwt_manualCalculation], [cwt_semiAutomaticCalculation], [wo_worksheet], [fitToPage], [doNotDisplayColHeaders], [doNotDisplayRowHeaders], [gridlineColor], [excelWorksheetType], [intlMacro], [unsynced], [selected], [codeName], [displayPageBreak], [transitionExpressionEvaluation], [transitionFormulaEntry], [zoom], [pageBreakZoom], [showPageBreakZoom], [standardWidth], [visible], [leftColumnVisible], [displayRightToLeft], [gridlineColorIndex], [displayFormulas], [doNotDisplayGridlines], [doNotDisplayHeadings], [doNotDisplayOutline], [applyAutomaticOutlineStyles], [noSummaryRowsBelowDetail], [noSummaryColumnsRightDetail], [doNotDisplayZeros], [activeRow], [activeColumn], [filterOn], [rangeSelection], [topRowVisible], [topRowBottomPane], [leftColumnRightPane], [activePane], [splitHorizontal], [splitVertical], [freezePanes], [frozenNoSplit], [tabColorIndex], [protectContentst], [protectObjects], [protectScenarios], [enableSelection], [allowFormatCells], [allowSizeCols], [allowSizeRows], [allowInsertCols], [allowInsertRows], [allowInsertHyperlinks], [allowDeleteCols], [allowDeleteRows], [allowSort], [allowFilter], [allowUsePivotTables], [ewt_Worksheet], [ewt_Chart], [ewt_Macro], [ewt_Dialog], [vt_SheetVisible], [vt_SheetHidden], [vt_SheetVeryHidden], [est_UnlockedCells], [est_NoSelection].

Syntax

DateTimeType ::=
	[year]::Integer [month]::Integer [day]::Integer [hour]::Integer [minute]::Integer [second]::Integer

VersionType ::=
	[n]::Integer [nn]::Integer

ValueType ::=
	StringValue

ValueType ::=
	NumberValue

ValueType ::=
	DateTimeTypeValue

ValueType ::=
	BooleanValue

ValueType ::=
	ErrorValue

StringValue ::=
	[value]::String

NumberValue ::=
	[value]::Double

DateTimeTypeValue ::=
	[value]::DateTimeType

BooleanValue ::=
	[value]::Boolean

ErrorValue ::=
	[vt_data]::Data

DocumentPropertiesCollection ::=
	[dp_workbook]::Workbook [title]::String [subject]::String [keywords]::String [description]::String [category]::String [author]::String [lastAuthor]::String [manager]::String [company]::String [hyperlinkBase]::String [revision]::Integer [presentationFormat]::String [guid]::String [appName]::String [version]::VersionType [totalTime]::Integer [lastPrinted]::DateTimeType [created]::DateTimeType [lastSaved]::DateTimeType [pages]::Integer [words]::Integer [characters]::Integer [charactersWithSpaces]::Integer [bytes]::Integer [lines]::Integer [paragraphs]::Integer

CustomDocumentPropertiesCollection ::=
	[cdp_workbook]::Workbook [customDocumentProperties]::CustomDocumentProperty+

CustomDocumentProperty ::=
	[customDocumentProperty_cdpe]::CustomDocumentPropertiesCollection [name]::String [value]::ValueType

SmartTagType ::=
	[smartTagType_ste]::SmartTagsCollection [namespaceuri]::String [name]::String [url]::String

SmartTagsCollection ::=
	[st_workbook]::Workbook [st_cell]::Cell [smartTagTypes]::SmartTagType+

Workbook ::=
	[wb_smartTags]::SmartTagsCollection [wb_docProperties]::DocumentPropertiesCollection [wb_customDocProperties]::CustomDocumentPropertiesCollection [wb_excelWorkbook]::ExcelWorkbook [wb_worksheets]::Worksheet+

Worksheet ::=
	[ws_workbook]::Workbook [ws_table]::Table [name]::String [protected]::Boolean [rightToLeft]::Boolean [w_worksheetOptions]::WorksheetOptionsElt

StyledElement ::=
	Table

StyledElement ::=
	TableElement

Table ::=
	[t_worksheet]::Worksheet [t_cols]::Column+ [t_rows]::Row+ [defaultColumnWidth]::Double [defaultRowHeight]::Double [expandedColumnCount]::Integer [expandedRowCount]::Integer [leftCell]::Integer [topCell]::Integer [fullColumns]::Boolean [fullRows]::Boolean

TableElement ::=
	ColOrRowElement

TableElement ::=
	Cell

ColOrRowElement ::=
	Column

ColOrRowElement ::=
	Row

Column ::=
	[c_table]::Table [autoFitWidth]::Boolean [width]::Double

Row ::=
	[r_table]::Table [r_cells]::Cell+ [autoFitHeight]::Boolean [height]::Double

Cell ::=
	[c_smartTags]::SmartTagsCollection+ [c_row]::Row [arrayRange]::String [formula]::String [hRef]::String [mergeAcross]::Double [mergeDown]::Double [c_data]::Data [c_comment]::Comment

Comment ::=
	[c_cell]::Cell [com_data]::Data [author]::String [showAlways]::Boolean

Data ::=
	[d_cell]::Cell [d_comment]::Comment [value]::ValueType

ExcelWorkbook ::=
	[ew_workbook]::Workbook [selectedSheets]::Integer [windowHidden]::Boolean [hideHorizontalScrollBar]::Boolean [hideVerticalScrollBar]::Boolean [hideWorkbookTabs]::Boolean [windowHeight]::Double [windowWidth]::Double [windowTopX]::Double [windowTopY]::Double [activeSheet]::Integer [activeChart]::String [firstVisibleSheet]::Integer [hidePivotTableFieldList]::Boolean [protectStructure]::Boolean [protectWindows]::Boolean [displayInkNotes]::Boolean [embedSaveSmartTags]::Boolean [futureVer]::String [tabRatio]::Integer [windowIconic]::Boolean [displayDrawingObjects]::DisplayDrawingObjectsType [createBackup]::Boolean [calculation]::CalculationWorkbookType [doNotCalculateBeforeSave]::Boolean [date1904]::Boolean [refModeR1C1]::Boolean [iteration]::Boolean [maxIterations]::Integer [maxChange]::Double [precisionAsDisplayed]::Boolean [doNotSaveLinkValues]::Boolean [noAutoRecover]::Boolean [acceptLabelsInFormulas]::Boolean [uncalced]::Boolean

DisplayDrawingObjectsType ::=
	[ddot_displayShapes]::ε
	[ddot_placeHolders]::ε
	[ddot_hideAll]::ε

CalculationWorkbookType ::=
	[cwt_automaticCalculation]::ε
	[cwt_manualCalculation]::ε
	[cwt_semiAutomaticCalculation]::ε

WorksheetOptionsElt ::=
	[wo_worksheet]::Worksheet [fitToPage]::Boolean [doNotDisplayColHeaders]::Boolean [doNotDisplayRowHeaders]::Boolean [gridlineColor]::String [name]::String [excelWorksheetType]::ExcelWorksheetTypeType [intlMacro]::Boolean [unsynced]::Boolean [selected]::Boolean [codeName]::String [displayPageBreak]::Boolean [transitionExpressionEvaluation]::Boolean [transitionFormulaEntry]::Boolean [zoom]::Integer [pageBreakZoom]::Integer [showPageBreakZoom]::Boolean [defaultRowHeight]::Integer [defaultColumnWidth]::Integer [standardWidth]::Integer [visible]::VisibleType [leftColumnVisible]::Integer [displayRightToLeft]::Boolean [gridlineColorIndex]::Integer [displayFormulas]::Boolean [doNotDisplayGridlines]::Boolean [doNotDisplayHeadings]::Boolean [doNotDisplayOutline]::Boolean [applyAutomaticOutlineStyles]::Boolean [noSummaryRowsBelowDetail]::Boolean [noSummaryColumnsRightDetail]::Boolean [doNotDisplayZeros]::Boolean [activeRow]::Integer [activeColumn]::Integer [filterOn]::Boolean [rangeSelection]::String [topRowVisible]::Integer [topRowBottomPane]::Integer [leftColumnRightPane]::Integer [activePane]::Integer [splitHorizontal]::Integer [splitVertical]::Integer [freezePanes]::Boolean [frozenNoSplit]::Boolean [tabColorIndex]::Integer [protectContentst]::Boolean [protectObjects]::Boolean [protectScenarios]::Boolean [enableSelection]::EnableSelectionType [allowFormatCells]::Boolean [allowSizeCols]::Boolean [allowSizeRows]::Boolean [allowInsertCols]::Boolean [allowInsertRows]::Boolean [allowInsertHyperlinks]::Boolean [allowDeleteCols]::Boolean [allowDeleteRows]::Boolean [allowSort]::Boolean [allowFilter]::Boolean [allowUsePivotTables]::Boolean

ExcelWorksheetTypeType ::=
	[ewt_Worksheet]::ε
	[ewt_Chart]::ε
	[ewt_Macro]::ε
	[ewt_Dialog]::ε

VisibleType ::=
	[vt_SheetVisible]::ε
	[vt_SheetHidden]::ε
	[vt_SheetVeryHidden]::ε

EnableSelectionType ::=
	[est_UnlockedCells]::ε
	[est_NoSelection]::ε

Integer ::=
	integer

String ::=
	string

Boolean ::=
	"true"
	"false"

Maintained by Dr. Vadim Zaytsev a.k.a. @grammarware. Last updated in September 2015. [↑]