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

Question

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.

djhanson · Answer

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

jthi · Answer

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

baiyun · Answer

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!