C1 Community
ComponentOne Community is a free source for developers and help authors to collaborate and communicate.

Excel 2007 incorrect columns

rated by 0 users
This post has 1 Reply | 0 Followers

Not Ranked
Posts 1
kevingounden Posted: Fri, Nov 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

Top 25 Contributor
Posts 477
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) | RSS
Contact ComponentOne: 1.800.858.2739 ©1987-2010 ComponentOne LLC All Rights Reserved.