Codejock Developer Community : CXTPReportControl problems with many columns http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 19 Apr 2026 01:46:24 +0000 Mon, 22 Feb 2010 05:06:14 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=15550 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[CXTPReportControl problems with many columns : Hi, I also tested Toolkit Pro...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56975&title=cxtpreportcontrol-problems-with-many-columns#56975 Author: Fredrik
Subject: 15550
Posted: 22 February 2010 at 5:06am

Hi,

I also tested Toolkit Pro 14.0 Beta and noticed that it was not possible to scroll pass column 600 in a spreadsheet.

Are there no plans to fix it? Of course I can fix it my own sources but I rather not do that after each update.

]]> Mon, 22 Feb 2010 05:06:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56975&title=cxtpreportcontrol-problems-with-many-columns#56975 <![CDATA[CXTPReportControl problems with many columns : Thanks Mark, I tested creating...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56142&title=cxtpreportcontrol-problems-with-many-columns#56142 Author: Fredrik
Subject: 15550
Posted: 14 January 2010 at 8:26am

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:


     
]]> Thu, 14 Jan 2010 08:26:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56142&title=cxtpreportcontrol-problems-with-many-columns#56142 <![CDATA[CXTPReportControl problems with many columns : Sure - https://forum.codejock....]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56099&title=cxtpreportcontrol-problems-with-many-columns#56099 Author: mdoubson
Subject: 15550
Posted: 11 January 2010 at 4:10pm

Sure - https://forum.codejock.com/uploads/DemoVersion/ReportControlMFCUpdated.rar but you need to comment line

#include "XTPReportRecordTrackMod.h"

and body of BOOL CXTPReportControl::ExecuteSnapAction(int nTimeMarker, BOOL bLeft)
and BOOL CXTPReportControl::ExecuteSnap2Clip(BOOL bLeft) - leave only return FALSE in the end.
]]> Mon, 11 Jan 2010 16:10:33 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56099&title=cxtpreportcontrol-problems-with-many-columns#56099 <![CDATA[CXTPReportControl problems with many columns : Thanks for the quick reply. Is...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56098&title=cxtpreportcontrol-problems-with-many-columns#56098 Author: Fredrik
Subject: 15550
Posted: 11 January 2010 at 4:06pm

Thanks for the quick reply. Is there a MFC version I can test instead of the active x control?]]> Mon, 11 Jan 2010 16:06:34 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56098&title=cxtpreportcontrol-problems-with-many-columns#56098 <![CDATA[CXTPReportControl problems with many columns : Please try your case with http...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56097&title=cxtpreportcontrol-problems-with-many-columns#56097 Author: mdoubson
Subject: 15550
Posted: 11 January 2010 at 3:52pm

Please try your case with https://forum.codejock.com/uploads/BetaOCX/ReportControlBeta13-2-2.rar]]> Mon, 11 Jan 2010 15:52:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56097&title=cxtpreportcontrol-problems-with-many-columns#56097 <![CDATA[CXTPReportControl problems with many columns : By the way, will the scrolling...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56096&title=cxtpreportcontrol-problems-with-many-columns#56096 Author: Fredrik
Subject: 15550
Posted: 11 January 2010 at 3:48pm

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

When is next version expected?]]> Mon, 11 Jan 2010 15:48:51 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=56096&title=cxtpreportcontrol-problems-with-many-columns#56096 <![CDATA[CXTPReportControl problems with many columns : It was general info based on Excel2003...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54622&title=cxtpreportcontrol-problems-with-many-columns#54622 Author: mdoubson
Subject: 15550
Posted: 06 November 2009 at 1:27pm

It was general info based on Excel2003 and prev versions]]> Fri, 06 Nov 2009 13:27:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54622&title=cxtpreportcontrol-problems-with-many-columns#54622 <![CDATA[CXTPReportControl problems with many columns : mdoubson wrote:Excel spec:...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54621&title=cxtpreportcontrol-problems-with-many-columns#54621 Author: Fredrik
Subject: 15550
Posted: 06 November 2009 at 1:24pm

Originally posted by mdoubson 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.]]> Fri, 06 Nov 2009 13:24:02 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54621&title=cxtpreportcontrol-problems-with-many-columns#54621 <![CDATA[CXTPReportControl problems with many columns : Excel spec: Rows &lt;= 64K,...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54606&title=cxtpreportcontrol-problems-with-many-columns#54606 Author: mdoubson
Subject: 15550
Posted: 05 November 2009 at 8:05pm

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

]]> Thu, 05 Nov 2009 20:05:14 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54606&title=cxtpreportcontrol-problems-with-many-columns#54606 <![CDATA[CXTPReportControl problems with many columns : I am testing the report control...]]> http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54569&title=cxtpreportcontrol-problems-with-many-columns#54569 Author: Fredrik
Subject: 15550
Posted: 04 November 2009 at 6:21pm

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() ;-)?

]]> Wed, 04 Nov 2009 18:21:52 +0000 http://forum.codejock.com/forum_posts.asp?TID=15550&PID=54569&title=cxtpreportcontrol-problems-with-many-columns#54569