Browsable SpreadsheetML Styles Grammar

CC-BY

Grammar extracted by Vadim Zaytsev, see the Grammar Zoo entry for details: doc/office/spreadsheetml/styles/extracted
Source used for this grammar: Hugo Brunelière, SpreadsheetMLStyles 1.2, MSOfficeExcel_SpreadsheetMLStyles.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_styles]::StylesCollection [wb_names]::NamesType [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 [wo_pageSetup]::PageSetup [wo_print]::Print
ExcelWorksheetTypeType ::=
	[ewt_Worksheet]::ε
	[ewt_Chart]::ε
	[ewt_Macro]::ε
	[ewt_Dialog]::ε
VisibleType ::=
	[vt_SheetVisible]::ε
	[vt_SheetHidden]::ε
	[vt_SheetVeryHidden]::ε
EnableSelectionType ::=
	[est_UnlockedCells]::ε
	[est_NoSelection]::ε
PageSetup ::=
	[ps_worksheetOptions]::WorksheetOptionsElt [ps_layout]::Layout [ps_header]::Header [ps_footer]::Footer [ps_pageMargins]::PageMarginsInfo
Layout ::=
	[l_pageSetup]::PageSetup [orientation]::OrientationType [centerHorizontal]::Boolean [centerVertical]::Boolean [startPageNumber]::String
OrientationType ::=
	[ot_Landscape]::ε
	[ot_Portrait]::ε
HeaderOrFooterElt ::=
	Header
HeaderOrFooterElt ::=
	Footer
Header ::=
	[h_pageSetup]::PageSetup
Footer ::=
	[f_pageSetup]::PageSetup
PageMarginsInfo ::=
	[pm_pageSetup]::PageSetup [left]::Double [right]::Double [top]::Double [bottom]::Double
Print ::=
	[p_worksheetOptions]::WorksheetOptionsElt [fitWidth]::Integer [fitHeight]::Integer [leftToRight]::Boolean [blackAndWhite]::Boolean [draftQuality]::Boolean [commentsLayout]::CommentsLayoutType [scale]::Integer [printErrors]::String [validPrinterInfo]::Boolean [paperSizeIndex]::Integer [horizontalResolution]::Integer [verticalResolution]::Integer [gridlines]::Boolean [numberOfCopies]::Integer [rowColHeadings]::Boolean
CommentsLayoutType ::=
	[clt_InPlace]::ε
	[clt_PrintNone]::ε
	[clt_SheetEnd]::ε
StylesCollection ::=
	[s_workbook]::Workbook [style]::StyleType+
StyleType ::=
	[st_styles]::StylesCollection [st_styledElement]::StyledElement [id]::String [name]::String [parent]::StyleType [st_parent]::StyleType [alignment]::AlignmentType [borders]::BordersType [font]::FontType [interior]::InteriorType [numberFormat]::NumberFormatType [protection]::ProtectionType
ProtectionType ::=
	[pt_styleType]::StyleType [protected]::Boolean
AlignmentType ::=
	[at_styleType]::StyleType [horizontal]::HorizontalAlignementType [readingOrder]::ReadingOrderType [indent]::Double [rotate]::Double [shrinkToFit]::Boolean [vertical]::VerticalAlignementType [verticalText]::Boolean [wrapText]::Boolean
HorizontalAlignementType ::=
	[hat_CenterAcrossSelection]::ε
	[hat_Fill]::ε
	[hat_Left]::ε
	[hat_Right]::ε
	[hat_Justify]::ε
	[hat_Distributed]::ε
	[hat_Center]::ε
	[hat_Automatic]::ε
	[hat_JustifyDistributed]::ε
ReadingOrderType ::=
	[rot_RightToLeft]::ε
	[rot_LeftToRight]::ε
	[rot_Context]::ε
VerticalAlignementType ::=
	[vat_Top]::ε
	[vat_Bottom]::ε
	[vat_Justify]::ε
	[vat_Distributed]::ε
	[vat_Center]::ε
	[vat_Automatic]::ε
	[vat_JustifyDistributed]::ε
BordersType ::=
	[bt_styleType]::StyleType [border]::BorderType
BorderType ::=
	[bt_bordersType]::BordersType [position]::PositionType [color]::String [lineStyle]::LineStyleType [weight]::Double
PositionType ::=
	[pt_Left]::ε
	[pt_Top]::ε
	[pt_Right]::ε
	[pt_Bottom]::ε
	[pt_DiagonalLeft]::ε
	[pt_DiagonalRight]::ε
LineStyleType ::=
	[lst_None]::ε
	[lst_Continuous]::ε
	[lst_Dash]::ε
	[lst_Dot]::ε
	[lst_DashDot]::ε
	[lst_DashDotDot]::ε
	[lst_SlantDashDot]::ε
	[lst_Double]::ε
FontType ::=
	[ft_styleType]::StyleType [bold]::Boolean [color]::String [fontName]::String [italic]::Boolean [outline]::Boolean [shadow]::Boolean [size]::Double [strikeThrough]::Boolean [underline]::UnderlineType [verticalAlign]::VerticalAlignType
UnderlineType ::=
	[ut_None]::ε
	[ut_Single]::ε
	[ut_Double]::ε
	[ut_SingleAccounting]::ε
	[ut_DoubleAccounting]::ε
VerticalAlignType ::=
	[vat_None]::ε
	[vat_Subscript]::ε
	[vat_Superscript]::ε
InteriorType ::=
	[it_styleType]::StyleType [color]::String [pattern]::PatternType [patternColor]::String
PatternType ::=
	[pt_None]::ε
	[pt_Solid]::ε
	[pt_Gray75]::ε
	[pt_Gray50]::ε
	[pt_Gray25]::ε
	[pt_Gray125]::ε
	[pt_Gray0625]::ε
	[pt_HorzStripe]::ε
	[pt_VertStripe]::ε
	[pt_ReverseDiagStripe]::ε
	[pt_DiagStripe]::ε
	[pt_DiagCross]::ε
	[pt_ThickDiagCross]::ε
	[pt_ThinHorzStripe]::ε
	[pt_ThinVertStripe]::ε
	[pt_ThinReverseDiagStripe]::ε
	[pt_ThinDiagStripe]::ε
	[pt_ThinHorzCross]::ε
	[pt_ThinDiagCross]::ε
NumberFormatType ::=
	[nft_styleType]::StyleType [format]::ExcelNumberFormatType
ExcelNumberFormatType ::=
	[enft_General]::ε
	[enft_General_Number]::ε
	[enft_General_Date]::ε
	[enft_Long_Date]::ε
	[enft_Medium_Date]::ε
	[enft_Short_Date]::ε
	[enft_Long_Time]::ε
	[enft_Medium_Time]::ε
	[enft_Short_Time]::ε
	[enft_Currency]::ε
	[enft_Euro_Currency]::ε
	[enft_Fixed]::ε
	[enft_Standard]::ε
	[enft_Percent]::ε
	[enft_Scientific]::ε
	[enft_Yes_No]::ε
	[enft_True_False]::ε
	[enft_On_Off]::ε
NamesType ::=
	[nt_workbook]::Workbook [namedRanges]::NamedRange+
NamedRange ::=
	[nr_namesType]::NamesType [name]::String [refersTo]::String [hidden]::Boolean
Integer ::=
	integer
String ::=
	string
Boolean ::=
	"true"
	"false"
GrammarLabMaintained by Dr. Vadim Zaytsev a.k.a. @grammarware. Last updated in September 2015. [↑]