Query in Adding Rows RowWise

Posted by: pussun0106 on 8 September 2017, 1:46 pm EST

  • Posted 8 September 2017, 1:46 pm EST

    I have a query in Farpoint Spread 4.0.


    Once you enter value in 1st row, 2nd row and then if you want to enter value directly in 7th row, it should not allow.


    Value should be allowed to enter only row wise. How can we do it? Is there a way. If it is please let me know ASAP.


     

  • Replied 8 September 2017, 1:46 pm EST

    Hello,

    Regarding your query, you may try locking that particular row where you do not want any data to be entered. E.g. If you wish to lock the Row number 7, lock the same using:

    FpSpread1.Sheets(0).Rows(6).Locked = True

    Hope this helps.

    Thanks, 

    Suresh

  • Replied 8 September 2017, 1:46 pm EST

    Hello,


    If you know the row you want to lock, then the code provided to you woudl work. If you want to automatically lock all rows that are beyond one away from the last row with data, then you can use the RestrictRows property of the Spread.

Need extra support?

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

Learn More

Forum Channels