-
Notifications
You must be signed in to change notification settings - Fork 807
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
Addresses in named ranges do not become invalid when the range itself is deleted #880
Open
1 of 3 tasks
Comments
Pankraty
added a commit
to Pankraty/ClosedXML
that referenced
this issue
May 29, 2018
2 tasks
Perfect time to refactor that |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Read and complete the full issue template
Do you want to request a feature or report a bug?
If you are logging a possible bug or feature request, please test with the latest development build first.
Version of ClosedXML
0.93
What is the current behavior?
Say, we have a named range referring to the range
A1:B2
. If rows from 1 to 5 are deleted the named range starts to refer toA1:B1
. If, instead, first two columns are deleted the named range becomesA1:A2
.What is the expected behavior or new feature?
The named range should become invalid: e.g.
Sheet1!#REF!
.Did this work in previous versions of our tool? Which versions?
No
Notes
This issue should be addressed together with #686.
Also, I noticed that when multiple rows are deleted (e.g.
ws.Rows(1, 100).Delete();
) the formula shifting is performed for every single row. This may be improved by doing a single shift for the specified number of rows. Same is true for columns.Reproducibility
Code to reproduce problem:
The text was updated successfully, but these errors were encountered: