SSpread.UserResizeCol Property
Sets whether the width of the column can be changed with the mouse.
Before setting this property, use the Col 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 UserResizeRow 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 , UserResizeRow property