Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Renaming a worksheet can causes formulas to become corrupt, if the name contains spaces. #1796

Open
JanKallman opened this issue Dec 30, 2024 · 0 comments
Open

Renaming a worksheet can causes formulas to become corrupt, if the name contains spaces. #1796

JanKallman opened this issue Dec 30, 2024 · 0 comments
Assignees
@JanKallman
Labels
bug Something isn't working

Comments

@JanKallman
Copy link
Contributor

EPPlus does not add single quoutes (') around a worksheet name in a formula.
Problem:
Worksheet name "Sheet1".
Formula = "Sheet1!A1"
Rename to "Sheet 1"

Formula should be:
Formula = "'Sheet 1'!A1"
@JanKallman JanKallman self-assigned this Dec 30, 2024
@JanKallman JanKallman added the bug Something isn't working label Dec 30, 2024
JanKallman added a commit that referenced this issue Dec 30, 2024
@JanKallman
Fixes issue #1796 and #1797
e820aeb
@JanKallman JanKallman changed the title Renaming a worksheet can causes formulas to become corrupy, if the name contains spaces. Renaming a worksheet can causes formulas to become corrupt, if the name contains spaces. Dec 30, 2024
@JanKallman JanKallman mentioned this issue Dec 30, 2024
Merged
swmal pushed a commit that referenced this issue Jan 3, 2025
@JanKallman
Fixes issue #1796 and #1797 (#1798)
c9cc6b5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@JanKallman JanKallman

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@JanKallman