Interface CTSheetView
- All Superinterfaces:
XmlObject
,XmlTokenSource
An XML CT_SheetView(@http://schemas.openxmlformats.org/spreadsheetml/2006/main).
This is a complex type.
-
Field Summary
FieldsModifier and TypeFieldDescriptionstatic final DocumentFactory
<CTSheetView> static final SchemaType
Fields inherited from interface org.apache.xmlbeans.XmlObject
EQUAL, GREATER_THAN, LESS_THAN, NOT_EQUAL
-
Method Summary
Modifier and TypeMethodDescriptionAppends and returns a new empty "extLst" elementAppends and returns a new empty "pane" elementAppends and returns a new empty value (as xml) as the last "pivotSelection" elementAppends and returns a new empty value (as xml) as the last "selection" elementlong
Gets the "colorId" attributeboolean
Gets the "defaultGridColor" attributeGets the "extLst" elementgetPane()
Gets the "pane" elementGets array of all "pivotSelection" elementsgetPivotSelectionArray
(int i) Gets ith "pivotSelection" elementGets a List of "pivotSelection" elementsboolean
Gets the "rightToLeft" attributeGets array of all "selection" elementsgetSelectionArray
(int i) Gets ith "selection" elementGets a List of "selection" elementsboolean
Gets the "showFormulas" attributeboolean
Gets the "showGridLines" attributeboolean
Gets the "showOutlineSymbols" attributeboolean
Gets the "showRowColHeaders" attributeboolean
Gets the "showRuler" attributeboolean
Gets the "showWhiteSpace" attributeboolean
Gets the "showZeros" attributeboolean
Gets the "tabSelected" attributeGets the "topLeftCell" attributegetView()
Gets the "view" attributeboolean
Gets the "windowProtection" attributelong
Gets the "workbookViewId" attributelong
Gets the "zoomScale" attributelong
Gets the "zoomScaleNormal" attributelong
Gets the "zoomScalePageLayoutView" attributelong
Gets the "zoomScaleSheetLayoutView" attributeinsertNewPivotSelection
(int i) Inserts and returns a new empty value (as xml) as the ith "pivotSelection" elementinsertNewSelection
(int i) Inserts and returns a new empty value (as xml) as the ith "selection" elementboolean
True if has "colorId" attributeboolean
True if has "defaultGridColor" attributeboolean
True if has "extLst" elementboolean
True if has "pane" elementboolean
True if has "rightToLeft" attributeboolean
True if has "showFormulas" attributeboolean
True if has "showGridLines" attributeboolean
True if has "showOutlineSymbols" attributeboolean
True if has "showRowColHeaders" attributeboolean
True if has "showRuler" attributeboolean
True if has "showWhiteSpace" attributeboolean
True if has "showZeros" attributeboolean
True if has "tabSelected" attributeboolean
True if has "topLeftCell" attributeboolean
True if has "view" attributeboolean
True if has "windowProtection" attributeboolean
True if has "zoomScale" attributeboolean
True if has "zoomScaleNormal" attributeboolean
True if has "zoomScalePageLayoutView" attributeboolean
True if has "zoomScaleSheetLayoutView" attributevoid
removePivotSelection
(int i) Removes the ith "pivotSelection" elementvoid
removeSelection
(int i) Removes the ith "selection" elementvoid
setColorId
(long colorId) Sets the "colorId" attributevoid
setDefaultGridColor
(boolean defaultGridColor) Sets the "defaultGridColor" attributevoid
setExtLst
(CTExtensionList extLst) Sets the "extLst" elementvoid
Sets the "pane" elementvoid
setPivotSelectionArray
(int i, CTPivotSelection pivotSelection) Sets ith "pivotSelection" elementvoid
setPivotSelectionArray
(CTPivotSelection[] pivotSelectionArray) Sets array of all "pivotSelection" elementvoid
setRightToLeft
(boolean rightToLeft) Sets the "rightToLeft" attributevoid
setSelectionArray
(int i, CTSelection selection) Sets ith "selection" elementvoid
setSelectionArray
(CTSelection[] selectionArray) Sets array of all "selection" elementvoid
setShowFormulas
(boolean showFormulas) Sets the "showFormulas" attributevoid
setShowGridLines
(boolean showGridLines) Sets the "showGridLines" attributevoid
setShowOutlineSymbols
(boolean showOutlineSymbols) Sets the "showOutlineSymbols" attributevoid
setShowRowColHeaders
(boolean showRowColHeaders) Sets the "showRowColHeaders" attributevoid
setShowRuler
(boolean showRuler) Sets the "showRuler" attributevoid
setShowWhiteSpace
(boolean showWhiteSpace) Sets the "showWhiteSpace" attributevoid
setShowZeros
(boolean showZeros) Sets the "showZeros" attributevoid
setTabSelected
(boolean tabSelected) Sets the "tabSelected" attributevoid
setTopLeftCell
(String topLeftCell) Sets the "topLeftCell" attributevoid
setView
(STSheetViewType.Enum view) Sets the "view" attributevoid
setWindowProtection
(boolean windowProtection) Sets the "windowProtection" attributevoid
setWorkbookViewId
(long workbookViewId) Sets the "workbookViewId" attributevoid
setZoomScale
(long zoomScale) Sets the "zoomScale" attributevoid
setZoomScaleNormal
(long zoomScaleNormal) Sets the "zoomScaleNormal" attributevoid
setZoomScalePageLayoutView
(long zoomScalePageLayoutView) Sets the "zoomScalePageLayoutView" attributevoid
setZoomScaleSheetLayoutView
(long zoomScaleSheetLayoutView) Sets the "zoomScaleSheetLayoutView" attributeint
Returns number of "pivotSelection" elementint
Returns number of "selection" elementvoid
Unsets the "colorId" attributevoid
Unsets the "defaultGridColor" attributevoid
Unsets the "extLst" elementvoid
Unsets the "pane" elementvoid
Unsets the "rightToLeft" attributevoid
Unsets the "showFormulas" attributevoid
Unsets the "showGridLines" attributevoid
Unsets the "showOutlineSymbols" attributevoid
Unsets the "showRowColHeaders" attributevoid
Unsets the "showRuler" attributevoid
Unsets the "showWhiteSpace" attributevoid
Unsets the "showZeros" attributevoid
Unsets the "tabSelected" attributevoid
Unsets the "topLeftCell" attributevoid
Unsets the "view" attributevoid
Unsets the "windowProtection" attributevoid
Unsets the "zoomScale" attributevoid
Unsets the "zoomScaleNormal" attributevoid
Unsets the "zoomScalePageLayoutView" attributevoid
Unsets the "zoomScaleSheetLayoutView" attributeGets (as xml) the "colorId" attributeGets (as xml) the "defaultGridColor" attributeGets (as xml) the "rightToLeft" attributeGets (as xml) the "showFormulas" attributeGets (as xml) the "showGridLines" attributeGets (as xml) the "showOutlineSymbols" attributeGets (as xml) the "showRowColHeaders" attributeGets (as xml) the "showRuler" attributeGets (as xml) the "showWhiteSpace" attributeGets (as xml) the "showZeros" attributeGets (as xml) the "tabSelected" attributeGets (as xml) the "topLeftCell" attributexgetView()
Gets (as xml) the "view" attributeGets (as xml) the "windowProtection" attributeGets (as xml) the "workbookViewId" attributeGets (as xml) the "zoomScale" attributeGets (as xml) the "zoomScaleNormal" attributeGets (as xml) the "zoomScalePageLayoutView" attributeGets (as xml) the "zoomScaleSheetLayoutView" attributevoid
xsetColorId
(XmlUnsignedInt colorId) Sets (as xml) the "colorId" attributevoid
xsetDefaultGridColor
(XmlBoolean defaultGridColor) Sets (as xml) the "defaultGridColor" attributevoid
xsetRightToLeft
(XmlBoolean rightToLeft) Sets (as xml) the "rightToLeft" attributevoid
xsetShowFormulas
(XmlBoolean showFormulas) Sets (as xml) the "showFormulas" attributevoid
xsetShowGridLines
(XmlBoolean showGridLines) Sets (as xml) the "showGridLines" attributevoid
xsetShowOutlineSymbols
(XmlBoolean showOutlineSymbols) Sets (as xml) the "showOutlineSymbols" attributevoid
xsetShowRowColHeaders
(XmlBoolean showRowColHeaders) Sets (as xml) the "showRowColHeaders" attributevoid
xsetShowRuler
(XmlBoolean showRuler) Sets (as xml) the "showRuler" attributevoid
xsetShowWhiteSpace
(XmlBoolean showWhiteSpace) Sets (as xml) the "showWhiteSpace" attributevoid
xsetShowZeros
(XmlBoolean showZeros) Sets (as xml) the "showZeros" attributevoid
xsetTabSelected
(XmlBoolean tabSelected) Sets (as xml) the "tabSelected" attributevoid
xsetTopLeftCell
(STCellRef topLeftCell) Sets (as xml) the "topLeftCell" attributevoid
xsetView
(STSheetViewType view) Sets (as xml) the "view" attributevoid
xsetWindowProtection
(XmlBoolean windowProtection) Sets (as xml) the "windowProtection" attributevoid
xsetWorkbookViewId
(XmlUnsignedInt workbookViewId) Sets (as xml) the "workbookViewId" attributevoid
xsetZoomScale
(XmlUnsignedInt zoomScale) Sets (as xml) the "zoomScale" attributevoid
xsetZoomScaleNormal
(XmlUnsignedInt zoomScaleNormal) Sets (as xml) the "zoomScaleNormal" attributevoid
xsetZoomScalePageLayoutView
(XmlUnsignedInt zoomScalePageLayoutView) Sets (as xml) the "zoomScalePageLayoutView" attributevoid
xsetZoomScaleSheetLayoutView
(XmlUnsignedInt zoomScaleSheetLayoutView) Sets (as xml) the "zoomScaleSheetLayoutView" attributeMethods inherited from interface org.apache.xmlbeans.XmlObject
changeType, compareTo, compareValue, copy, copy, execQuery, execQuery, isImmutable, isNil, schemaType, selectAttribute, selectAttribute, selectAttributes, selectChildren, selectChildren, selectChildren, selectPath, selectPath, set, setNil, substitute, toString, validate, validate, valueEquals, valueHashCode
Methods inherited from interface org.apache.xmlbeans.XmlTokenSource
documentProperties, dump, getDomNode, monitor, newCursor, newDomNode, newDomNode, newInputStream, newInputStream, newReader, newReader, newXMLStreamReader, newXMLStreamReader, save, save, save, save, save, save, save, save, xmlText, xmlText
-
Field Details
-
Factory
-
type
-
-
Method Details
-
getPane
CTPane getPane()Gets the "pane" element -
isSetPane
boolean isSetPane()True if has "pane" element -
setPane
Sets the "pane" element -
addNewPane
CTPane addNewPane()Appends and returns a new empty "pane" element -
unsetPane
void unsetPane()Unsets the "pane" element -
getSelectionList
List<CTSelection> getSelectionList()Gets a List of "selection" elements -
getSelectionArray
CTSelection[] getSelectionArray()Gets array of all "selection" elements -
getSelectionArray
Gets ith "selection" element -
sizeOfSelectionArray
int sizeOfSelectionArray()Returns number of "selection" element -
setSelectionArray
Sets array of all "selection" element -
setSelectionArray
Sets ith "selection" element -
insertNewSelection
Inserts and returns a new empty value (as xml) as the ith "selection" element -
addNewSelection
CTSelection addNewSelection()Appends and returns a new empty value (as xml) as the last "selection" element -
removeSelection
void removeSelection(int i) Removes the ith "selection" element -
getPivotSelectionList
List<CTPivotSelection> getPivotSelectionList()Gets a List of "pivotSelection" elements -
getPivotSelectionArray
CTPivotSelection[] getPivotSelectionArray()Gets array of all "pivotSelection" elements -
getPivotSelectionArray
Gets ith "pivotSelection" element -
sizeOfPivotSelectionArray
int sizeOfPivotSelectionArray()Returns number of "pivotSelection" element -
setPivotSelectionArray
Sets array of all "pivotSelection" element -
setPivotSelectionArray
Sets ith "pivotSelection" element -
insertNewPivotSelection
Inserts and returns a new empty value (as xml) as the ith "pivotSelection" element -
addNewPivotSelection
CTPivotSelection addNewPivotSelection()Appends and returns a new empty value (as xml) as the last "pivotSelection" element -
removePivotSelection
void removePivotSelection(int i) Removes the ith "pivotSelection" element -
getExtLst
CTExtensionList getExtLst()Gets the "extLst" element -
isSetExtLst
boolean isSetExtLst()True if has "extLst" element -
setExtLst
Sets the "extLst" element -
addNewExtLst
CTExtensionList addNewExtLst()Appends and returns a new empty "extLst" element -
unsetExtLst
void unsetExtLst()Unsets the "extLst" element -
getWindowProtection
boolean getWindowProtection()Gets the "windowProtection" attribute -
xgetWindowProtection
XmlBoolean xgetWindowProtection()Gets (as xml) the "windowProtection" attribute -
isSetWindowProtection
boolean isSetWindowProtection()True if has "windowProtection" attribute -
setWindowProtection
void setWindowProtection(boolean windowProtection) Sets the "windowProtection" attribute -
xsetWindowProtection
Sets (as xml) the "windowProtection" attribute -
unsetWindowProtection
void unsetWindowProtection()Unsets the "windowProtection" attribute -
getShowFormulas
boolean getShowFormulas()Gets the "showFormulas" attribute -
xgetShowFormulas
XmlBoolean xgetShowFormulas()Gets (as xml) the "showFormulas" attribute -
isSetShowFormulas
boolean isSetShowFormulas()True if has "showFormulas" attribute -
setShowFormulas
void setShowFormulas(boolean showFormulas) Sets the "showFormulas" attribute -
xsetShowFormulas
Sets (as xml) the "showFormulas" attribute -
unsetShowFormulas
void unsetShowFormulas()Unsets the "showFormulas" attribute -
getShowGridLines
boolean getShowGridLines()Gets the "showGridLines" attribute -
xgetShowGridLines
XmlBoolean xgetShowGridLines()Gets (as xml) the "showGridLines" attribute -
isSetShowGridLines
boolean isSetShowGridLines()True if has "showGridLines" attribute -
setShowGridLines
void setShowGridLines(boolean showGridLines) Sets the "showGridLines" attribute -
xsetShowGridLines
Sets (as xml) the "showGridLines" attribute -
unsetShowGridLines
void unsetShowGridLines()Unsets the "showGridLines" attribute -
getShowRowColHeaders
boolean getShowRowColHeaders()Gets the "showRowColHeaders" attribute -
xgetShowRowColHeaders
XmlBoolean xgetShowRowColHeaders()Gets (as xml) the "showRowColHeaders" attribute -
isSetShowRowColHeaders
boolean isSetShowRowColHeaders()True if has "showRowColHeaders" attribute -
setShowRowColHeaders
void setShowRowColHeaders(boolean showRowColHeaders) Sets the "showRowColHeaders" attribute -
xsetShowRowColHeaders
Sets (as xml) the "showRowColHeaders" attribute -
unsetShowRowColHeaders
void unsetShowRowColHeaders()Unsets the "showRowColHeaders" attribute -
getShowZeros
boolean getShowZeros()Gets the "showZeros" attribute -
xgetShowZeros
XmlBoolean xgetShowZeros()Gets (as xml) the "showZeros" attribute -
isSetShowZeros
boolean isSetShowZeros()True if has "showZeros" attribute -
setShowZeros
void setShowZeros(boolean showZeros) Sets the "showZeros" attribute -
xsetShowZeros
Sets (as xml) the "showZeros" attribute -
unsetShowZeros
void unsetShowZeros()Unsets the "showZeros" attribute -
getRightToLeft
boolean getRightToLeft()Gets the "rightToLeft" attribute -
xgetRightToLeft
XmlBoolean xgetRightToLeft()Gets (as xml) the "rightToLeft" attribute -
isSetRightToLeft
boolean isSetRightToLeft()True if has "rightToLeft" attribute -
setRightToLeft
void setRightToLeft(boolean rightToLeft) Sets the "rightToLeft" attribute -
xsetRightToLeft
Sets (as xml) the "rightToLeft" attribute -
unsetRightToLeft
void unsetRightToLeft()Unsets the "rightToLeft" attribute -
getTabSelected
boolean getTabSelected()Gets the "tabSelected" attribute -
xgetTabSelected
XmlBoolean xgetTabSelected()Gets (as xml) the "tabSelected" attribute -
isSetTabSelected
boolean isSetTabSelected()True if has "tabSelected" attribute -
setTabSelected
void setTabSelected(boolean tabSelected) Sets the "tabSelected" attribute -
xsetTabSelected
Sets (as xml) the "tabSelected" attribute -
unsetTabSelected
void unsetTabSelected()Unsets the "tabSelected" attribute -
getShowRuler
boolean getShowRuler()Gets the "showRuler" attribute -
xgetShowRuler
XmlBoolean xgetShowRuler()Gets (as xml) the "showRuler" attribute -
isSetShowRuler
boolean isSetShowRuler()True if has "showRuler" attribute -
setShowRuler
void setShowRuler(boolean showRuler) Sets the "showRuler" attribute -
xsetShowRuler
Sets (as xml) the "showRuler" attribute -
unsetShowRuler
void unsetShowRuler()Unsets the "showRuler" attribute -
getShowOutlineSymbols
boolean getShowOutlineSymbols()Gets the "showOutlineSymbols" attribute -
xgetShowOutlineSymbols
XmlBoolean xgetShowOutlineSymbols()Gets (as xml) the "showOutlineSymbols" attribute -
isSetShowOutlineSymbols
boolean isSetShowOutlineSymbols()True if has "showOutlineSymbols" attribute -
setShowOutlineSymbols
void setShowOutlineSymbols(boolean showOutlineSymbols) Sets the "showOutlineSymbols" attribute -
xsetShowOutlineSymbols
Sets (as xml) the "showOutlineSymbols" attribute -
unsetShowOutlineSymbols
void unsetShowOutlineSymbols()Unsets the "showOutlineSymbols" attribute -
getDefaultGridColor
boolean getDefaultGridColor()Gets the "defaultGridColor" attribute -
xgetDefaultGridColor
XmlBoolean xgetDefaultGridColor()Gets (as xml) the "defaultGridColor" attribute -
isSetDefaultGridColor
boolean isSetDefaultGridColor()True if has "defaultGridColor" attribute -
setDefaultGridColor
void setDefaultGridColor(boolean defaultGridColor) Sets the "defaultGridColor" attribute -
xsetDefaultGridColor
Sets (as xml) the "defaultGridColor" attribute -
unsetDefaultGridColor
void unsetDefaultGridColor()Unsets the "defaultGridColor" attribute -
getShowWhiteSpace
boolean getShowWhiteSpace()Gets the "showWhiteSpace" attribute -
xgetShowWhiteSpace
XmlBoolean xgetShowWhiteSpace()Gets (as xml) the "showWhiteSpace" attribute -
isSetShowWhiteSpace
boolean isSetShowWhiteSpace()True if has "showWhiteSpace" attribute -
setShowWhiteSpace
void setShowWhiteSpace(boolean showWhiteSpace) Sets the "showWhiteSpace" attribute -
xsetShowWhiteSpace
Sets (as xml) the "showWhiteSpace" attribute -
unsetShowWhiteSpace
void unsetShowWhiteSpace()Unsets the "showWhiteSpace" attribute -
getView
STSheetViewType.Enum getView()Gets the "view" attribute -
xgetView
STSheetViewType xgetView()Gets (as xml) the "view" attribute -
isSetView
boolean isSetView()True if has "view" attribute -
setView
Sets the "view" attribute -
xsetView
Sets (as xml) the "view" attribute -
unsetView
void unsetView()Unsets the "view" attribute -
getTopLeftCell
String getTopLeftCell()Gets the "topLeftCell" attribute -
xgetTopLeftCell
STCellRef xgetTopLeftCell()Gets (as xml) the "topLeftCell" attribute -
isSetTopLeftCell
boolean isSetTopLeftCell()True if has "topLeftCell" attribute -
setTopLeftCell
Sets the "topLeftCell" attribute -
xsetTopLeftCell
Sets (as xml) the "topLeftCell" attribute -
unsetTopLeftCell
void unsetTopLeftCell()Unsets the "topLeftCell" attribute -
getColorId
long getColorId()Gets the "colorId" attribute -
xgetColorId
XmlUnsignedInt xgetColorId()Gets (as xml) the "colorId" attribute -
isSetColorId
boolean isSetColorId()True if has "colorId" attribute -
setColorId
void setColorId(long colorId) Sets the "colorId" attribute -
xsetColorId
Sets (as xml) the "colorId" attribute -
unsetColorId
void unsetColorId()Unsets the "colorId" attribute -
getZoomScale
long getZoomScale()Gets the "zoomScale" attribute -
xgetZoomScale
XmlUnsignedInt xgetZoomScale()Gets (as xml) the "zoomScale" attribute -
isSetZoomScale
boolean isSetZoomScale()True if has "zoomScale" attribute -
setZoomScale
void setZoomScale(long zoomScale) Sets the "zoomScale" attribute -
xsetZoomScale
Sets (as xml) the "zoomScale" attribute -
unsetZoomScale
void unsetZoomScale()Unsets the "zoomScale" attribute -
getZoomScaleNormal
long getZoomScaleNormal()Gets the "zoomScaleNormal" attribute -
xgetZoomScaleNormal
XmlUnsignedInt xgetZoomScaleNormal()Gets (as xml) the "zoomScaleNormal" attribute -
isSetZoomScaleNormal
boolean isSetZoomScaleNormal()True if has "zoomScaleNormal" attribute -
setZoomScaleNormal
void setZoomScaleNormal(long zoomScaleNormal) Sets the "zoomScaleNormal" attribute -
xsetZoomScaleNormal
Sets (as xml) the "zoomScaleNormal" attribute -
unsetZoomScaleNormal
void unsetZoomScaleNormal()Unsets the "zoomScaleNormal" attribute -
getZoomScaleSheetLayoutView
long getZoomScaleSheetLayoutView()Gets the "zoomScaleSheetLayoutView" attribute -
xgetZoomScaleSheetLayoutView
XmlUnsignedInt xgetZoomScaleSheetLayoutView()Gets (as xml) the "zoomScaleSheetLayoutView" attribute -
isSetZoomScaleSheetLayoutView
boolean isSetZoomScaleSheetLayoutView()True if has "zoomScaleSheetLayoutView" attribute -
setZoomScaleSheetLayoutView
void setZoomScaleSheetLayoutView(long zoomScaleSheetLayoutView) Sets the "zoomScaleSheetLayoutView" attribute -
xsetZoomScaleSheetLayoutView
Sets (as xml) the "zoomScaleSheetLayoutView" attribute -
unsetZoomScaleSheetLayoutView
void unsetZoomScaleSheetLayoutView()Unsets the "zoomScaleSheetLayoutView" attribute -
getZoomScalePageLayoutView
long getZoomScalePageLayoutView()Gets the "zoomScalePageLayoutView" attribute -
xgetZoomScalePageLayoutView
XmlUnsignedInt xgetZoomScalePageLayoutView()Gets (as xml) the "zoomScalePageLayoutView" attribute -
isSetZoomScalePageLayoutView
boolean isSetZoomScalePageLayoutView()True if has "zoomScalePageLayoutView" attribute -
setZoomScalePageLayoutView
void setZoomScalePageLayoutView(long zoomScalePageLayoutView) Sets the "zoomScalePageLayoutView" attribute -
xsetZoomScalePageLayoutView
Sets (as xml) the "zoomScalePageLayoutView" attribute -
unsetZoomScalePageLayoutView
void unsetZoomScalePageLayoutView()Unsets the "zoomScalePageLayoutView" attribute -
getWorkbookViewId
long getWorkbookViewId()Gets the "workbookViewId" attribute -
xgetWorkbookViewId
XmlUnsignedInt xgetWorkbookViewId()Gets (as xml) the "workbookViewId" attribute -
setWorkbookViewId
void setWorkbookViewId(long workbookViewId) Sets the "workbookViewId" attribute -
xsetWorkbookViewId
Sets (as xml) the "workbookViewId" attribute
-