How to restrict the row count in spread designer settings

Tagged: ,

  • paramaguru21 6 months, 1 week ago

    Actually I have about “2000″ records in my DB in which i want to display only “200″ records in the spread.But u when i retrieve it shows more than “200″ records in the cell .
    I Have tried the “Restrict Row-count” property in spread settings it doesn’t work any other idea for setting “Set the Maximum row count” for the rows in my spread

    Thanks in Advance

    You must be logged in to view attched files.
  • 23p
    GinaDan23p 6 months, 1 week ago


    Restrict Rows prevents the user from typing data in a row beyond the one that contains data. It does not remove or hide rows. You could try setting visible to false for the rows you want to hide. If you are binding to a datasource, then all the data will be shown by default. The Row Count option should set the maximum number of rows. In code you can set fpSpread1.Sheets[0].Rows.Count.

    Thanks, Gina

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to create new topics.