[]
• new Slicer()
表示一个表格项目切片器。
▸ allowMove(value?): any
获取或设置切片器的allowMove属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.allowMove();
console.log(oldValue);
slicer.allowMove(false);
var newValue = slicer.allowMove();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的allowMove属性。切片器的allowMove属性指定是否允许用户移动切片器,启用或禁用重新定位功能。 |
any
如果未设置值,返回切片器的allowMove属性;否则返回切片器。
▸ allowResize(value?): any
获取或设置切片器的allowResize属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.allowResize();
console.log(oldValue);
slicer.allowResize(false);
var newValue = slicer.allowResize();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的allowResize属性。切片器的allowResize属性指定是否允许用户调整切片器的大小,启用或禁用调整大小功能。 |
any
如果未设置值,返回切片器的allowResize属性;否则返回切片器。
▸ captionName(value?): any
获取或设置切片器的captionName属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.captionName();
console.log(oldValue);
slicer.captionName('Slicer_Caption');
var newValue = slicer.captionName();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
string |
切片器的captionName属性。切片器的captionName属性显示在切片器的标题中。 |
any
如果未设置值,返回切片器的captionName属性;否则返回切片器。
▸ columnCount(value?): any
获取或设置切片器的columnCount属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.columnCount();
console.log(oldValue);
slicer.columnCount(3);
var newValue = slicer.columnCount();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的columnCount属性。切片器的columnCount属性指定切片器的列数。 |
any
如果未设置值,返回切片器的columnCount属性;否则返回切片器。
▸ columnName(): string
获取切片器的columnName属性。切片器的columnName属性指定切片器关联的源数据字段中的列的名称。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
console.log(slicer.columnName());
string
返回
▸ disableResizingAndMoving(value?): any
获取或设置切片器的disableResizingAndMoving属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.disableResizingAndMoving();
console.log(oldValue);
slicer.disableResizingAndMoving(true);
var newValue = slicer.disableResizingAndMoving();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的disableResizingAndMoving属性。切片器的disableResizingAndMoving属性指定是否允许用户调整切片器的大小或移动切片器,限制其大小或位置的任何更改。 |
any
如果未设置值,返回切片器的disableResizingAndMoving属性;否则返回切片器。
▸ dynamicMove(value?): any
获取或设置切片器的dynamicMove属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.dynamicMove();
console.log(oldValue);
slicer.dynamicMove(false);
var newValue = slicer.dynamicMove();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的dynamicMove属性。切片器的dynamicMove属性指定切片器控制是否配置为动态调整其位置或大小,基于关联数据或PivotTable布局的变化。 |
any
如果未设置值,返回切片器的dynamicMove属性;否则返回切片器。
▸ dynamicSize(value?): any
获取或设置切片器的dynamicSize属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.dynamicSize();
console.log(oldValue);
slicer.dynamicSize(false);
var newValue = slicer.dynamicSize();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的dynamicSize属性。切片器的dynamicSize属性指定切片器控制是否配置为动态调整其大小,基于关联数据或PivotTable布局的变化。 |
any
如果未设置值,返回切片器的dynamicSize属性;否则返回切片器。
▸ endColumn(value?): any
获取或设置切片器的endColumn属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.endColumn();
console.log(oldValue);
slicer.endColumn(20);
var newValue = slicer.endColumn();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的endColumnOffset。切片器的endColumnOffset属性指定了切片器右边缘与其所在列起始位置之间的水平偏移量(即距离)。 |
any
如果未设置值,返回切片器的endColumn属性;否则返回切片器。
▸ endColumnOffset(value?): any
获取或设置切片器的endColumnOffset属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.endColumnOffset();
console.log(oldValue);
slicer.endColumnOffset(5);
var newValue = slicer.endColumnOffset();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的endColumnOffset属性。切片器的endColumnOffset属性指定切片器结束的列索引或工作表中的位置,其中切片器结束或受限。 |
any
如果未设置值,返回切片器的endColumnOffset属性;否则返回切片器。
▸ endRow(value?): any
获取或设置切片器的endRow属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.endRow();
console.log(oldValue);
slicer.endRow(20);
var newValue = slicer.endRow();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的endRow属性。切片器的endRow属性指定切片器结束的行索引或工作表中的位置,其中切片器结束或受限。 |
any
如果未设置值,返回切片器的endRow属性;否则返回切片器。
▸ endRowOffset(value?): any
获取或设置切片器的endRowOffset属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.endRowOffset();
console.log(oldValue);
slicer.endRowOffset(5);
var newValue = slicer.endRowOffset();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的endRowOffset。切片器的endRowOffset属性指定了垂直偏移量,即切片器下边缘与包含该下边缘的行的上边缘之间的距离。 |
any
如果未设置值,返回切片器的endRowOffset属性;否则返回切片器。
▸ height(value?): any
获取或设置切片器的height属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.height();
console.log(oldValue);
slicer.height(200);
var newValue = slicer.height();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的height属性。切片器的height属性指定切片器控制的高度或垂直维度,确定其在y轴上的大小。 |
any
如果未设置值,返回切片器的height属性;否则返回切片器。
▸ isLocked(value?): any
获取或设置切片器的isLocked属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
activeSheet.options.isProtected = true;
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.isLocked();
console.log(oldValue);
slicer.isLocked(false);
var newValue = slicer.isLocked();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的isLocked属性。切片器的isLocked属性指定切片器当前是否锁定或解锁,指示用户是否可以在工作表受保护时更改其设置或选择。 |
any
如果未设置值,返回切片器的isLocked属性;否则返回切片器。
▸ isSelected(value?): any
获取或设置切片器的isSelected属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.isSelected();
console.log(oldValue);
slicer.isSelected(true);
var newValue = slicer.isSelected();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的isSelected属性。切片器的isSelected属性指定切片器中当前是否选择或突出显示特定项目。 |
any
如果未设置值,返回切片器的isSelected属性;否则返回切片器。
▸ isVisible(value?): any
获取或设置切片器的isVisible属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.isVisible();
console.log(oldValue);
slicer.isVisible(false);
var newValue = slicer.isVisible();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的isVisible属性。切片器的isVisible属性指定切片器当前是否可见或隐藏。 |
any
如果未设置值,返回切片器的isVisible属性;否则返回切片器。
▸ itemHeight(value?): any
获取或设置切片器的itemHeight属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.itemHeight();
console.log(oldValue);
slicer.itemHeight(34);
var newValue = slicer.itemHeight();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的itemHeight属性。切片器的itemHeight属性指定切片器控制中每个项目或行的高度。 |
any
如果未设置值,返回切片器的itemHeight属性;否则返回切片器。
▸ multiSelect(value?): any
获取或设置切片器的multiSelect属性。
example
var spread = GC.Spread.Sheets.findControl('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.multiSelect();
console.log(oldValue);
slicer.multiSelect(true);
var newValue = slicer.multiSelect();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的multiSelect属性。切片器的multiSelect属性指定是否可以在切片器中同时选择多个项目。 |
any
如果未设置值,返回切片器的multiSelect属性;否则返回切片器。
▸ name(value?): any
获取或设置切片器的name属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.name();
console.log(oldValue);
slicer.name('SlicerA');
var newValue = slicer.name();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
string |
切片器的name属性。切片器的name属性指定分配给切片器的唯一标识符或标签,允许在工作簿或编程交互中进行识别和引用。 |
any
如果未设置值,返回切片器的name属性;否则返回切片器。
▸ nameInFormula(): string
获取切片器的nameInFormula属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
console.log(slicer.nameInFormula());
string
返回切片器的nameInFormula属性。
▸ position(value?): any
获取或设置切片器的position属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.position();
console.log(oldValue);
slicer.position(new GC.Spread.Sheets.Point(100, 200));
var newValue = slicer.position();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
Point |
切片器的position属性。切片器的position属性指定切片器在工作表中的位置。 |
any
如果未设置值,返回切片器的position属性;否则返回切片器。
▸ refresh(): void
刷新切片器。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
// 添加自定义切片器样式
let slicerStyle = spread.customSlicerThemes.add("custom0");
let wholeSlicerStyle = new GC.Spread.Sheets.Slicers.SlicerStyleInfo();
wholeSlicerStyle.backColor = "blue";
slicerStyle.wholeSlicerStyle(wholeSlicerStyle);
// 添加一个切片器
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
slicer.style("custom0");
// 修改自定义切片器样式
spread.customSlicerThemes.all()[0].headerStyle().backColor('red');
// 刷新切片器
slicer.refresh();
void
▸ sheet(): Worksheet
获取切片器的工作表。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
console.log(slicer.sheet().name());
返回切片器的工作表。
▸ showHeader(value?): any
获取或设置切片器的showHeader属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.showHeader();
console.log(oldValue);
slicer.showHeader(false);
var newValue = slicer.showHeader();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的showHeader属性。切片器的showHeader属性指定是否显示切片器中的标题,包括标题和过滤相关控件。 |
any
如果未设置值,返回切片器的showHeader属性;否则返回切片器。
▸ showNoDataItems(value?): any
获取或设置切片器的showNoDataItems,NoDataItems指的是在当前筛选器和数据上下文下被判定为没有对应数据的切片器项(可能是由于其他切片器应用的筛选导致的)。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {compareType: GC.Spread.Sheets.ConditionalFormatting.TextCompareType.contains,expected: '*New*'});
table.rowFilter().addFilterItem(2, condition);
table.rowFilter().filter();
console.log(slicer.showNoDataItems());
slicer.showNoDataItems(false);
console.log(slicer.showNoDataItems());
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的showNoDataItems属性。切片器的showNoDataItems属性指定是否显示切片器控制中与连接的PivotTable或数据源中没有关联数据的项目。 |
any
如果未设置值,返回切片器的showNoDataItems属性;否则返回切片器。
▸ showNoDataItemsInLast(value?): any
获取或设置切片器的showNoDataItemsInLast属性。这将决定无数据项(NoDataItems)是放在切片器的开头还是末尾。无数据项指的是在当前筛选器和数据上下文下被判定为没有对应数据的切片器项(可能是由于其他切片器应用的筛选导致的)。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.showNoDataItemsInLast();
console.log(oldValue);
slicer.showNoDataItemsInLast(false);
var newValue = slicer.showNoDataItemsInLast();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的showNoDataItemsInLast属性。切片器的showNoDataItemsInLast属性指定是否在切片器控制列表的末尾显示没有关联数据的项目。 |
any
如果未设置值,返回切片器的showNoDataItemsInLast属性;否则返回切片器。
▸ sortState(value?): any
获取或设置切片器的sortState属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.sortState();
console.log(oldValue);
slicer.sortState(GC.Spread.Sheets.SortState.descending);
var newValue = slicer.sortState();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
SortState |
切片器的sortState属性。切片器的sortState属性指定应用于切片器中项目的当前排序状态,指示它们是否按升序、降序或未排序。 |
any
如果未设置值,返回切片器的sortState属性;否则返回切片器。
▸ sourceName(): string
获取切片器的sourceName属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
console.log(slicer.sourceName());
string
返回切片器的sourceName属性。
▸ startColumn(value?): any
获取或设置切片器的startColumn属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.startColumn();
console.log(oldValue);
slicer.startColumn(10);
var newValue = slicer.startColumn();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的startColumn属性。切片器的startColumn属性指定切片器锚定的起始列索引或工作表中的位置。 |
any
如果未设置值,返回切片器的startColumn属性;否则返回切片器。
▸ startColumnOffset(value?): any
获取或设置切片器的起始列偏移量。起始列偏移量指定切片器左上角相对于其锚定的工作表单元格左上角的水平偏移(沿列方向)。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.startColumnOffset();
console.log(oldValue);
slicer.startColumnOffset(15);
var newValue = slicer.startColumnOffset();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的startColumnOffset属性。切片器的startColumnOffset属性指定切片器锚定的起始列索引或工作表中的位置。 |
any
如果未设置值,返回切片器的startColumnOffset属性;否则返回切片器。
▸ startRow(value?): any
获取或设置切片器的startRow属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.startRow();
console.log(oldValue);
slicer.startRow(10);
var newValue = slicer.startRow();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的startRow属性。切片器的startRow属性指定切片器锚定的起始行索引或工作表中的位置。 |
any
如果未设置值,返回切片器的startRow属性;否则返回切片器。
▸ startRowOffset(value?): any
获取或设置切片器的startRowOffset。startRowOffset指定切片器左上角相对于其所锚定的工作表单元格左上角的垂直偏移量(沿行方向)。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.startRowOffset();
console.log(oldValue);
slicer.startRowOffset(15);
var newValue = slicer.startRowOffset();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的startRowOffset属性。切片器的startRowOffset属性指定切片器锚定的起始行索引或工作表中的位置。 |
any
如果未设置值,返回切片器的startRowOffset属性;否则返回切片器。
▸ style(value?): any
获取或设置切片器的style属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var style = new GC.Spread.Sheets.Slicers.SlicerStyle();
style.wholeSlicerStyle(new GC.Spread.Sheets.Slicers.SlicerStyleInfo('red', 'blue', '16pt Calibri'));
style.headerStyle(new GC.Spread.Sheets.Slicers.SlicerStyleInfo(undefined, 'green'));
style.selectedItemWithDataStyle(new GC.Spread.Sheets.Slicers.SlicerStyleInfo(undefined, undefined, undefined, new GC.Spread.Sheets.LineBorder('pink', GC.Spread.Sheets.LineStyle.double)));
var oldValue = slicer.style();
console.log(oldValue);
slicer.style(style);
var newValue = slicer.style();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
string | SlicerStyle |
切片器的style属性。切片器的style属性指定应用于切片器控制的可视化外观和格式化样式,定义其整体外观和呈现。 |
any
如果未设置值,返回切片器的style属性;否则返回切片器。
▸ toImageSrc(): string
获取切片器的Image src属性。
example
let slicerImageSrc = sheet.slicers.all()[0].toImageSrc();
string
返回切片器的Image src属性。
▸ toImageSrcAsync(): Promise<string>
获取切片器的Image src属性。
example
let slicerImageSrc = await sheet.slicers.all()[0].toImageSrcAsync();
Promise<string>
返回切片器的Image src属性。
▸ visuallyNoDataItems(value?): any
获取或设置切片器的visuallyNoDataItems。NoDataItems表示在当前筛选器和数据上下文中被判定为没有对应数据的切片器项(可能是由于其他切片器应用的筛选)。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.visuallyNoDataItems();
console.log(oldValue);
slicer.visuallyNoDataItems(false);
var newValue = slicer.visuallyNoDataItems();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
boolean |
切片器的visuallyNoDataItems属性。切片器的visuallyNoDataItems属性指定切片器控制中与连接的PivotTable或数据源中没有关联数据的项目。 |
any
如果未设置值,返回切片器的visuallyNoDataItems属性;否则返回切片器。
▸ width(value?): any
获取或设置切片器的width属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.width();
console.log(oldValue);
slicer.width(200);
var newValue = slicer.width();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的width属性。切片器的width属性指定切片器的水平维度或宽度,确定其在x轴上的大小。 |
any
如果未设置值,返回切片器的width属性;否则返回切片器。
▸ x(value?): any
获取或设置切片器的x属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.x();
console.log(oldValue);
slicer.x(100);
var newValue = slicer.x();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的x属性。切片器的x属性指定切片器在工作表中的水平位置或坐标。 |
any
如果未设置值,返回切片器的x属性;否则返回切片器。
▸ y(value?): any
获取或设置切片器的y属性。
example
var spread = new GC.Spread.Sheets.Workbook('ss');
var activeSheet = spread.getActiveSheet();
var dataSource = [
{ Name: "Bob", City: "NewYork", Birthday: "1968/6/8" },
{ Name: "Betty", City: "NewYork", Birthday: "1972/7/3" },
{ Name: "Alice", City: "Washington", Birthday: "2012/2/15" },
];
var table = activeSheet.tables.addFromDataSource("table1", 1, 1, dataSource);
var slicer = activeSheet.slicers.add("slicer", "table1", "Name");
var oldValue = slicer.y();
console.log(oldValue);
slicer.y(100);
var newValue = slicer.y();
console.log(newValue);
| Name | Type | Description |
|---|---|---|
value? |
number |
切片器的y属性。切片器的y属性指定切片器在工作表中的垂直位置或坐标。 |
any
如果未设置值,返回切片器的y属性;否则返回切片器。