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 1<SUP>st</SUP> row, 2nd row and then if you want to enter value directly in 7<SUP>th</SUP> row, it should not allow.<o:p></o:p>

    <FONT face=Arial size=2><SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Arial;">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.<o:p></o:p></SPAN></FONT>

    <FONT face=Arial size=2><SPAN style="FONT-SIZE:10pt;FONT-FAMILY:Arial;"><o:p> </o:p></SPAN></FONT>

  • Replied 8 September 2017, 1:46 pm EST


    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.



  • Replied 8 September 2017, 1:46 pm EST


    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