Open
Description
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
Metadata
Metadata
Assignees
Labels
Type
Projects
Status
Activity
JanKallman commentedon Feb 23, 2024
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.