Can't Add Sheets to XLBookMBS

[Julia_Truchsess]

I want to let users reorder and delete sheets in an XLBookMBS. I put the sheets into the RowTags of a ListBox where the user can manipulate them, then on Save I make a new XLBookMBS and try to add the stored sheets into it with AddSheet. On the first pass through the loop newbook is ok, but on the second pass it has the error “index is out of range”. Tried it with InsertSheet and got the same result.

newbook = new XLBookMBS(True)
newbook.SetKey(license)

Dim sheet As XLSheetMBS

for row As Integer = 0 to Listbox1.LastRowIndex
  sheet = Listbox1.RowTagAt(row) // Cast it
  call newbook.AddSheet(sheet.Name, sheet) // Second parameter is "InitSheet" for copying
Next

Shouldn’t AddSheet perform an “append” operation, i.e. without regard to any index?

[Christian_Schmitz]

Can you please have the result of AddSheet go in a variable and check whether this is nil?

And where do you see the error message?

[Julia_Truchsess]

@Christian_Schmitz

Can you please have the result of AddSheet go in a variable and check whether this is nil?

On the first pass, an XLSheetMBS is returned. On the second pass, Nil is returned.

@Christian_Schmitz

And where do you see the error message?

In the debugger:

[Christian_Schmitz]

I am not sure what could cause this.
The XLBookMBS object for the existing sheet object is still in memory?

I tried an example here and it works.
So maybe you like to work on a sample project to show the problem?

[Julia_Truchsess]

@Christian_Schmitz

The XLBookMBS object for the existing sheet object is still in memory?

Yes it’s in a window property.

@Christian_Schmitz

So maybe you like to work on a sample project to show the problem?

OK, will do, thanks.

[Julia_Truchsess]

From @Christian_Schmitz via PM:

"LibXL currently doesn’t allow to copy sheet from one book to another.
So AddSheet Parameter must taken from same book.

And we have a CopySheet method, that may help."