When i am trying to get the formula field it returns the worng value in the array. Below is my code when i am using workbook.calculateformula function it hangs the application.
Workbook objworkbook = new Workbook();
object[,] objArray;
objworkbook.Open("D:\\Desktop\\ee758372-6264-44e0-b4b2-087f79707787201004010606034800.xlsx", FileFormatType.Excel2007Xlsx);
Worksheet ws = objworkbook.Worksheets["Measure Units"];
Range rg = ws.Cells.CreateRange("l2", "P2");
objArray = ws.Cells.ExportArray(rg.FirstRow, rg.FirstColumn, rg.RowCount, rg.ColumnCount);
Please help me on this. I am planning to buy this software