Spread.Sheets Documentation
resize Method
The table or the table name.
The new table range. The headers must remain in the same row, and the resulting table range must overlap the original table range.
Changes the table size.
Syntax
var instance = new GC.Spread.Sheets.Tables.TableManager(sheet);
var value; // Type: any
value = instance.resize(table, range);
function resize( 
   table : undefined,
   range : Range
) : any;

Parameters

table
The table or the table name.
range
The new table range. The headers must remain in the same row, and the resulting table range must overlap the original table range.
Example
This example resizes the table.
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");

$("#button1").click(function () {
var table  = activeSheet.tables.find(0,0);
activeSheet.tables.resize(table, new GC.Spread.Sheets.Range(0,0,4,4));
    });
See Also

Reference

TableManager type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.