Row/Column Resize - disable

Posted by: john-shugart on 8 September 2017, 1:43 pm EST

  • Posted 8 September 2017, 1:43 pm EST

    How can I keep the user from being able to resize the columns or rows on my FpSpread?

    Thanks in advance,


  • Replied 8 September 2017, 1:43 pm EST


    You can set the Resizable property of the Column/Row you want to not size to False.

    <FONT size=2>

    FpSpread1.Sheets(0).Columns(-1).Resizable = </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>False

    </FONT></FONT><FONT size=2>

    FpSpread1.Sheets(0).Rows(-1).Resizable = </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>False

Need extra support?

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

Learn More

Forum Channels