com.aspose.cells

com.aspose.cells

Class Slicer

  • java.lang.Object
    • com.aspose.cells.Slicer
public class Slicer 
extends java.lang.Object

summary description of Slicer View

Property Getters/Setters Summary
java.lang.StringgetCaption()
void
setCaption(java.lang.Stringvalue)
           Returns or sets the caption of the specified slicer.
booleangetCaptionVisible()
void
setCaptionVisible(booleanvalue)
           Returns or sets whether the header that displays the slicer Caption is visible the default value is true
doublegetColumnWidth()
void
setColumnWidth(doublevalue)
           Returns or sets the width, in points, of each column in the slicer. Read/write
doublegetHeight()
void
setHeight(doublevalue)
           Returns or sets the height of the specified slicer, in points. Read/write.
booleangetLockedPosition()
void
setLockedPosition(booleanvalue)
           Returns or sets whether the specified slicer can be moved or resized by using the user interface. Read/write.
java.lang.StringgetName()
void
setName(java.lang.Stringvalue)
           Returns or sets the name of the specified slicer
intgetNumberOfColumns()
void
setNumberOfColumns(intvalue)
           Returns or sets the number of columns in the specified slicer. Read/write.
WorksheetgetParent()
Returns the Worksheet object that represents the sheet that contains the slicer. Read-only.
doublegetRowHeight()
void
setRowHeight(doublevalue)
           Returns or sets the height, in points, of each row in the specified slicer. Read/write.
SlicerCachegetSlicerCache()
Returns the SlicerCache object associated with the slicer. Read-only.
intgetStyleType()
void
setStyleType(intvalue)
           Specify the type of Built-in slicer style the default type is SlicerStyleLight1 The value of the property is SlicerStyleType integer constant.
doublegetWidth()
void
setWidth(doublevalue)
           Returns or sets the width of the specified slicer, in points. Read/write.
 
Method Summary
voidrefresh()
Refreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables.
 

    • Property Getters/Setters Detail

      • getSlicerCache

        public SlicerCache getSlicerCache()
        Returns the SlicerCache object associated with the slicer. Read-only.

      • getParent

        public Worksheet getParent()
        Returns the Worksheet object that represents the sheet that contains the slicer. Read-only.

      • getStyleType/setStyleType

        public int getStyleType() / public void setStyleType(int value)
        Specify the type of Built-in slicer style the default type is SlicerStyleLight1 The value of the property is SlicerStyleType integer constant.

      • getName/setName

        public java.lang.String getName() / public void setName(java.lang.String value)
        Returns or sets the name of the specified slicer

      • getCaption/setCaption

        public java.lang.String getCaption() / public void setCaption(java.lang.String value)
        Returns or sets the caption of the specified slicer.

      • getCaptionVisible/setCaptionVisible

        public boolean getCaptionVisible() / public void setCaptionVisible(boolean value)
        Returns or sets whether the header that displays the slicer Caption is visible the default value is true

      • getLockedPosition/setLockedPosition

        public boolean getLockedPosition() / public void setLockedPosition(boolean value)
        Returns or sets whether the specified slicer can be moved or resized by using the user interface. Read/write.

      • getNumberOfColumns/setNumberOfColumns

        public int getNumberOfColumns() / public void setNumberOfColumns(int value)
        Returns or sets the number of columns in the specified slicer. Read/write.

      • getWidth/setWidth

        public double getWidth() / public void setWidth(double value)
        Returns or sets the width of the specified slicer, in points. Read/write.

      • getHeight/setHeight

        public double getHeight() / public void setHeight(double value)
        Returns or sets the height of the specified slicer, in points. Read/write.

      • getColumnWidth/setColumnWidth

        public double getColumnWidth() / public void setColumnWidth(double value)
        Returns or sets the width, in points, of each column in the slicer. Read/write

      • getRowHeight/setRowHeight

        public double getRowHeight() / public void setRowHeight(double value)
        Returns or sets the height, in points, of each row in the specified slicer. Read/write.

    setStyleType

    public voidsetStyleType(intvalue)
    Specify the type of Built-in slicer style the default type is SlicerStyleLight1 The value of the property is SlicerStyleType integer constant.

    setName

    public voidsetName(java.lang.Stringvalue)
    Returns or sets the name of the specified slicer

    setCaption

    public voidsetCaption(java.lang.Stringvalue)
    Returns or sets the caption of the specified slicer.

    setCaptionVisible

    public voidsetCaptionVisible(booleanvalue)
    Returns or sets whether the header that displays the slicer Caption is visible the default value is true

    setLockedPosition

    public voidsetLockedPosition(booleanvalue)
    Returns or sets whether the specified slicer can be moved or resized by using the user interface. Read/write.

    setNumberOfColumns

    public voidsetNumberOfColumns(intvalue)
    Returns or sets the number of columns in the specified slicer. Read/write.

    setWidth

    public voidsetWidth(doublevalue)
    Returns or sets the width of the specified slicer, in points. Read/write.

    setHeight

    public voidsetHeight(doublevalue)
    Returns or sets the height of the specified slicer, in points. Read/write.

    setColumnWidth

    public voidsetColumnWidth(doublevalue)
    Returns or sets the width, in points, of each column in the slicer. Read/write

    setRowHeight

    public voidsetRowHeight(doublevalue)
    Returns or sets the height, in points, of each row in the specified slicer. Read/write.

    • Method Detail

      • refresh

        public void refresh()
            throws java.lang.Exception
        Refreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables.