We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

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