GrapeCity Forums

I have a web page where I create a spreadsheet. Then I have some classe I use performing different tasks for the sheet. The first class I call:

Public Function getDataHTMLAndXLSHeader(Optional ByVal forQuestions As String = "", ...Optional ByRef fpS As FarPoint.Web.Spread.FpSpread = Nothing, ...) As String

Everything is working ok regarding adding new rows and refering to these. Then I call another class to fill the data:

Public Function getDataHTMLAndXLS(Optional ByVal forQuestions As String = "", ...Optional ByRef fpS As FarPoint.Web.Spread.FpSpread = Nothing, .....) As String

now I can add rows with fpS.Rows.Count = row + answerCount + 1 but I cannot refer to the added rows even though the fpS.Rows.Count shows the right number of rows. I get an index error. I cannot figure out what I'm doing wrong and this behaviour came along when I splitted one class into two. I can add and refer to the new rows anywhere else but in the second class. Any ideas?

Hello,

I am not sure what you are seeing. Could you post small zipped project reproducing this behavior for us to debug?

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

the problem seems to be something else. I do not understand why the following happens (seems like a very simple and straight forward code):

With fpSpread.Sheets(0)
     .Rows.Count = ViewState("AnswerCount")
      .PageSize = ViewState("AnswerCount")
      .Cells(row, 0, .PageSize - 1, .ColumnCount - 1).CellType = generalDataCell
      .Cells(row, 0, .PageSize - 1, .ColumnCount - 1).HorizontalAlign = HorizontalAlign.Center
End With

Immediate window results on the first .cells line:

?fpSpread.Sheets(0).Rows.Count
689
?fpSpread.Sheets(0).PageSize
689
?row
2

Exception on the first .cells line:

System.IndexOutOfRangeException: Invalid row index: 2 (must be between -1 and 1).

Hi, 

I am not able to replicate the issue using your code. The code that you've sent is working fine on my side. Is it possible for you to provide a working sample, that I can run on my computer to replicate this issue?

Regards, 

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

Attached a zipped project. NOTE! the bin folder is missing with the FP components

Hello Mikko, 

Referring to your sample application, you are getting the exception because in the ibSaveExcel_Click event, you are calling the fpSpread.Dispose() which is removing the fpSpread object. In the ibExcelExportConfirm_Click event when you are setting the .Cells(row, 0, .PageSize - 1, .ColumnCount - 1).CellType = generalDataCell, the fpSpread is not initialized. 

To resolve the issue, you may either initialize the fpSpread object before calling the .Cells(row, 0, .PageSize - 1, .ColumnCount - 1).CellType = generalDataCell. Or you may comment out the fpSpread.Dispose() statement. 

Regards, 

---

Scott S.
Product Manager, Spread ASP.NET
GrapeCity FarPoint

oh sh...t, sorry for taking your time. Never debugged that after restructuring my software. Sorry for taking your time