Browsable SpreadsheetML Worksheet Options Grammar

CC-BY

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

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"

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