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
Bump! Nobody else has experienced anything like this?
Thanks,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
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 ,
Thank you for the provided sample file. I have tested your issue with the latest service release of Infragistics 10.2 , which is 2151 (Infragistics 10.2.20102.2151) and I am glad to announce you, that this issue is fixed in this version, so please download and install mentioned version. On the following link you will find a tutorial “How to get latest service release”:
http://community.infragistics.com/forums/p/29398/127620.aspx
Please let me know if you have any further questions.
Attached excel file is haug up while loading through the Infragistics.Documents.Excel.Workbook.Load(file, false); function.
Thanks,