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
Thanks Hristo that helped, we are using an UltraFormManager.
Cheers,Matei
Hello mateidorobantu,
I assume that you are using UltraToolbarsManager or UltraFomrManager, both components use formatted text to format the caption of the form, so you could set the caption to be something like :
"<p style=\"text-align:Left;\">The name of your form</p>"
If you are using UltraToolbarsManager you should apply this on ultraToolbarsManager1.Ribbon.Caption, and if you are using UltraFormManager you should apply this on ultraFormManager1.FormStyleSettings.Caption.
Please let me know if you have any further questions.
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.
I've only just noticed that after upgrading to the service release the form captions in my application are now centered as opposed to left aligned. Ican't for the life of me figure out how to get the caption to left align again. Any ideas?
Thanks!Matei
Service release 2151 worked for us, thank you!