Home » WinForms » Excel for .NET » Excel 2007 incorrect columns

Re: Excel 2007 incorrect columns

WinForms

ComponentOne's WinForms controls
Details
  • 1 Reply
  • 0 Subscribers
  • 658 days old
Options

Excel 2007 incorrect columns

  • rated by 0 users
  • This post has 1 Reply |
  • 0 Followers
  • Posted by
    on 11-14-2008 6:52 PM

    hi guys,

    Using 2.1.20082.94 XLBook component on VS2008 SP1 / WinXP.

    reading in a standard 2007 file which has 1500 columns. Col Count is saying 754. Since flexgrid does not support 2007, i am writing to the grid manually and i can see that it is not reading the sheet correctly. This sheet has about 3000 rows.

    Tried setting compatibility to no limits and to excel 2007 and same problem. Does anyone have a sample VS app + excel file several thousand columns that you can post for me to test.

     also, is flexgrid going to support opening 2007 files?

     Thanks in advance

    Kevin
  • Posted by
    on 11-18-2008 5:29 AM
    Hi Kevin,

    see the release notes of C1FlexGrid 2.6.20082.385:
    - Enabled saving xlsx files with more than 256 columns/65k rows.

    So upgrading FlexGrid seems to solve the basic problem.

    Hope this helps

    Wolfgang
Page 1 of 1 (2 items)