When I tried to copy a worksheet with a range defined* to another workbook the range was not copied correctly.
This is because when I do the copy action only the namedranges from that worksheet is copied to the collection which I can read with objWorkbook.Worksheets.getNamedRanges(), while the ranges from the other pages are copied to the objWorkbook.Worksheets.Names collection.
So when I do the following:
Open Workbook: Names.Count = 7, getNamedRanges.Length = 7
Copy worksheet from workbook with only one sheet: Names.Count = 8, getNamedRanges.Length = 8
Copy worksheet from workbook with multiple sheets and ranges: Names.Count = 19, getNamesRanges.Length = 9
Copy another worksheet from this workbook: Names.Count = 19, getNamesRanges.Length = 9
*My source workbook contained:
3 worksheets, first sheet contained 2 namedranges, second also contained 2 namedranges and the third contained 1 namedrange. None of the namedranges has the same name.
My target workbook contained:
Multiple worksheets with multiple namedranges, except for the worksheets which are targeted to be overwritten by the copied worksheets.
Could you please tell me what I do wrong, or fix it if this is a correct bug :)?
My Aspose.Cells version is for .Net and is version 220.127.116.11