Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
15
Read Excel file error - The left and top of the window bounds must be between -32768 and 32767
posted

Hi,

I have an app that is processing excel files. To read the files I am using Infragistics4.WebUI.Documents.Excel.v12.2 library. Some times we are getting the error "The left and top of the window bounds must be between -32768 and 32767"

By taking a look at the excel document structure (unzip the xlsx file), I found the xWindow property of workbookView is 38280 which seems to be the offending value.

<bookViews><workbookView xWindow="38280" yWindow="-120" windowWidth="25440" windowHeight="15390" 

According to Microsoft docs, this property can be Int32 (between -2,147,483,648 to 2,147,483,647) but it seems Infragistics4 is using Int16(-32,768 to 32,767) for it. 

Any idea how this error can be fixed? unzipping, editing the contents are not options for the client.

  • 20255
    Offline posted

    Hello Elena, could you please send me a sample that is reproducing the problem. I believe it will be no longer present with a newer version of our product as the Development team implemented some enhancements the last years.

    If it is not a problem for you, just download a trial of the latest version of our product and check whether the problem still persists? 

    • 20255
      Offline posted

      Hello,

      Thank you for contacting us!

      It looks like this is a limitation in Windows OS and not a problem part of our product.

      Please note that the version you are using is retired several years ago
      www.infragistics.com/help/product-lifecycle.

      My general suggestion would be to upgrade to a newer ASP.NET Ajax tool-set. You can take a look at it at:
      http://www.infragistics.com/products/aspnet.

      • 15
        Offline posted in reply to Zdravko Kolev

        Hi Zdravko Kolev,

        Could you ensure that if we use the latest version, it will fix the issue?

        If you check this link and look for LE_ArgumentException_TopLeftWindowBounds, it seems it is a limitation of Infragistics

        https://www.infragistics.com/products/ignite-ui-angular/api/docs/typescript/latest/classes/excellocaleen.html

        thanks

        • 17590
          Offline posted in reply to Zdravko Kolev

          Hello Elena,

          Thank you for your patience while we were looking into this matter for you.
          We created a private case for you with an ID of CAS-212515-R4V3B2 and we will continue assisting you there. You can check the status of the case after logging with your credentials on our web site under the Support Activity section.
          Please let me know if you need any additional information regarding this matter.

          • 20255
            Offline posted in reply to Elena Zapata

            Hello Elena, I am currently checking something related to the error. Will get back to you whenever I have any updates