Aspose Workbook.Open stalls for ever and doesn't proceed when trying to open certain Excel files

Hello,


Version of Aspose used 5.3.2.4

Using aspose with the following code to process one of my documents, the document goes bad.


System.IO.FileStream fstream = null;
Workbook workbook = new Workbook();
try
{
FileFormatType fileFormat = GetExcelFileFormat(version, Path.GetExtension(docFile));
Aspose.Cells.FileFormatType fileSaveFormat = GetExcelSaveFormat(version, Path.GetExtension(docFile));
fstream = new System.IO.FileStream(docFile, FileMode.Open);
workbook.Open(fstream, fileFormat);
fstream.Dispose();

foreach (Worksheet worksheet in workbook.Worksheets)
{
foreach (Aspose.Cells.Hyperlink link in worksheet.Hyperlinks)
{
CellArea cellAdr = link.Area;
Aspose.Cells.Cell cell = worksheet.Cells[cellAdr.StartRow, cellAdr.StartColumn];
cell.PutValue(string.IsNullOrEmpty(link.TextToDisplay) ? string.Empty : string.Format(CultureInfo.CurrentCulture, “[Deleted Link]”));
link.Address = “”;
continue;

link.Address = “1”;
}
}
if (workbook.Worksheets.CustomDocumentProperties.Contains("_PID_HLINKS"))
workbook.Worksheets.CustomDocumentProperties.Remove("_PID_HLINKS");
workbook.Save(destFile, fileSaveFormat);

My code stalls/hangs at the red line and can never proceed further. Attaching the document with which you can recreate this issue.

Please assist. Also we have a support license with Aspose,so please confirm if there is a separate channel via which we can create support requests and get these processed with higher priority.

Thanks
vk

Hi,

There are a lot of empty rows and columns. The last cell is WVW3078.

Total Number Of Cells Are: 3078 * 16143 = 49688154

So, it will take some time to be loaded.

If you are a priority support customer, then you can post your problem on Priority Support Forum.