1. When Copying the worksheet from one workbook to another workbook the named ranges present in the worksheet are not copied:
We have AsposeTest_Original.xls which has about 10+ ranges defined. When I copy a worksheet into another workbook the corresponding, the worksheet is copied into the new workbook. But the defined ranges are not present. The copied workbook which is saved as AsposeTest_Original_workbook_copy.xls does not have the named range definitions.
Attachment with code: worksheet_copy_workbook.zip (inside reference_code.zip)
2. Issue with NamedRange.setText method
There were a set of named ranges defined in a workbook. We did a mass rename of all the named range names (by appending it with a string constant) using the NamedRange.setText() method. After renaming the ranges, when we tried to lookup for the range by range name, it does not fetch the range object.
Attachment with code: rename_range_issue.zip (inside reference_code.zip)