We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exception message: Specified argument was out of the range of valid values.

Thread ID:

Created:

Updated:

Platform:

Replies:

130792 Jun 2,2017 01:42 PM UTC Nov 21,2017 12:42 PM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Patrick Morton
Asked On June 2, 2017 01:42 PM UTC

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?

RunTime version: v4.0.30319
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) 

Sudha Ramachandran [Syncfusion]
Replied On June 5, 2017 07:13 AM UTC

Hi Patrick, 

As the issue is specific to the document you use, we need that document to analyze further. You can share the document by creating an incident in DirectTrac. The documents shared will not be disclosed and is only for the purpose to reproduce the issue. We assure you that the document will be deleted from our side once the issue is resolved. 

Regards, 
Sudha R 


TheDarkBoz
Replied On November 20, 2017 11:44 PM UTC

If somebody have the same issue  iColumn1  or  iColumn2 it is probably that you use 0 like value. I had the same issue.

Abirami Varadharajan [Syncfusion]
Replied On November 21, 2017 12:42 PM UTC

Hi TheDarkBoz,  

Thank you for your suggestion. 
   
We are able to reproduce the issue. A support incident to track the status of this issue has been created under your account. Please log on to our support website to check for further updates.     
      
     
Please let us know if you have any concerns.    
    
Regards,    
Abirami.    


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;