Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

当  options.resizeZeroIndicator 属性设置为 Enhanced 时,你可以重设宽度为 0 的列和高度为 0 的行的大小。

示例代码

以下代码设置了行或者列是否可以被重设大小。

Code Block
languagejs
titleJavaScript

...

Copy Code

activeSheet.setRowResizable(3,false,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.setColumnResizable(3,false,GC.Spread.Sheets.SheetArea.viewport);
activeSheet.getRange(1, -1, 1, -1, GC.Spread.Sheets.SheetArea.viewport).resizable(false);
activeSheet.getRange(-1, 1, -1, 1, GC.Spread.Sheets.SheetArea.viewport).resizable(false);

...

 

示例代码

以下代码仍然设置了行或者列是否可以被重设大小。

Code Block
languagejs
titleJavaScript

...

Copy Code

activeSheet.setRowCount(10);
activeSheet.setColumnCount(7);
activeSheet.setValue(0, 0,"Western");
activeSheet.setValue(0, 1,"Western");
activeSheet.setValue(0, 2,"Western");
activeSheet.setValue(1, 0,"A");
activeSheet.setValue(1, 1,"B");
activeSheet.setValue(1, 2,"C");
activeSheet.setColumnResizable(0,true,

...

 GC.Spread.Sheets.SheetArea.colHeader);
activeSheet.setRowResizable(0,true,

...

 GC.Spread.Sheets.SheetArea.rowHeader);
alert(activeSheet.getColumnResizable(0));
alert(activeSheet.getRowResizable(0,

...

 GC.Spread.Sheets.SheetArea.rowHeader));

...

 

另见

setColumnResizable Method
setRowResizable Method