cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lehaofeng
Level V

如何对table box进行设置实现自动排序以及条件颜色设定?

我准备用new window,把图中的表格放入报告中(jmp15),有两个问题,如何编写JSL,通过点击列名实现自动排序的;第二个问题如何对表中的颜色根据值的大小进行设定(也是JSL)。

 

1675047463260.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: 如何对table box进行设置实现自动排序以及条件颜色设定?

To set the one click sorting for a Table Box() this is done by passing the 

tb << Set Click Sort( 1 );

message to the table box.

txnelson_0-1675051125962.png

Documentation can be found in the Scripting Index

txnelson_1-1675051200916.png

 

The conditional Highlighting is found under the Format Column Option of a Table Box(). Look to the Semantic Formatting and Use Underlying Conditional Highlighting. 

txnelson_2-1675051594550.png

 

 

 

Jim

View solution in original post

3 REPLIES 3
txnelson
Super User

Re: 如何对table box进行设置实现自动排序以及条件颜色设定?

To set the one click sorting for a Table Box() this is done by passing the 

tb << Set Click Sort( 1 );

message to the table box.

txnelson_0-1675051125962.png

Documentation can be found in the Scripting Index

txnelson_1-1675051200916.png

 

The conditional Highlighting is found under the Format Column Option of a Table Box(). Look to the Semantic Formatting and Use Underlying Conditional Highlighting. 

txnelson_2-1675051594550.png

 

 

 

Jim
lehaofeng
Level V

Re: 如何对table box进行设置实现自动排序以及条件颜色设定?

谢谢,我在17版的scipt index才发现第一个问题的代码,15版没有;第二个问题,在15版本中没有相应的选项,只有17版有,我现在只能用15版本,应该是只能通过jsl编程实现。

txnelson
Super User

Re: 如何对table box进行设置实现自动排序以及条件颜色设定?

I guess you will have to wait until you can upgrade your version of JMP.

Jim