CXTPReportControl problems with many columns |
Post Reply |
Author | |
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
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() ;-)? |
|
mdoubson
Senior Member Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
|
Excel spec: Rows <= 64K, Columns <= 256 |
|
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
|
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. |
|
mdoubson
Senior Member Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
|
It was general info based on Excel2003 and prev versions
|
|
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
|
By the way, will the scrolling bug/etc be fixed in next version of the Toolkit?
When is next version expected? |
|
mdoubson
Senior Member Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
|
Please try your case with https://forum.codejock.com/uploads/BetaOCX/ReportControlBeta13-2-2.rar
|
|
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
|
Thanks for the quick reply. Is there a MFC version I can test instead of the active x control?
|
|
mdoubson
Senior Member Joined: 17 November 2008 Status: Offline Points: 1705 |
Post Options
Thanks(0)
|
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. |
|
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
|
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: |
|
Fredrik
Senior Member Joined: 22 June 2005 Status: Offline Points: 235 |
Post Options
Thanks(0)
|
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. |
|
Windows 10, Visual Studio 20157, Toolkit Pro 18.3.0
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |