Whilst the calculation completes as expected for our excel file, we note that we get a lot of SpreadsheetCalculationExceptions, some of these we would like to investigate, however as the Gembox.Spreadsheet.dll is catching and not throwing these we lose any information about which cell etc is causing the error. We also don’t seem to have access to a pdb file which could help debug the exception. We know that we can break when the exception is thrown but this only lets us see the call to worksheet.calculate.
As a workaround we are iterating the every cell in the workbook.
Is it possible to force the gembox.spreadsheet.dll to raise the exceptions (rather than catching) - this would mean that we have the option of handling the exceptions ourselves?
Is there a way to find the cell information for the exceptions raised - other than iterating all of them?
Is there access to the pdb or source files?