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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

INDIRECT formula in excel

Thread ID:

Created:

Updated:

Platform:

Replies:

118478 Mar 11,2015 05:48 PM UTC Mar 12,2015 10:04 AM UTC WinRT 1
loading
Tags: XlsIO
Benjamin Bozou
Asked On March 11, 2015 05:48 PM UTC

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 [Syncfusion]
Replied On 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.

Regards,

Sudha R


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;