Restrict user to change the column and row width

Posted by: lier on 8 September 2017, 1:48 pm EST

  • Posted 8 September 2017, 1:48 pm EST

    How Can i restrict user to change the column and row width ?
  • Replied 8 September 2017, 1:48 pm EST

    Hello Lier,

    You can allow the user to readjust the size of a row or column in the sheet. Set the Resizable property for the row to allow the user to resize rows and the Resizable property for the column to allow the user to resize columns. The same can be done as follows:

            FpSpread1.Sheets(0).Columns(0).Resizable = False
            FpSpread1.Sheets(0).Rows(0).Resizable = False

    Thanks

  • Replied 8 September 2017, 1:48 pm EST

    Thanks.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels