SSpread.UserResizeRow Property
Sets whether the width of the column can be changed with the mouse.
Before setting this property, use the Row property to specify the column of interest.
Specify the following values. The initial value is $UserResizeDefault .
| Constant | Value | Explanation |
|---|---|---|
| $UserResizeDefault | 0 | Use the setting of the UserResize property |
| $UserResizeOn | 1 | Can be changed |
| $UserResizeOff | 2 | Cannot be changed |
This property allows / prohibits column width changes for specific columns. The entire spreadsheet is set with the UserResize property. Each row is set with the UserResizeCol property.
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;
Related item UserResize , UserResizeCol property