We recently encountered a challenge where if we created cells with formulas containing names that don’t exist, Cell.Formula would display the name as ‘workbookName’!name.
For example, if the workbook is “Workbook Name.xlsx”, and the formula of a cell when seen through excel is “=some_name_that_exists + some_name_that_doesnt_exist”, getting the cell’s formula using aspose returns:
=some_name_that_exists + ‘Workbook Name.xlsx’!some_name_that_doesnt_exist
We would like to know if this is expected or a bug. If it’s expected, what are the reasons behind this design decision?
In addition, we found that these names that don’t exist do not show up in Excel’s names manager, but Aspose will still find and create these names with refers to being null.