cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
baiyun
Level I

How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

I want to freeze below columns "PROGRAM_NAME_NO" and "IBType" while scrolling X-Axis of TableBox?

Is there anyone who knows how to solve this issue? Do appreciate your favor.

 

baiyun_0-1614576896789.png

 

6 REPLIES 6
jthi
Super User

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

Those seem to be the first two columns in the table box. Maybe following will work:

 

TableBoxReference << Set Locked Columns(2);
-Jarmo
baiyun
Level I

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

Hi jthi,

 

Thanks for your answer. I have tried this solution, it does not work for me. Literally, I post my question on JMP community. 

baiyun_0-1614676277186.png

 

Do you have any other solutions?  Thanks  

txnelson
Super User

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

To do this interactively, go to the columns panel and right click on the column you want to freeze, and select  Scroll Lock/Unlock

lock.PNG

Jim
baiyun
Level I

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

Hi txnelson,

 

Appreciate your answer. I've tried this solution before, it only works when you scroll the DataTable but not work while scrolling the TableBox on the window.

So I post my question here for other solutions. Looking forward to your reply! 

jthi
Super User

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

Which JMP version are you using? I have 15.2.1 and this seems to be working:

 

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
dt = New Window("Example", 
	tb = Table Box(
		String Col Box("lotid", dt:lot_id << get as matrix),
		String Col Box("waferinlot", dt:"Wafer ID in lot ID" << get as matrix),
		Number Col Box("NPN1", dt:NPN1 << get as matrix),
		Number Col Box("PNP1", dt:PNP1 << get as matrix),
		Number Col Box("PNP2", dt:PNP2 << get as matrix),
		Number Col Box("NPN2", dt:NPN2 << get as matrix),
		Number Col Box("PNP3", dt:PNP3 << get as matrix),
		Number Col Box("IVP1", dt:IVP1 << get as matrix),
		Number Col Box("PNP4", dt:PNP4 << get as matrix),
		Number Col Box("NPN3", dt:NPN3 << get as matrix),
		Number Col Box("IVP2", dt:IVP2 << get as matrix)
	)
);

tb << Set Scrollable(30, 4);
show(tb << Get Locked Columns);
tb << Set Locked Columns(2);
show(tb << Get Locked Columns);
-Jarmo
djhanson
Level V

Re: How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

I can confirm this tablebox() column freezing (like Excel freeze pane) does work in JMP 14.x but does not work in JMP 12.x.  Either way it's a great feature I'm glad JMP can do this at least in later versions.

DJ