Skip to content

NameFormula Has Changed #1315

Open
@st-dotnet

Description

@st-dotnet

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

Activity

JanKallman

JanKallman commented on Feb 23, 2024

@JanKallman
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.

self-assigned this
on Mar 19, 2025
moved this from Backlog to In progress in Epplus Enhancementson May 5, 2025
added this to the EPPlus 8.1 milestone on May 6, 2025
linked a pull request that will close this issueFeature/name formula #1999on May 12, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Type

No type

Projects

Status

In progress

Relationships

None yet

    Development

    Participants

    @JanKallman@st-dotnet@OssianEPPlus

    Issue actions

      NameFormula Has Changed · Issue #1315 · EPPlusSoftware/EPPlus