In our application a lot of named ranges are created dynamically. Using MS Excel we could add them using a R1C1-formula defining the range. This doesn't seem to work using Aspose.
I use the following code to add the names:
pWorkbook.Worksheets.Names("TestName").RefersTo = "=Sheet1!R2C10"
When the resulting file is opened in MS Excel it shows in refers to as:
Note the single quotes. If you open the dialog "Define Name" in Excel (CTRL + F3) and select this named range and click on OK, a message box shows stating the formula contains an error.
Is there another way to add named ranges using R1C1 notation (or a function that converts R1C1 formula's to 'normal' formula's)?