EPPlus icon indicating copy to clipboard operation
EPPlus copied to clipboard

NameFormula Has Changed

Open st-dotnet opened this issue 1 year ago • 1 comments

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

st-dotnet avatar Feb 22 '24 15:02 st-dotnet

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 avatar Feb 23 '24 07:02 JanKallman