Class CustomSheetView
java.lang.Object
com.independentsoft.office.spreadsheet.CustomSheetView
The Class CustomSheetView.
-
Constructor Summary
Constructors -
Method Summary
Modifier and TypeMethodDescriptionclone()Gets the auto filter.intGets the color id.getGuid()Gets the guid.Gets the header footer settings.Gets the horizontal page breaks.Gets the page margins.Gets the page setup settings.Gets the prints the options.intGets the prints the scale.Gets the selection.Gets the top left cell.Gets the vertical page breaks.Gets the view pane.Gets the view type.Gets the visibility state.booleanChecks for hidden columns.booleanChecks for hidden rows.booleanChecks for print area.booleanisFilter()Checks if is filter.booleanChecks if is filter unique.booleanChecks if is fit to page.booleanChecks if is show auto filter.booleanChecks if is show formulas.booleanChecks if is show grid lines.booleanChecks if is show headers.booleanChecks if is show outline symbols.booleanChecks if is show page breaks.booleanChecks if is show ruler.booleanChecks if is show zero values.voidsetAutoFilter(AutoFilter autoFilter)Sets the auto filter.voidsetColorID(int colorID)Sets the color id.voidsetFilter(boolean filter)Sets the filter.voidsetFilterUnique(boolean filterUnique)Sets the filter unique.voidsetFitToPage(boolean fitToPage)Sets the fit to page.voidSets the guid.voidsetHiddenColumns(boolean hasHiddenColumns)Sets the hidden columns.voidsetHiddenRows(boolean hasHiddenRows)Sets the hidden rows.voidsetPageMargins(PageMargins pageMargins)Sets the page margins.voidsetPrintArea(boolean hasPrintArea)Sets the prints the area.voidsetPrintOptions(PrintOptions printOptions)Sets the prints the options.voidsetPrintScale(int printScale)Sets the prints the scale.voidsetSelection(Selection selection)Sets the selection.voidsetShowAutoFilter(boolean showAutoFilter)Sets the show auto filter.voidsetShowFormulas(boolean showFormulas)Sets the show formulas.voidsetShowGridLines(boolean showGridLines)Sets the show grid lines.voidsetShowHeaders(boolean showHeaders)Sets the show headers.voidsetShowOutlineSymbols(boolean showOutlineSymbols)Sets the show outline symbols.voidsetShowPageBreaks(boolean showPageBreaks)Sets the show page breaks.voidsetShowRuler(boolean showRuler)Sets the show ruler.voidsetShowZeroValues(boolean showZeroValues)Sets the show zero values.voidsetTopLeftCell(String topLeftCell)Sets the top left cell.voidsetViewPane(SheetViewPane viewPane)Sets the view pane.voidsetViewType(SheetViewType viewType)Sets the view type.voidsetVisibilityState(SheetVisibilityType visibilityState)Sets the visibility state.toString()
-
Constructor Details
-
CustomSheetView
public CustomSheetView()Instantiates a new custom sheet view.
-
-
Method Details
-
clone
-
toString
-
getAutoFilter
Gets the auto filter.- Returns:
- the auto filter
-
setAutoFilter
Sets the auto filter.- Parameters:
autoFilter- the new auto filter
-
getVerticalPageBreaks
Gets the vertical page breaks.- Returns:
- the vertical page breaks
-
getPageMargins
Gets the page margins.- Returns:
- the page margins
-
setPageMargins
Sets the page margins.- Parameters:
pageMargins- the new page margins
-
getPageSetupSettings
Gets the page setup settings.- Returns:
- the page setup settings
-
getViewPane
Gets the view pane.- Returns:
- the view pane
-
setViewPane
Sets the view pane.- Parameters:
viewPane- the new view pane
-
getPrintOptions
Gets the prints the options.- Returns:
- the prints the options
-
setPrintOptions
Sets the prints the options.- Parameters:
printOptions- the new prints the options
-
getHorizontalPageBreaks
Gets the horizontal page breaks.- Returns:
- the horizontal page breaks
-
getSelection
Gets the selection.- Returns:
- the selection
-
setSelection
Sets the selection.- Parameters:
selection- the new selection
-
getColorID
public int getColorID()Gets the color id.- Returns:
- the color id
-
setColorID
public void setColorID(int colorID)Sets the color id.- Parameters:
colorID- the new color id
-
isFilter
public boolean isFilter()Checks if is filter.- Returns:
- true, if is filter
-
setFilter
public void setFilter(boolean filter)Sets the filter.- Parameters:
filter- the new filter
-
isFilterUnique
public boolean isFilterUnique()Checks if is filter unique.- Returns:
- true, if is filter unique
-
setFilterUnique
public void setFilterUnique(boolean filterUnique)Sets the filter unique.- Parameters:
filterUnique- the new filter unique
-
isFitToPage
public boolean isFitToPage()Checks if is fit to page.- Returns:
- true, if is fit to page
-
setFitToPage
public void setFitToPage(boolean fitToPage)Sets the fit to page.- Parameters:
fitToPage- the new fit to page
-
getGuid
Gets the guid.- Returns:
- the guid
-
setGuid
Sets the guid.- Parameters:
guid- the new guid
-
hasHiddenColumns
public boolean hasHiddenColumns()Checks for hidden columns.- Returns:
- true, if successful
-
setHiddenColumns
public void setHiddenColumns(boolean hasHiddenColumns)Sets the hidden columns.- Parameters:
hasHiddenColumns- the new hidden columns
-
hasHiddenRows
public boolean hasHiddenRows()Checks for hidden rows.- Returns:
- true, if successful
-
setHiddenRows
public void setHiddenRows(boolean hasHiddenRows)Sets the hidden rows.- Parameters:
hasHiddenRows- the new hidden rows
-
isShowOutlineSymbols
public boolean isShowOutlineSymbols()Checks if is show outline symbols.- Returns:
- true, if is show outline symbols
-
setShowOutlineSymbols
public void setShowOutlineSymbols(boolean showOutlineSymbols)Sets the show outline symbols.- Parameters:
showOutlineSymbols- the new show outline symbols
-
hasPrintArea
public boolean hasPrintArea()Checks for print area.- Returns:
- true, if successful
-
setPrintArea
public void setPrintArea(boolean hasPrintArea)Sets the prints the area.- Parameters:
hasPrintArea- the new prints the area
-
getPrintScale
public int getPrintScale()Gets the prints the scale.- Returns:
- the prints the scale
-
setPrintScale
public void setPrintScale(int printScale)Sets the prints the scale.- Parameters:
printScale- the new prints the scale
-
isShowAutoFilter
public boolean isShowAutoFilter()Checks if is show auto filter.- Returns:
- true, if is show auto filter
-
setShowAutoFilter
public void setShowAutoFilter(boolean showAutoFilter)Sets the show auto filter.- Parameters:
showAutoFilter- the new show auto filter
-
isShowFormulas
public boolean isShowFormulas()Checks if is show formulas.- Returns:
- true, if is show formulas
-
setShowFormulas
public void setShowFormulas(boolean showFormulas)Sets the show formulas.- Parameters:
showFormulas- the new show formulas
-
isShowGridLines
public boolean isShowGridLines()Checks if is show grid lines.- Returns:
- true, if is show grid lines
-
setShowGridLines
public void setShowGridLines(boolean showGridLines)Sets the show grid lines.- Parameters:
showGridLines- the new show grid lines
-
isShowPageBreaks
public boolean isShowPageBreaks()Checks if is show page breaks.- Returns:
- true, if is show page breaks
-
setShowPageBreaks
public void setShowPageBreaks(boolean showPageBreaks)Sets the show page breaks.- Parameters:
showPageBreaks- the new show page breaks
-
isShowHeaders
public boolean isShowHeaders()Checks if is show headers.- Returns:
- true, if is show headers
-
setShowHeaders
public void setShowHeaders(boolean showHeaders)Sets the show headers.- Parameters:
showHeaders- the new show headers
-
isShowRuler
public boolean isShowRuler()Checks if is show ruler.- Returns:
- true, if is show ruler
-
setShowRuler
public void setShowRuler(boolean showRuler)Sets the show ruler.- Parameters:
showRuler- the new show ruler
-
getVisibilityState
Gets the visibility state.- Returns:
- the visibility state
-
setVisibilityState
Sets the visibility state.- Parameters:
visibilityState- the new visibility state
-
getTopLeftCell
Gets the top left cell.- Returns:
- the top left cell
-
setTopLeftCell
Sets the top left cell.- Parameters:
topLeftCell- the new top left cell
-
getViewType
Gets the view type.- Returns:
- the view type
-
setViewType
Sets the view type.- Parameters:
viewType- the new view type
-
isShowZeroValues
public boolean isShowZeroValues()Checks if is show zero values.- Returns:
- true, if is show zero values
-
setShowZeroValues
public void setShowZeroValues(boolean showZeroValues)Sets the show zero values.- Parameters:
showZeroValues- the new show zero values
-