disableResizingAndMoving Method

Gets or sets whether to disable resizing and moving the slicer.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Slicer(name, table, columnName);
var returnValue; // Type: boolean
returnValue = instance.disableResizingAndMoving(value);

function disableResizingAndMoving( 
   value : boolean
) : boolean;

Parameters

value: The setting for whether to disable resizing and moving the slicer.

Return Value

The setting for whether to disable resizing and moving the slicer.

Example

This example prevents moving or resizing the slicer.

Javascript

//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.addTableByDataSource("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 GcSpread.Sheets.SlicerStyles.light4();
//add a slicer to the sheet and return the slicer instance.
var slicer = activeSheet.addSlicer("slicer1",table.name(),"Height");
 //change the slicer properties.
slicer.position(new GcSpread.Sheets.Point(100, 200));
slicer.disableResizingAndMoving(true);
slicer.style(style1);

Reference

Slicer type