SpreadJS 14
GC.Spread.Sheets.Slicers Namespace / SlicerStyles type
In This Topic
    SlicerStyles type
    In This Topic
    Represents a built-in slicer style collection.
    Syntax
    var instance = new GC.Spread.Sheets.Slicers.SlicerStyles();
    function SlicerStyles;
    Example
    //This example uses a built-in style.
    //create a table
    datas = [
        ["1", "NewYork", "1968/6/8", "80", "180"],
        ["4", "NewYork", "1972/7/3", "72", "168"],
        ["4", "NewYork", "1964/3/2", "71", "179"],
        ["5", "Washington", "1972/8/8","80", "171"],
        ["6", "Washington", "1986/2/2", "89", "161"],
        ["7", "Washington", "2012/2/15", "71", "240"]];
    var table = activeSheet.tables.addFromDataSource("table1", 2, 2, datas);
    dataColumns = ["Name", "City", "Birthday", "Weight", "Height"];
    table.setColumnName(0, dataColumns[0]);
    table.setColumnName(1, dataColumns[1]);
    table.setColumnName(2, dataColumns[2]);
    table.setColumnName(3, dataColumns[3]);
    table.setColumnName(4, dataColumns[4]);
    var style1 = new GC.Spread.Sheets.Slicers.SlicerStyles.light4();
    //add a slicer to the sheet and return the slicer instance.
    var slicer = activeSheet.slicers.add("slicer1",table.name(),"Name");
     //change the slicer properties.
    slicer.position(new GC.Spread.Sheets.Point(100, 200));
    slicer.style(style1);
    Inheritance Hierarchy

    Object
       GC.Spread.Sheets.Slicers.SlicerStyles

    Constructors
     NameDescription
    public ConstructorRepresents a built-in slicer style collection.  
    Top
    Methods
     NameDescription
    public Methodstatic (Shared in Visual Basic)Gets the dark1 style.  
    public Methodstatic (Shared in Visual Basic)Gets the dark2 style.  
    public Methodstatic (Shared in Visual Basic)Gets the dark3 style.  
    public Methodstatic (Shared in Visual Basic)Gets the dark4 style.  
    public Methodstatic (Shared in Visual Basic)Gets the dark5 style.  
    public Methodstatic (Shared in Visual Basic)Gets the dark6 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light1 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light2 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light3 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light4 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light5 style.  
    public Methodstatic (Shared in Visual Basic)Gets the light6 style.  
    public Methodstatic (Shared in Visual Basic)Gets the other1 style.  
    public Methodstatic (Shared in Visual Basic)
     
    Top
    See Also