Issue insert sheet and move sheet in workbook

[crazymanvn]

Hello,

I'm using XE7 and XLSReadWriteII 5.20.42. I want copy sheet in a workbook to backup before edit it. But have troubles below.

I used TXLSWorkbook.Insert(AIndex, ACount) method to insert a new sheet, other sheets have cells with fomular link from cell of sheet in other excel file become #NAME? But when I use TXLSWorkbook.Add method is not problem.

When I use TXLSWorkbook.Manager.Worksheets.Move(CurIndex, NewIndex) method, only sheet name changed but content of sheet not change.

How to fix it ? Thanks.

[larsa]

Hello

Sorry, it's not possible to copy the content of worksheets.