Issue in Calculate Method

Hi,


Below code is giving error on calculate method with attached sample file.


using (ExcelEngine excelEngine = new ExcelEngine())

            {

                IApplication app = excelEngine.Excel;

                IWorkbook workbook = app.Workbooks.Open("CTCSampleFile.xlsx", ExcelOpenType.Automatic);

                IWorksheet worksheet = workbook.Worksheets["1"];

                worksheet.Range["B1"].Value = "24000";

                worksheet.Calculate();

                workbook.Save();

                workbook.Close();

            }


Attachment: CTCSampleFile_bb15c266.zip

1 Reply

KK Konduru Keerthi Konduru Ravichandra Raju Syncfusion Team January 23, 2023 12:53 PM UTC

Hi Nagendra,


Please go through the below link for information about how to resolve stack overflow exception.

https://help.syncfusion.com/file-formats/xlsio/faqs/how-to-overcome-stackoverflow-exception-with-iworksheet-calculate


Regards,

Keerthi.


Loader.
Up arrow icon