CXTPReportControl problems with many columns

I am testing the report control with a few thousand columns in virtual mode and noticed a few problems:

1) If you drag the horizontal thumb to the right the scrolling will snap back to first column when you pass column 700 or so. (Using GetScrollInfo for the cases SB_THUMBTRACK SB_THUMBPOSITION in CXTPReportControl::OnHScroll2 instead of nPos solves the problem.)

2) In virtual mode: If you pass pos == NULL in a call to GetNextSelectedRow(pos) it will return a pointer to m_pVirtualRow instead of NULL - did not expect that...

3) If you have a few thousand columns and your mouse happen to pass over some of the column headers the application will become unresponsive for some time (5-10 seconds).

Actually, what I want is an EXCEL like spreadsheet and perhaps CXTPReportControl is not designed for that - if this is the case, does anyone have a suggestion for an alternative control?

Using v. 13.2.1

By the way, isn't there a missing 'l' in the name GetFulColScrollInfo() ;-)?

mdoubson wrote: Excel spec: Rows <= 64K, Columns <= 256

Not sure if this was an answer or general information but I don't see any value in your post?

For your information, Excel 2007 supports 16384 columns and over a million rows.

By the way, will the scrolling bug/etc be fixed in next version of the Toolkit?

When is next version expected?

Thanks for the quick reply. Is there a MFC version I can test instead of the active x control?

Thanks Mark,

I tested creating a spreadsheet with 10 000 columns and 100 rows.

My report control no longer "hangs" when moving the mouse over the column headers, but is still rather slow when scrolling and selecting rows. Selecting a row when you have scrolled to the far right of the spreadsheet takes a few seconds on my computer.

Horizontal scrolling still doesn't work. I changed XTPReportControl.cpp, line 4820:

   nCurPos = nPos;

to

   SCROLLINFO si;
   ZeroMemory(&si, sizeof(SCROLLINFO));
   si.cbSize = sizeof(SCROLLINFO);
   si.fMask = SIF_TRACKPOS;

   if (!GetScrollInfo(SB_HORZ, &si))
      return;
   nCurPos = si.nTrackPos;

to make it work for me.

By the way, if you lock/freeze the first column and use the xtpReportFreezeColsDividerShade style it doesn't look really nice if you select a row and scroll horizontally: