I'm working on an application that creates Excel-files. Most of the time several workbooks are created. Those workbooks are linked to eachother using formula's in cells pointing to specific named ranges in the linked workbook (eg. <='c:\wbook1.xls'!SomeNamedRange>).
During implementation of the Aspose.Cells component, the linking failed. After some more investigation it appears Aspose is adding some extra single-quotes to the formula. So the formula above will result in <=''C:\WBOOK1.XLS'!SOMENAMEDRANGE'> (behind the equal-sign are 2 single-quotes). This is not a correct formula in Excel so the output in this cell will always be "#NAME?".
After some searching on this site I found an article which shows how to add external formula's. I tried this example and it worked. The only difference with the example is the formula points to a specific sheet <='c:\wbook1.xls'Source!A1>. So those formula's do work, but a formula without a sheet reference won't work. All my named ranges are global so I am reluctant to use a sheet reference.
Could you look into this?
Attached is a sample project showing the problem.
Thanks in advance,