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?
It sounds like there might be a bug in there and calling SuspendCalculations is working around it, but this will also prevent the formula cells from returning the correct values at runtime. Is there any way you can post a sample or a saved workbook which demonstrates the problem?
Would you like me to put you in contact with Developer Support so you can submit this issue and have it investigated to see if a fix can be made?
I have a similar problem, where data is loaded into a worksheet and I have 4 other worksheets which are formula heavy and dependent on the first worksheet. After 10 minutes the save is still going.
Once I call SuspendCalculations before saving the workbook the save is fairly quick.