Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
370
App hangs when accessing cell value
posted

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