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,

     <span class="Apple-tab-span" style="white-space:pre;"> </span>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 (<span class="dlgtitle">#99914046</span><span class="lockmsg"> ). This should be fixed in our next maintenance release of Spread for Windows Forms.</span>

    <span class="lockmsg">Thanks, </span>

Need extra support?

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

Learn More

Forum Channels