NameFormula Has Changed
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
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.