Browsable SpreadsheetML Workbook Properties Grammar

Grammar extracted by Vadim Zaytsev, see the Grammar Zoo entry for details: doc/office/spreadsheetml/workbook/extracted
Source used for this grammar: Hugo Brunelière, SpreadsheetMLWorkbookProp 1.1, MSOfficeExcel_SpreadsheetMLWorkbookProp.ecore, 2005/06/29

Summary

• Total 37 production rules with 42 top alternatives and 386 symbols.
• Vocabulary: 160 = 31 nonterminals + 2 terminals + 127 labels + 0 markers.
• Total 31 nonterminal symbols: 30 defined (Integer, String, Boolean, 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), 0 root (—), 1 top (StyledElement), 1 bottom (Double ¹²).
• Total 2 terminal symbols: 2 keywords ("true", "false"), 0 letters (—), 0 numerics (—), 0 signs (—).
• Total 127 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], [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].

Syntax

Integer ::=
	integer

String ::=
	string

Boolean ::=
	"true"
	"false"

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

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]::ε

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