I have a template file with a user defined function. I'm using Aspose to generate a multi-page workbook, by copying the sheets in the template file. I've written a custom function that handles the calculation for the UDF within Aspose. The problem is that, when the copied sheets are opened in Excel the cells referencing the UDF show a #NAME error. The UDF is there, and in fact if I go to any of the cells referencing the UDF and simply delete and add the last character in the line, the UDF is recognized and calculated.
Note that if I leave the template sheets in the workbook, they open and correctly display the calculated value. Only the copied sheets display the #NAME error.
Rick