Hello,
I have e problem with the Save method of Infragistics.Document.Excel.Workbook with version 11.1.
I recently upgraded my project from 10.1 to 11.1.
This is my scenario: I create a new Excel Workbook, fill it with data and Excel formulas and then save it to file using the Save method.
The first time the Save method works, the file is created correctly. If i re-launch the same function with the same data (without closing the application), the code hang on the Save method and doesn't create the .xls file correctly. I can only terminate the program.
It seems the problem is related on how big the excel file is, because it happens only with file of a certain size. If the excel is small (I mean, less than 500-100Kb), I can launch the function many consecutive times with no problem. If the file is big (I mean, more than 1Mb), the second time it doesn't work.
I tried the same thing with my old project with Infragistics 10.1, and I can say that it worked, although it was really slower in creating the file. So it seems there has been a good speed boost in 11.1, but now i have this problem in saving the file.
Regarding the Save method, I tried either to pass a filename or a System.io.Stream as parameters, with the same result.
Any idea?
Claudio Di Flumeri
Do you think you could post some sample code which reproduces this?
At least It seems I figured out what could be the problem.
In my excel workbook there are 3 worksheets, and the second one has a lot of cells with formulas related to the first worksheet
I don't know why, but the second time I execute the workbook loading method and then the Save method, the system hang on the Save because of these formulas (actually if i disable creating the second worksheet, it works).
I have tried to call the SuspendCalculations method just before the Save method, and now it is working correctly, with my second worksheet with all its formulas.
Is it correct for you?