How to restrict the size of a particular column in Farpoint Spreadsheet ?

Posted by: venki9 on 8 September 2017, 1:03 pm EST

  • Posted 8 September 2017, 1:03 pm EST

    Can any one help me regarding this question..


    How to restrict the size of a particular column in Farpoint Spreadsheet ?


     


    Regards,


    Venki

  • Replied 8 September 2017, 1:03 pm EST

    Venki -

    You can set the width of the column and then prevent it from beign resized...

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


  • Replied 8 September 2017, 1:03 pm EST

    Venki,


    In addition to what Bob stated, if you want to keep the Resizable property turned on, you can write code in the ColumnWidthChanging event to cancel the event if the column is being set to a size you do not want.

     
    			if (((FarPoint.Win.Spread.ColumnWidthChangeExtents)e.ColumnList[0]).FirstColumn == 2 && e.Width > 200)
    e.Cancel = true;
     
  • Replied 8 September 2017, 1:03 pm EST

    Thanking you
Need extra support?

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

Learn More

Forum Channels