We are using Cells to edit various Excel document properties in a .NET application. We are on Cells version 4.6. The workbooks are created with 2003 and 2007.
Occasionally Cells will not close the workbook properly, so when the file is opened in Excel, it claims the file is locked by our application. The class doesn’t throw an error, it just locks the file and won’t release it, even after the object is destroyed. The file opens cleanly in Excel before the processing occurs, but is locked afterwards. We are using the integrated open function in Cells, feeding it the filename directly.
This happens sporadically on a variety of different spreadsheets. They aren’t using any advanced functionality, they are plain spreadsheets with a few in-worksheet calculations, and a few embedded pictures. They don’t call external functionality or data at all.
We can’t find a common property of the workbooks that fail. Is there a list of known issues that cause Cells to hang?
Hi,
Could you try the attached our latest version/fix v4.9.1.3.
If you still find any issue, kindly create a console demo application to show the issue, we will check it soon.
Thank you.
It looks like the latest version is properly updating the documents that were hanging in version 4.6. Thanks for the recommendation!
We were trying to avoid upgrading the DLL as it would trigger a fairly extensive test cycle on already-baked code, but if it fixes the problem, it’s worth it.