Rows Added Hidden

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

    • Post Options:
    • Link

    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

  • Posted 29 March 2019, 1:20 am EST - Updated 30 September 2022, 2:47 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