Hello, I am using XlsIO in a VB.NET environment. We take in .xls, xlsm,xlsx files via a stream and for the most part are able to open them with XlsIO without issue. However at times some excel files cannot be opened by XlsIO, but I can open them locally without issue using Microsft Excel. I am unable to share a sample because I would need to resave the file to remove sensitive data. When I resave the file locally in excel XlsIO is able to open the file. Do you have any suggestions on how to work around this issue?
Version: 15.2450.0.40
Stack Trace below:
Exception information:
Exception type: System.ArgumentOutOfRangeException
Exception message: Specified argument was out of the range of valid values.
Parameter name: iColumn2
Thread information:
Stack trace: at Syncfusion.XlsIO.Implementation.Shapes.ShapeImpl.GetWidth(Int32 iColumn1, Int32 iOffset1, Int32 iColumn2, Int32 iOffset2, Boolean bIsOffsetInPixels)
at Syncfusion.XlsIO.Implementation.Shapes.ShapeImpl.UpdateWidth()
at Syncfusion.XlsIO.Implementation.Shapes.ShapeImpl.ParseClientAnchor(MsofbtClientAnchor clientAnchor)
at Syncfusion.XlsIO.Implementation.Shapes.ShapeImpl.ParseRecord(ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.AddShape(MsofbtSpContainer shapeContainer, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.AddShape(MsoBase shape, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.Parse(MsofbtSpgrContainer container, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.ParseMsoDgContainer(MsofbtDgContainer dgContainer, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.ShapeCollectionBase.ParseMsoStructures(List`1 arrStructures, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorksheetBaseImpl.ExtractMSODrawing(Int32 startIndex, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorksheetBaseImpl.Parse()
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseWorksheets()
at Syncfusion.XlsIO.Implementation.WorkbookImpl.Parse(BiffReader reader, ExcelParseOptions options, String password)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStgStream(ICompoundStorage storage, ExcelParseOptions options, String password)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.ParseStream(Stream stream, String password, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.WorkbookImpl..ctor(IApplication application, Object parent, Stream stream, ExcelParseOptions options, ExcelVersion version)
at Syncfusion.XlsIO.Implementation.ApplicationImpl.CreateWorkbook(Object parent, Stream stream, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelVersion version, ExcelParseOptions options)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream, ExcelOpenType openType)
at Syncfusion.XlsIO.Implementation.Collections.WorkbooksCollection.Open(Stream stream)