Enumeration: TableRemoveOptions

Sheets.Tables.TableRemoveOptions

Specifies what data is kept when removing the table.

example

activeSheet.tables.add("Table1", 0, 0, 3, 3, GC.Spread.Sheets.Tables.TableThemes.dark1);
activeSheet.getCell(0,0).text("Name");
activeSheet.getCell(0,1).text("Value");
activeSheet.getCell(0,2).text("T/F");
activeSheet.getCell(1,0).text("AW");
activeSheet.getCell(1,1).text("5");
activeSheet.getCell(1,2).text("T");
//button click
$("#button1").click(function () {
     var table  = activeSheet.tables.find(0,0);
     activeSheet.tables.remove(table, GC.Spread.Sheets.Tables.TableRemoveOptions.keepData);
});

Table of contents

Enumeration members

• keepData
• keepStyle
• none

Enumeration members

keepData

• keepData = 1

Keeps values.

keepStyle

• keepStyle = 2

Keeps styles.

none

• none = 0

Removes data and styles.