Rows Added Hidden

Rows Added Hidden

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

• 

  danilo.mario

  • Post Options:
  • Link
    Copy

  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

  

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  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