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 <span id="pagetitle">NonEmptyRowCount it shows the following information as follows: </span><span id="pagetitle">Gets a value that is one more than the index of the last row on the sheet containing data</span>. 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.


    <FONT size=2>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.</FONT>


     


    Thanks,


     

Need extra support?

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

Learn More

Forum Channels