I have an issue with using the function WorkBook.Combine when the 2nd workbook has an IFERROR function within a cell. I am using .NET 3.5, Aspose.Cells 6.0.1 and Excel 2010. The first and second workbooks are created from template Excel files replacing some values. I have tried using Combine with both xls and xlsx files. The issue is that when I use the Combine method, the IFERROR function does not compute but instead I get a _xlfn prefix in front of the function. The interesting thing is that it works fine if I am not using the Combine function. Googling this resulted in saying that this usually occurs if you are using an older version of Excel (earlier than 2007).
I was able to work around this for now by using IF(ISERROR(),,) instead. However, this syntax is much more cumbersome.
Can you please investigate the issue and let me know if you can fix it?