com.hfg.xml.msofficexml.xlsx.spreadsheetml

Class SsmlSheetView

java.lang.Object

com.hfg.xml.XMLContainerImpl

com.hfg.xml.XMLTag

com.hfg.xml.msofficexml.OfficeOpenXMLTag

com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlXMLTag

com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlSheetView

All Implemented Interfaces:

XMLContainer, XMLizable, XMLNode, Cloneable, Comparable

public class SsmlSheetView
extends SsmlXMLTag

Represents an Office Open XML sheet view (<ssml:sheetView>) tag.

Nested Class Summary

Nested classes/interfaces inherited from class com.hfg.xml.XMLContainerImpl

XMLContainerImpl.sMode

Field Summary

Fields inherited from class com.hfg.xml.msofficexml.OfficeOpenXMLTag

sSQLLoggingLevel

Fields inherited from class com.hfg.xml.XMLContainerImpl

mContentAndSubtagList

Constructor Summary

Constructors

Constructor and Description
SsmlSheetView(Xlsx inXlsx)

Method Summary

Modifier and Type	Method and Description
SsmlPane	getPane()
SsmlSheetView	setColor(Color inValue) Specifies the color value for row/column text headings and gridlines.
SsmlSheetView	setNormalViewZoomScale(Integer inValue) Specifies the zoom magnification when in normal view, representing percent values.
SsmlSheetView	setPageLayoutViewZoomScale(Integer inValue) Specifies the zoom magnification when in page layout view, representing percent values.
SsmlSheetView	setRightToLeft(boolean inValue) Specifies whether the sheet is in 'right to left' display mode.
SsmlSheetView	setSelection(CellRef inValue)
SsmlSheetView	setSheetLayoutViewZoomScale(Integer inValue) Specifies the zoom magnification when in page break preview, representing percent values.
SsmlSheetView	setShowFormulas(boolean inValue) Specifies whether or not to display formulas.
SsmlSheetView	setShowGridLines(boolean inValue) Specifies whether or not to display grid lines.
SsmlSheetView	setShowOutlineSymbols(boolean inValue) Specifies whether or not the sheet has outline symbols visible.
SsmlSheetView	setShowRowColHeaders(boolean inValue) Specifies whether or not to display row and column headers.
SsmlSheetView	setShowWhiteSpace(boolean inValue) Specifies whether or not page layout view shall display margins.
SsmlSheetView	setShowZeros(boolean inValue) Specifies whether or not to display zero values.
SsmlSheetView	setTabSelected(boolean inValue) Specifies whether or not the sheet tab is selected.
SsmlSheetView	setTopLeftCell(CellRef inValue) Specifies the location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).
SsmlSheetView	setUseDefaultGridColor(boolean inValue) Specifies whether or not the consuming application should use the default grid lines color (system dependent).
SsmlSheetView	setViewType(SsmlSheetViewType inValue) Specifies the view type.
SsmlSheetView	setWindowProtection(boolean inValue) Specifies whether or not to enable window protection.
SsmlSheetView	setWorkbookViewId(Integer inValue)
SsmlSheetView	setZoomScale(Integer inValue) Specifies the window zoom magnification for current view representing percent values.
SsmlSheetView	showRuler(boolean inValue) Specifies whether or not the ruler is displayed in Page Layout View.

Methods inherited from class com.hfg.xml.msofficexml.xlsx.spreadsheetml.SsmlXMLTag

getParentDoc, setAttribute

Methods inherited from class com.hfg.xml.msofficexml.OfficeOpenXMLTag

colorToCT_Color, generateUID, getLogger, orderSubtags, setParentDoc, toIndentedXML, toXML

Methods inherited from class com.hfg.xml.XMLTag

addSubtag, addSubtag, addXMLNamespaceDeclaration, clone, compareTo, equals, findNodesByAttributeValue, findNodesByAttributeValue, getAttribute, getAttribute, getAttributes, getAttributeValue, getAttributeValue, getEndTag, getNamespace, getQualifiedTagName, getStartTag, getTagName, hasAttribute, hasAttribute, hasAttributes, isEmptyTag, removeAttribute, removeAttribute, replaceCharacterEntities, setAttribute, setAttribute, setAttributes, setContent, setDefaultXMLNamespaceDeclaration, setNamespace, setSortAttributesBeforeWriting, setTagName, setTagName, sortAttributes, toIndentedXML, toIndentedXML, toIndentedXML, toString, toXML, toXML, toXML, useDoubleQuotes, verifyTagName, verifyTagName, verifyTagName, verifyTagName

Methods inherited from class com.hfg.xml.XMLContainerImpl

