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
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,
Thank you for the provided xlsc file. Could you please let me know the exactly version and build of Infragistics you are using. I have reviewed your file and it contains links like “='C:\Operations Accounting\Op Lloyd\2012\END LAKE\Production\OSR PSR\02\[201202 End Lake OSR Actual.xlsx]Sales Summary'!$D$186”. In the older versions of Infragistics, there was an issue with loading of excel file , which contains a link and I am glad to announce you that this issue is fixed in the latest service release of Infragistics 11.2 and Infragistics 12.1. Moreover I have tested provided Excel file with Infragistics 12.1 and can confirm that I have hadn't issues to loading your file.
Hi Hristo,
The hang up issue is resolved with 12.1 version. But I am getting the below error message while loading attached excel file.
Dll Version:- Infragistics3.Documents.Excel.v12.1
The worksheet reference must be followed by an exclamation point.Portion with error: [5]KI
Hello GarthGrainger,
I have seen that you already has an opened support ticket in our system with id CAS-91267-X4Q464, and one of my colleagues (David Frishknecht) currently works on it, so hi will update you for the progress of this issue via the mentioned case, as soon as he have information for you.
Thank you for using Infragistics Components.