Issue insert sheet and move sheet in workbook
Posted: Thu Mar 26, 2015 3:17 am
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.
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.