We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

INDIRECT formula in excel


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

1 Reply

SR Sudha Ramachandran Syncfusion Team March 12, 2015 10:04 AM UTC

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.


Sudha R

Live Chat Icon For mobile
Up arrow icon