We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Sheet copying keep named ranges valid in destination sheet

Hello,

when I copy a sheet into another, named ranges of source sheet are copied into destination sheet and those (named ranges) already existing into destination sheet aren’t deleted.
Is this the expected behavior?
We were waiting for deleting the previous named ranges.

Hi,


I think this should be MS Excel behavior as well, I think you need to remove the previous named ranges by yourself (if you want) via Aspose.Cells APIs. Could you try to perform the steps manually in MS Excel to check if you see anything different with the final file comparing with the output file generated by Aspose.Cells APIs? If you find Aspose.Cells behaves differently, kindly provide us your template file(s) and paste your sample code to reproduce the issue, we will check it soon.

Thank you.