SSpread.UserResize Property

Set whether to allow the mouse to change the column width and row height.

Specify the following values. The initial value is $UserResizeBoth .

Constant	Value	Explanation
$UserResizeNone	0	Column / row size cannot be changed
$UserResizeColumns	1	Columns can be resized
$UserResizeRows	2	Row resizing is possible
$UserResizeBoth	3	Column / row size can be changed

This property sets the settings for the entire spreadsheet. The UserResizeCol property is used to set each column, and the UserResizeRow property is used to set each row .

Example of use

/ * Prohibit resizing * /
UserResize = $ UserResizeNone;
/ * Resize permission only for the second column * /
Col = 2;
UserResizeCol = $ UserResizeOn;
/ * Resize permission only for the 3rd line * /
Row = 3;
UserResizeRow = $ UserResizeOn;