1. Feedback
  2. WinForms
  3. 17034

Welcome to the WinForms feedback portal. We’re happy you’re here! If you have feedback on how to improve the WinForms, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

0
Votes

Hangs when trying to access specific xlsio sheet with comments

For the file attached, I'm getting timeouts/hanging when trying to open it.

        mExcelEngine = New Syncfusion.XlsIO.ExcelEngine()

         mWorkBook = mExcelEngine.Excel.Workbooks.Open(pStream) <-hangs here

 

It seems to be releated to the comment/note on cell F36, since removing that allows it to load. Given that, I have tried to open the workbook with the option to parse worksheets on demand, clearing comments, and then but then it instead hangs when trying to reference most parsed properties (UsedRange.LastRow, etc):

        mWorkBook = mExcelEngine.Excel.Workbooks.Open(pStream, Syncfusion.XlsIO.ExcelParseOptions.ParseWorksheetsOnDemand)

        mWorkBook.Worksheets(0).Comments.Clear()

 mWorkBook.Worksheets(i).UsedRange.LastRow > 10 ... <-hangs/timeout error here instead