Rows Added Hidden

Posted by: danilo.mario on 28 March 2019, 4:39 am EST

  • Posted 28 March 2019, 4:39 am EST

    I have a nidificate loop in client side

    dim Riga as integer=-1

    for i=1 to 10

    Riga=Riga+1
    lista.sheets(0).rowcount=riga+1
    lista.sheets(0).cells(riga,0).text="Hello"+i.tostring

    for k=1 to 5

    Riga=Riga+1
    lista.sheets(0).rowcount=riga+1
    lista.sheets(0).cells(riga,0).text="Hello Cicli"+i.tostring+" "+k.tostring


    next
    next

    At the end of the cycle i see only the first 6 rows, but if i download the spread in pdf format , the pdf document is correct

    The Spread Version is 9

  • Marked as Answer

    Replied 29 March 2019, 1:20 am EST

    Hello,

    The code you have shared looks like server side code and not client side code. I am not able to replicate the issue at my end. I have used the code as follows:

    If Not IsPostBack Then
    Dim Riga As Integer = -1

    For i = 1 To 10

    Riga = Riga + 1
    FpSpread1.Sheets(0).RowCount = Riga + 1
    FpSpread1.Sheets(0).Cells(Riga, 0).Text = "Hello" + i.ToString

    For k = 1 To 5

    Riga = Riga + 1
    FpSpread1.Sheets(0).RowCount = Riga + 1
    FpSpread1.Sheets(0).Cells(Riga, 0).Text = "Hello Cicli" + i.ToString + " " + k.ToString


    Next
    Next
    End If

    It loads 10 rows initially, please refer to the attached image.

    Please test the attached sample project and let me know if you can still replicate the issue.

    Thanks,
    Deepak Sharma
    WebApplication3.zip
Need extra support?

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

Learn More

Forum Channels