When I try to save the spreadsheet attached I am getting the following error:
An unhandled exception of type 'System.ArithmeticException' occurred in system.drawing.dll
Additional information: Overflow or underflow in the arithmetic operation.
If I do not update the SI Work sheet then I can save the workbook and I do not get the error, however once I add a row to this and attempt to save then the error occurs.
I decided to comment out most of my coding so that all I did was update the spreadsheet as you have done and found that it did work OK. I then tracked back commenting back in code until Aspose gave me the warning.
The background of what I am doing is converting a Cobol database that I can access through ODBC to be a SQL database. I using Aspose to query the data from either due to the vast speed improvement over using Excel.
What I have found is that when I query the SQL database the saving of the workbook works fine, however the error saving the workbook only arises when I query the Cobol database. I have changed the query to return no records and update the worksheet as you have coded and the save still does not work. It seems to be directly related to querying the Cobol database.
I know this is a difficult one as I am integrating with a thrid party product for the Cobol connectivity, but I would appreciate any help you could give me.
How do you query Cobol database? how do you import data to the spreadsheet using Aspose.Cells APIs? Which classes with their methods do you use of Aspose.Cells library for the task. Could you provide us some related code snippet.
We will also look into the issue and get back to you soon.