Hi,
I'm trying to update an Excel file with extenal references. But I get NaN after calling
Calculate() on the worksheet. Here is my code:
var excelApplication = _serviceProvider.GetRequiredService<IApplication>();
using var s = File.Open(@"c:\somefile.xlsm", FileMode.Open);
var workbook = excelApplication.Workbooks.Open(s);
var sheet = workbook.Worksheets[0];
var num = sheet["A1"].FormulaNumberValue;
Debug.WriteLine(num.ToString("N0")); // => 10000 (value of A1 is based on external workbook)
sheet.Calculate();
num = sheet["A1"].FormulaNumberValue;
Debug.WriteLine(num.ToString("N0")); //=> NaN
How do I update the values for the external workbooks?
The external workbook also has an external reference:
somefile.xlsm =>
somefile2.xlsm =>
somefile3.xlsm
Is it possible to reflect changes made in somefile3.xlsm in somefile.xlsm using Syncfusion.XlsIO ?
