Problem with an excel file, opening the file

Posted by: ajcinfo on 8 September 2017, 2:12 pm EST

  • Posted 8 September 2017, 2:12 pm EST

    Hello,


     I use farpoint spread for windows forms 4 (framework 2) , and i have the following problem.


    I have a excel file with 2 sheets :  "DonnĂ©es"  and "Contraintes".


    When I open the file with Excel, no problem, but when i open the file with spread the second sheet named "contraintes" is empty.


    I joined the excel file


    can someone try  to open my file


    thanks


    2010/01/CCL1.rar
  • Replied 8 September 2017, 2:12 pm EST

    Hello,

    I am able to replicate the issue and I see if I swap the positions of the sheets the sheets are being imported with no problem.I am also able to import the sheets using the below code,

      FpSpread1.Sheets.Count = 2

            FpSpread1.Sheets(0).OpenExcel("C:\CCL1.xls", 0)

            FpSpread1.Sheets(1).OpenExcel("C:\CCL1.xls", 1) 

    There seems to be some issue with the way the Excel file is created. I will further investigate this to know why the second sheet is not being imported to update you accordingly.

      

    Thanks,

     

     

     

  • Replied 8 September 2017, 2:12 pm EST

    Hello,

    I have submitted this issue as a bug to our QA team (#99914046 ). This should be fixed in our next maintenance release of Spread for Windows Forms.

    Thanks, 

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels