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

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

baiyun — Mon, 01 Mar 2021 05:38:07 GMT

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.

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

jthi — Mon, 01 Mar 2021 13:56:06 GMT

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

TableBoxReference << Set Locked Columns(2);

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

txnelson — Mon, 01 Mar 2021 15:22:35 GMT

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

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

baiyun — Tue, 02 Mar 2021 09:11:55 GMT

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.

Do you have any other solutions? Thanks :)

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

baiyun — Tue, 02 Mar 2021 09:14:52 GMT

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!

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

jthi — Tue, 02 Mar 2021 09:45:56 GMT

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

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

djhanson — Fri, 28 May 2021 13:28:54 GMT

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