Hi,
I've written a routine in VB.NET to import an excel spreadsheet. This has been working fine and is now tried and tested.
However, when we tried to import one particular spreadsheet (which includes complex formulas etc.) the process hangs on Workbook.Load
Dim dataWorkbook As Workbook
Dim s As IO.Stream = New IO.MemoryStream(bSpreadsheetFile)
dataWorkbook = Workbook.Load(s)
It hangs on that last line. (bSpreadsheetFile is a byte array containing the spreadsheet)
I've uploaded ths spreadsheet onto FileDropper
http://www.filedropper.com/jimimport-crashesjobqueue
<a href=http://www.filedropper.com/jimimport-crashesjobqueue><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >file storage</a></div>
The excel refernce on the server project is 'InfragisticsWPF4.Documents.Excel.v12.2'
Hope you can help
Many thanks
Andy
HI,
Please let me know if you need further assistance regarding this issue.
Sincerely,
Matt
Developer Support Engineer
This issue has been resolved by the latest service release.
Please let me know if you need further assistance regarding this case.
I have created a private case for this issue and logged a developer issue.
I will email you shortly with the details.
Hi Andy, I was able to reproduce the issue. I ran it through a profiler quickly and it appears the slowdown is in the formula loading logic. However, I don't see a good workaround for you to use at this time. This will need to be fixed internally. I have forwarded this post to the Developer Support Manager and a DS engineer will be contacting you about this issue.