slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Architect Forums - SalesLogix Scripting & Customization
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix Scripting & Customization | New Thread

View: Search:

Author

Thread: Freeze DataGrid like Excel

Lou
Posts: 81

Freeze DataGrid like Excel Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Oct 06 8:24 AM

I have a DataGrid with many columns. Users need to scroll horizontally in order to see everything. It would be helpful a few of the first columns remained visible no matter how far the user scrolls. Is there a way to freeze columns like the "Freeze Panes" functionality in Microsoft Excel?

(As a work-around, I could use two separate DataGrids. One would only show the columns always needed to be visible, and the other would have everything else. I would like to avoid this if I could.)

Thanks in advace for your help!

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: Freeze DataGrid like Excel Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Oct 06 12:57 PM

Lou, there's nothing in the SLX grid that would allow it to work that way - but your idea of using the two separate grids ins't bad, it would just be hard to keep them in sync (what if the user scolls on one of the grids?)

[Reply][Quote]

Jeremy Brayton
Posts: 491

Re: Freeze DataGrid like Excel Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Oct 06 1:36 PM

Quote:

Originally posted by Lou

I have a DataGrid with many columns. Users need to scroll horizontally in order to see everything. It would be helpful a few of the first columns remained visible no matter how far the user scrolls. Is there a way to freeze columns like the "Freeze Panes" functionality in Microsoft Excel?

(As a work-around, I could use two separate DataGrids. One would only show the columns always needed to be visible, and the other would have everything else. I would like to avoid this if I could.)

Thanks in advace for your help!

I haven't verified this works but couldn't you use the GroupPane to mimic the behavior? When you set columns to use in the sort tree it'll place that columns info in the upper left corner of the grid. I figured this would "Freeze" that column but I can't verify it. If I had to guess I would say it doesn't work.

You're basically trapping the scroll function and keeping certain columns present by whatever means necessary. It's somewhat trivial to keep columns present through programmatically altering control output but because you can't trap the scroll, you're pretty much stuck.

With regards to the 2 datagrid trick, you could situate them so that it appears as one control. Have the parent control on the left with all of the visible columns locked. Have the child control scrollable which should make it the only control people use. To be thorough you can trap the parent events and pipe them through to the child so that when someone selects row 5 in the parent, row 5 is also selected in the child. It's a bit of work but I believe it could be pulled off.

[Reply][Quote]

Guy Barrett
Posts: 63

Re: Freeze DataGrid like Excel Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Jul 12 6:02 AM

Hi,

Sorry for bumping this six years later!

Does anyone know if anything has changed since that allows this to be done easily?

Cheers,

Guy.

[Reply][Quote]

RJ Samp
Posts: 973

Re: Freeze DataGrid like Excel Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Jul 12 6:16 AM

no.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 2/23/2025 7:58:24 AM