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

Calculation Named Range issue #296

Closed
bryancolligan opened this issue Dec 19, 2017 · 2 comments · Fixed by #4096
Closed

Calculation Named Range issue #296

bryancolligan opened this issue Dec 19, 2017 · 2 comments · Fixed by #4096

Comments

@bryancolligan
Copy link

This is:
a bug report

What is the expected behavior?

Name Range should be able to reference another sheet in the file.

What is the current behavior?

"!" in named range errors out

What are the steps to reproduce?

reference a named range in a formula calculation in a separate sheet.

Which versions of PhpSpreadsheet and PHP are affected?

1
@stale
Copy link

stale bot commented Feb 17, 2018

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

@stale stale bot added the stale label Feb 17, 2018
@stale stale bot closed this as completed Feb 24, 2018
@oleibman
Copy link
Collaborator

Reopening. Expect a fix in a day or two.

@oleibman oleibman reopened this Jul 15, 2024
@stale stale bot removed the stale label Jul 15, 2024
oleibman added a commit to oleibman/PhpSpreadsheet that referenced this issue Jul 16, 2024
@oleibman
Reference to Defined Name Specifying Worksheet Name
1c333d1 
Fix PHPOffice#296, another entry in our magical history tour (closed as stale in 2018). Excel allows you to use a name defined on another worksheet by prefixing the sheet name, even when the scope of the defined name is its worksheet rather than the entire workbook.
@oleibman oleibman mentioned this issue Jul 16, 2024
Merged
11 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Reference to Defined Name Specifying Worksheet Name oleibman/PhpSpreadsheet
2 participants
@bryancolligan @oleibman