I'm using XlsIO to read the content of a cell that is using "INDIRECT" Formula. I've attached the excel file with the formula in the cell B2. The formula is correctly displayed when I open the file using Excel. But when I use the XlsIO lib to open in a WinRT application, the calculatedvalue of the cell is #N/A...
Could you please help me to resolve this problem ?
Here is code sample of my test:
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
StorageFolder local = Windows.Storage.ApplicationData.Current.LocalFolder;
StorageFile outFile = await local.GetFileAsync("Sample.xlsx");
IWorkbook workbook = await application.Workbooks.OpenAsync(outFile);
IWorksheet sheet = workbook.Worksheets;
String test = sheet.Range["B2"].CalculatedValue;