Hi,
I'm using Excel controls to access cell values from a spreadsheet. The application hangs when trying to get the cell value. The cell copntains a fairly complex formula. Here is the code that hangs:
var m_CurrentDirectory = Directory.GetCurrentDirectory();var m_TemplatePath = Path.Combine(m_CurrentDirectory, @"Resources\GfeTemplate.xls");var m_Workbook = Workbook.Load(m_TemplatePath);
/* This line will cause the app to hang. * I suspect it has something to do with the formula in the cell. */var value = m_Workbook.Worksheets["GFE"].GetCell("D87").Value;
The issue appears to be with the formula in the cell. I can do this fine on other files, it is just this one file that's causing the problem.
Has anyone seen anything similar?
Thaks,Matei
Thanks for the reply. The assembly version is 10.2.20102.1004 (Infragistics3.Excel.v10.2). I've attached an Excel file that exhibits the issue. Simply trying to read the value of the D87 cell on the GFE sheet causes the app to hang. I suspect there might be an issue caused by the formula in the cell D86.
Thank you fro looking into this!Matei
Hello,
Could you please let me know which exactly version and service release you are using? Is it possible to post a workbook, which causes this issue ?
I am waiting for your feedback
Bump! Nobody else has experienced anything like this?
Thanks,Matei