addContent, addContentWithoutEscaping, addSubtag, addSubtag, addSubtags, clearContent, clearSubtags, getContent, getContentPlusSubtagList, getNextSibling, getOptionalSubtagByName, getOptionalSubtagByName, getOptionalSubtagByName, getOptionalSubtagByName, getParentNode, getPreviousSibling, getRequiredSubtagById, getRequiredSubtagById, getRequiredSubtagByName, getRequiredSubtagByName, getSubtagByAttribute, getSubtagByAttribute, getSubtags, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByAttribute, getSubtagsByClass, getSubtagsByClass, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getTotalTagCount, getUnescapedContent, getXMLNodeSubtags, hasContent, hasContentOrSubtags, indexOf, innerHTML, removeSubtag, removeSubtagsByAttribute, removeSubtagsByAttribute, removeSubtagsByAttribute, removeSubtagsByClass, removeSubtagsByClass, removeSubtagsByName, removeSubtagsByName, removeSubtagsByName, setContent, setParentNode, setSubtags

Methods inherited from class java.lang.Object

finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface com.hfg.xml.XMLContainer

addContent, addContentWithoutEscaping, addSubtag, addSubtags, clearContent, clearSubtags, getContent, getNextSibling, getOptionalSubtagByName, getOptionalSubtagByName, getParentNode, getPreviousSibling, getRequiredSubtagByName, getRequiredSubtagByName, getSubtags, getSubtagsByName, getSubtagsByName, getSubtagsByName, getSubtagsByName, getTotalTagCount, getUnescapedContent, getXMLNodeSubtags, hasContent, indexOf, removeSubtag, removeSubtagsByName, removeSubtagsByName, setParentNode, setSubtags

Constructor Detail

SsmlSheetView

public SsmlSheetView(Xlsx inXlsx)

Method Detail

setViewType

public SsmlSheetView setViewType(SsmlSheetViewType inValue)

Specifies the view type. Default value is "normal".

setTopLeftCell

public SsmlSheetView setTopLeftCell(CellRef inValue)

Specifies the location of the top left visible cell in the bottom right pane (when in Left-to-Right mode).

setRightToLeft

public SsmlSheetView setRightToLeft(boolean inValue)

Specifies whether the sheet is in 'right to left' display mode. When in this mode, Column A is on the far right, Column B ;is one column left of Column A, and so on. Also, information in cells is displayed in the Right to Left format. Default value is "false".

setTabSelected

public SsmlSheetView setTabSelected(boolean inValue)

Specifies whether or not the sheet tab is selected. Default value is "false".

showRuler

public SsmlSheetView showRuler(boolean inValue)

Specifies whether or not the ruler is displayed in Page Layout View. Default value is "true".

setShowZeros

public SsmlSheetView setShowZeros(boolean inValue)

Specifies whether or not to display zero values. Default value is "true".

setShowFormulas

public SsmlSheetView setShowFormulas(boolean inValue)

Specifies whether or not to display formulas. Default value is "false".

setShowGridLines

public SsmlSheetView setShowGridLines(boolean inValue)

Specifies whether or not to display grid lines. Default value is "true".

setShowWhiteSpace

public SsmlSheetView setShowWhiteSpace(boolean inValue)

Specifies whether or not page layout view shall display margins. False means do not display left, right, top (header), and bottom (footer) margins (even when there is data in the header or footer). Default value is "true".

setShowOutlineSymbols

public SsmlSheetView setShowOutlineSymbols(boolean inValue)

Specifies whether or not the sheet has outline symbols visible. This flag shall always override SheetPr element's outlinePr child element whose attribute is named showOutlineSymbols when there is a conflict. Default value is "true".

setUseDefaultGridColor

public SsmlSheetView setUseDefaultGridColor(boolean inValue)

Specifies whether or not the consuming application should use the default grid lines color (system dependent). Overrides any color specified in colorId. Default value is "true".

setShowRowColHeaders

public SsmlSheetView setShowRowColHeaders(boolean inValue)

Specifies whether or not to display row and column headers. Default value is "true".

setWindowProtection

public SsmlSheetView setWindowProtection(boolean inValue)

Specifies whether or not to enable window protection. Default value is "false".

setColor

public SsmlSheetView setColor(Color inValue)

Specifies the color value for row/column text headings and gridlines. The color specified will be mapped to the closest Excel indexed color value.

setZoomScale

public SsmlSheetView setZoomScale(Integer inValue)

Specifies the window zoom magnification for current view representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Default value is 100.

setNormalViewZoomScale

public SsmlSheetView setNormalViewZoomScale(Integer inValue)

Specifies the zoom magnification when in normal view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Default value is 0.

setPageLayoutViewZoomScale

public SsmlSheetView setPageLayoutViewZoomScale(Integer inValue)

Specifies the zoom magnification when in page layout view, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Default value is 0.

setSheetLayoutViewZoomScale

public SsmlSheetView setSheetLayoutViewZoomScale(Integer inValue)

Specifies the zoom magnification when in page break preview, representing percent values. This attribute is restricted to values ranging from 10 to 400. Horizontal & Vertical scale together. Default value is 0.

setWorkbookViewId

public SsmlSheetView setWorkbookViewId(Integer inValue)

setSelection

public SsmlSheetView setSelection(CellRef inValue)

getPane

public SsmlPane getPane()