Codejock Developer Community : How can I force horizontal scrollbar to appear

Codejock Developer Community : How can I force horizontal scrollbar to appear http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 15 May 2026 09:48:08 +0000 Tue, 09 Jun 2009 10:27:44 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=14307 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[How can I force horizontal scrollbar to appear : Just to wind up this topic .....I've...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49748&title=how-can-i-force-horizontal-scrollbar-to-appear#49748 Author: Mike Lewis
Subject: 14307
Posted: 09 June 2009 at 10:27am

Just to wind up this topic .....

I've got it working now. For the benefit of others with the same problem, here's what I did:

1. When adding the columns to the grid, set the last parameter (to the Add() method) to "false". This tells the grid to respect the column widths when it is resized. (This was what I was missing earlier.)

2. Subsequently, set each column's Resizable to "true" (this is not essential for this solution; it allows the user to resize the columns manually).

3. Set the grid's AutoColumnSizing to "false".

4. In the grid's Resize event, added code to loop through the columns collection, changing the width of each column in proportion to the change in the width of the grid.

I now have the behaviour I want (almost). In particular, the horizontal scrollbar appears when needed, and the columns fill the grid to the right on resizing, that is, there is no unwanted white space.

It's still not perfect. Occassionally, the scrollbar disappears for no obvious reason after a resize. But it comes back again if you just resize the form by a pixel or two in either direction. I think I can live with that.

Mike
]]> Tue, 09 Jun 2009 10:27:44 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49748&title=how-can-i-force-horizontal-scrollbar-to-appear#49748 <![CDATA[How can I force horizontal scrollbar to appear : Hi Aaron,I haven't had time...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49279&title=how-can-i-force-horizontal-scrollbar-to-appear#49279 Author: Mike Lewis
Subject: 14307
Posted: 22 May 2009 at 10:44am

Hi Aaron,

I haven't had time to try your suggestions, as I got sidetracked on another project. With luck, I'll get back to it next week.

Mike
]]> Fri, 22 May 2009 10:44:27 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49279&title=how-can-i-force-horizontal-scrollbar-to-appear#49279 <![CDATA[How can I force horizontal scrollbar to appear : Hi, I'm not sure if my...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49144&title=how-can-i-force-horizontal-scrollbar-to-appear#49144 Author: Aaron
Subject: 14307
Posted: 19 May 2009 at 9:56am

Hi,

I'm not sure if my previous reply works properly with V13.0 (maybe you have to wait for V13.1 release)

See post https://forum.codejock.com/forum_posts.asp?TID=13379 for specific details

Well if you need more help, just post in forum

]]> Tue, 19 May 2009 09:56:56 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49144&title=how-can-i-force-horizontal-scrollbar-to-appear#49144 <![CDATA[How can I force horizontal scrollbar to appear : Hi Aaron,Many thanks for your...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49116&title=how-can-i-force-horizontal-scrollbar-to-appear#49116 Author: Mike Lewis
Subject: 14307
Posted: 18 May 2009 at 12:03pm

Hi Aaron,

Many thanks for your reply.

I've tried setting minimum column widths, and setting AutoSize to .F. Now, I'm seeing the full widths of the columns when the grid is at its maximum size. But when I make it smaller, I only occasionally see the scroll bar. In other words, it's intermittent.

Clearly, I need to figure out how to create the problem in a reproducible way. If I can do that, I'll post some more details here.

I haven't yet tried your suggestion for getting rid of the white space. I'll do that next, but it's a slightly lower priority.

I'll report back when I've got some more information.

Mike
]]> Mon, 18 May 2009 12:03:04 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49116&title=how-can-i-force-horizontal-scrollbar-to-appear#49116 <![CDATA[How can I force horizontal scrollbar to appear : Hi, Well you said it yourself,...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49070&title=how-can-i-force-horizontal-scrollbar-to-appear#49070 Author: Aaron
Subject: 14307
Posted: 16 May 2009 at 5:18am

Hi,

Well you said it yourself, you have to set AutoColumnSizing to false in order to have horizontal scrollbars...

But... You can have AutoColumnSizing set to True, if you would set MinimumWidth for columns. When RC resizes the columns will AutoResize as well, if columnwidths equals/less than width, RC forces the horizontal scrollbar to be visible as well.

About "white space" you could add last column using:

Dim xtremeColumn As XtremeReportControl.ReportColumn
Set xtremeColumn = wndReportControl.Columns.Add(.......)

xtremeColumn.DrawHeaderDivider = False

At least it looks like it's last column

This will only work when columns can't be moved, grouped etc. etc. Could be done but you have to add code in columnchanged event and always set last column DrawHeaderDivider flag = false

You could consider using variable rowheight, the contents will be completely visible all the time and in combination with MinimumHeight you can have AutoColumnSizing and don't have to care about last column.

Hope this helps you a little

]]> Sat, 16 May 2009 05:18:09 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49070&title=how-can-i-force-horizontal-scrollbar-to-appear#49070 <![CDATA[How can I force horizontal scrollbar to appear : I am using the Report control...]]> http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49044&title=how-can-i-force-horizontal-scrollbar-to-appear#49044 Author: Mike Lewis
Subject: 14307
Posted: 15 May 2009 at 8:06am

I am using the Report control to show a grid, in which there are maybe ten to 12 columns. It won't be possible for me to arrange things so that all the data in all the columns is always visible. The user will want to widen some of the columns, and use a horizontal scroll bar to see any colums that are outside the viewing area.

What I'm looking for is a way of forcing the horizontal scroll bar to be visible.

I have tried setting the control's AutoSize to false, which I understand is necessary for the scrollbar to appear. Unfortunately, that means that, if the user resizes the form and makes the grid wider, the columns don't resize. Instead, there is white space to the right of the right-most column, which is undesirable. But even if I accept the white space, I've found that setting AutoSize to false doesn't itself make the scrollbar appear.

I'd appreciate any suggestions. What I'd ideally like to have is a permanent scrollbar, and for the columns to resize themselves automatically when the grid is made either wider or narrower.

My platform is Visual FoxPro 9.0, under Windows XP and Vista. I'm using the ActiveX version of the control. I'm not looking for any FoxPro-specific help. If someone can give me a solution in general terms, I can apply it to my specific platform

Thanks in advance.

Mike
]]> Fri, 15 May 2009 08:06:26 +0000 http://forum.codejock.com/forum_posts.asp?TID=14307&PID=49044&title=how-can-i-force-horizontal-scrollbar-to-appear#49044