Browsable SpreadsheetML Basic Definition Grammar

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

Summary

• Total 34 production rules with 35 top alternatives and 293 symbols.
• Vocabulary: 115 = 28 nonterminals + 2 terminals + 85 labels + 0 markers.
• Total 28 nonterminal symbols: 27 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, 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 85 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_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_row], [c_smartTags], [arrayRange], [formula], [hRef], [mergeAcross], [mergeDown], [c_data], [c_comment], [c_cell], [com_data], [showAlways], [d_cell], [d_comment].

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_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_row]::Row [c_smartTags]::SmartTagsCollection+ [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

Integer ::=
	integer

String ::=
	string

Boolean ::=
	"true"
	"false"

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