-
Notifications
You must be signed in to change notification settings - Fork 272
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Copying a worksheet to a new workbook does not copy relevant global names #345
Comments
EPPlus don't copy workbook defined names when using a worksheet as template today. For now you will have to copy any defined name on the worksheet level yourself. |
Great, thanks. Just to clarify, as I think there's two possible things here:
In this issue I'm just talking about number 1 (which I think should just mean checking all the workbook's defined names?). I think number 2 could be quite slow and wouldn't be in line with what Excel does anyway. |
Yes, I see your point. I'll have a look at it for a future version. |
Hi, I think I've found another bug with copying worksheets (sorry).
If I copy a worksheet to a new workbook, and that worksheet contains cells that are 'global' names (i.e. names defined at the workbook level), EPPlus doesn't copy those names. This means that any formula on the worksheet that references that name will be broken on the copied sheet.
If I try the same thing in Excel, the global names on the sheet do get copied.
The text was updated successfully, but these errors were encountered: