// 次のサンプルコードは、hoveredUnSelectedItemWithNoDataStyleメソッドを使用します。 var datasource = [ { Name: "Apple", Category: "Fruit" }, { Name: "Orange", Category: "Fruit" }, { Name: "Broccoli", Category: "Vegetable" }, { Name: "Kiwi", Category: "Fruit" }, { Name: "Rice", Category: "Cereal" }, { Name: "Strawberry", Category: "Fruit" }, { Name: "Yogurt", Category: "Dairy" }, { Name: "Plum", Category: "Fruit" }, { Name: "Celery", Category: "Vegetable" }, { Name: "Grape", Category: "Fruit" }, { Name: "Oats", Category: "Cereal" }, { Name: "Quinoa", Category: "Cereal" }, { Name: "Maize", Category: "Cereal" }, { Name: "Okra", Category: "Vegetable" }, { Name: "Corn", Category: "Vegetable" }, { Name: "Wheat", Category: "Cereal" }, { Name: "Barley", Category: "Cereal" }, { Name: "Cream", Category: "Dairy" }, { Name: "Millet", Category: "Cereal" }, { Name: "Rye", Category: "Cereal" }, { Name: "Artichoke", Category: "Vegetable" }, { Name: "Buckwheat", Category: "Cereal" }, { Name: "Gooseberry", Category: "Fruit" }, { Name: "Amaranth", Category: "Cereal" }, { Name: "Carrot", Category: "Vegetable" }, { Name: "Cheese", Category: "Dairy" }, { Name: "Fig", Category: "Fruit" }, { Name: "Milk", Category: "Dairy" }, { Name: "Butter", Category: "Dairy" }, ]; var table = activeSheet.tables.addFromDataSource("table1", 1, 1, datasource); // スライサーをシートに追加し、スライサーインスタンスを返します。 var slicer = activeSheet.slicers.add("slicer1",table.name(),"Category"); // スライサーのプロパティを変更します。 slicer.width(200); slicer.height(200); slicer.position(new GC.Spread.Sheets.Point(300, 50)); var slicer2 = activeSheet.slicers.add("slicer2", table.name(), "Name"); 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")); hstyle1.backColor("yellow"); var hstyle2 = new GC.Spread.Sheets.Slicers.SlicerStyleInfo(); hstyle2.backColor("green"); var style1 = new GC.Spread.Sheets.Slicers.SlicerStyle(); style1.hoveredSelectedItemWithDataStyle(hstyle); style1.hoveredUnSelectedItemWithDataStyle(hstyle); style1.unSelectedItemWithDataStyle(hstyle1); style1.selectedItemWithDataStyle(hstyle2); slicer.style(style1); var hstyle2nd = new GC.Spread.Sheets.Slicers.SlicerStyleInfo(); hstyle2nd.backColor("red"); hstyle2nd.borderBottom(new GC.Spread.Sheets.Slicers.SlicerBorder(3, "double", "orange")); var hstyle12nd = new GC.Spread.Sheets.Slicers.SlicerStyleInfo(); hstyle12nd.borderTop(new GC.Spread.Sheets.Slicers.SlicerBorder(2, "double", "blue")); hstyle12nd.backColor("yellow"); var hstyle22nd = new GC.Spread.Sheets.Slicers.SlicerStyleInfo(); hstyle22nd.backColor("magenta"); var style1two = new GC.Spread.Sheets.Slicers.SlicerStyle(); style1two.hoveredSelectedItemWithNoDataStyle(hstyle2nd); style1two.hoveredUnSelectedItemWithNoDataStyle(hstyle2nd); style1two.unSelectedItemWithNoDataStyle(hstyle12nd); style1two.selectedItemWithNoDataStyle(hstyle22nd); slicer2.style(style1two); activeSheet.getColumn(1).width(100); activeSheet.getColumn(2).width(100); activeSheet.getColumn(3).width(100);

 //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);