SpreadJS 13
GC.Spread.Sheets.Slicers Namespace / SlicerStyle type / unSelectedItemWithDataStyle Method
The style of the unselected item with data.
In This Topic
    unSelectedItemWithDataStyle Method
    In This Topic
    Gets or sets the style of the unselected item with data.
    Syntax
    var instance = new GC.Spread.Sheets.Slicers.SlicerStyle();
    var returnValue; // Type: any
    returnValue = instance.unSelectedItemWithDataStyle(value);
    function unSelectedItemWithDataStyle( 
       (optional) value : SlicerStyleInfo
    ) : any;

    Parameters

    value
    The style of the unselected item with data.

    Return Value

    If no value is set, returns the style of the unselected item with data; otherwise, returns the slicer style.
    Example
    This example sets border styles for the slicer.
     //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 hstyle = new GC.Spread.Sheets.Slicers.SlicerStyleInfo();
    hstyle.backColor("red");
    hstyle.borderBottom(new GC.Spread.Sheets.Slicers.SlicerBorder(3, "dashed", "green"));
    
    var hstyle1 = new GC.Spread.Sheets.Slicers.SlicerStyleInfo();
    hstyle1.borderTop(new GC.Spread.Sheets.Slicers.SlicerBorder(2, "dashed", "blue"));
    
    var style1 = new GC.Spread.Sheets.Slicers.SlicerStyle();
    style1.hoveredSelectedItemWithDataStyle(hstyle);
    style1.unSelectedItemWithDataStyle(hstyle1);
    
    //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);
    See Also