How to Find a Table using a Specified Cell

Here is one way you can identify and manipulate a table without the table's name. To begin, we can set up the example table and formatting:

//This example uses the find method //Initialize spreadsheet window.onload = function () { var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), {sheetCount: 1}); var activeSheet = spread.getActiveSheet(); //Table and cell values/formatting activeSheet.setRowHeight(4, 50); activeSheet.setColumnWidth(4, 100); activeSheet.getCell(6,0).text("Move identified table below here:") 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");

As seen above, the table name is "Table1". However, spreadsheets can grow to become complex, and you may have many similarly-named tables. We can trigger a button-clicked event to use the tables.find function of the TableManager class. In this example, we use tables.find on one of the known cells of the table to move the entire table:

//button var b1 = new GC.Spread.Sheets.CellTypes.Button(); activeSheet.setCellType(4,4, b1, GC.Spread.Sheets.SheetArea.viewport); b1.text('Click here!'); //click event spread.bind(GC.Spread.Sheets.Events.ButtonClicked, function (e, args){ if (b1 instanceof GC.Spread.Sheets.CellTypes.Button) { var table = activeSheet.tables.find(0,0); activeSheet.tables.move(table, 7,0); } }); };