non empty row count returns 'Zero'

Posted by: lier on 8 September 2017, 1:56 pm EST

  • Posted 8 September 2017, 1:56 pm EST

    Hi,


     I am Adding one line of data in farpoint spread (Say row 1). When i run the statement "FarpointSpread.Sheet[0].nonemptyrowcount" it return 0 instead of 1.


    i am using farpoint 2.0.0.0 .is there any otherway to find non empty row count of the spread?

  • Replied 8 September 2017, 1:56 pm EST

    Lier,

    I have tested the same on a bound SpreadSheet with 4.0.2010.2005 and could get the correct count of rows with data. Also if you check the intellisense of NonEmptyRowCount it shows the following information as follows: Gets a value that is one more than the index of the last row on the sheet containing data. Try upgrading to the latest version of Spread.

    Thanks

  • Replied 8 September 2017, 1:56 pm EST

    Hi, 


    this occurs only when a datasource to the spread is assigned.


    basically i have assigned a datasource to the spread that contain no data.Now when i add data manually to the spread and run the non empty row count it returns 0.


    Is there any alternative to find the non empty row count when a data source to the spread is assigned.

  • Replied 8 September 2017, 1:56 pm EST

    Hello,


    Using the latest build of Spread I manually updated the data in the Spread Sheet assigned to DataSource with no Rows.


    I used FpSpread1.Sheets(0).NonEmptyRowCount to find non Empty Rows, it gives the correct number. I would suggest you to please upgrade and test this issue with the latest build(v4.0.2010.2005) of Spread for Windows.You can download the trial version from ftp://ftp.fpoint.com/SpreadWinForms4/. Let me know if you are still able to replicate the same.


     


    Thanks,


     

Need extra support?

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

Learn More

Forum Channels