Skip to content

NameFormula Has Changed #1315

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

#

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Jump to bottom
Open
st-dotnet opened this issue Feb 22, 2024 · 1 comment · May be fixed by #1999
Open

NameFormula Has Changed #1315

st-dotnet opened this issue Feb 22, 2024 · 1 comment · May be fixed by #1999
Assignees
@JanKallman
Labels
enhancement New feature or request needs investigation
Milestone
EPPlus 8.1

Comments

@st-dotnet
Copy link

Hi,

Recently I was using the NameFormula like this
ExcelNamedRange name = package.Workbook.Names.Add("Test", worksheet.Cells[3, 3]);
name.NameFormula = "#REF!";
name.NameFormula = "#REF!";
But now after upgradation, I am getting this error
'ExcelNamedRange' does not contain a definition for 'NameFormula' and no accessible extension method 'NameFormula' accepting a first argument of type 'ExcelNamedRange' could be found (are you missing a using directive or an assembly reference?)

PLease help me with this issue
@JanKallman
Copy link
Contributor

Hello,
The NameFormula property is internal, so you can not use it.
I suggest you remove the name and add it again with the new value for now.
We will look at an better solution to alter the name's formula/value for the future.

@JanKallman JanKallman added the enhancement New feature or request label Sep 27, 2024
@JanKallman JanKallman self-assigned this Mar 19, 2025
@OssianEPPlus OssianEPPlus moved this from Backlog to In progress in Epplus Enhancements May 5, 2025
@OssianEPPlus OssianEPPlus added this to the EPPlus 8.1 milestone May 6, 2025
@AdrianEPPlus AdrianEPPlus linked a pull request May 12, 2025 that will close this issue
Feature/name formula #1999
Open
4 tasks
# for free to join this conversation on GitHub. Already have an account? # to comment
Assignees

@JanKallman JanKallman

Labels
enhancement New feature or request needs investigation
Projects
Epplus Enhancements
Status: In progress
Milestone
EPPlus 8.1
Development

Successfully merging a pull request may close this issue.

Feature/name formula EPPlusSoftware/EPPlus
3 participants
@JanKallman @st-dotnet @OssianEPPlus