취소
다음에 대한 결과 표시 
표시  만  | 다음에 대한 검색 
다음을 의미합니까? 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
언어 선택 변환 막대 숨기기
lehaofeng
Level V

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

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

 

1675047463260.jpg

 

1 채택된 솔루션

채택된 솔루션
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

원본 게시물의 솔루션 보기

3 응답 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