INDIRECT formula in excel

[Benjamin Bozou]

Hi,

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 ?

Regards

Benjamin

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[0];
            sheet.EnableSheetCalculations();
            String test = sheet.Range["B2"].CalculatedValue;
            Debug.WriteLine(test);

[Sudha Ramachandran]

Hi Benjamin,

 

Thank you for using Syncfusion products.

 

We are unable to reproduce the issue with the provided code snippet. It would be grateful for us to investigate further on this if you could share us the following details, so as to assist you with a prompt solution.

 

1.       Input template used which you missed to attach.

2.       Your working version of XlsIO.

 

Please let us know if you have any queries.

Regards,

Sudha R