该帮助的版本不再更新，请参见https://www.jmp.com/support/help/zh-cn/15.2 获取最新的版本.


JSL Syntax Reference • JSL Messages • Display Boxes • Table Boxes
上一个
 • 
下一个
Table Boxes
table box<<Get
Gets the entries of the table in list form.
table box<<Get As Matrix
Gets the numeric entries of the table in matrix form.
table box<<Get Locked Columns
Returns the number of columns that cannot be dragged with the cursor or have any columns dropped before them.
table box<<Get Row Change Function
Returns the expression that is evaluated when a row is selected.
table box<<Get Selectable Rows
Returns True if the table box currently allows row selection.
table box<<Get Selected Row Color
Returns the index number of the background color of the selected rows in the table box.
table box<<Make Combined Data Table
Description
Same as Make Data Table, but also searches the report for report tables with the same columns and combine all of these into the new data table.
Returns
A reference to the data table.
table box<<Make Data Table(name)
Description
Turns the table entries into a new data table.
Returns
A reference to the data table.
table box<<Reorder Columns( from column index, to column index)
Puts the column specified with from column index in the place of the column specified with to column index. The indexes are 0-based. For example, indicate the first column with “0”, and indicate the second column with “1”.
table box<<Set Row Change Function
Sets the expression that is evaluated when a row is selected.
table box<<Set Cell Changed Function(Function({this, col box, row},<script>;))
Sets a function that is called whenever the user edits a cell in a column in a table.
Example
This example prints the new values for the changed cell to the log.
New Window( "Mountains",
tb = Table Box(
String Col Edit Box(
"Mountain",
{"K2", "Delphi", "Kilimanjaro",
"Grand Teton"}
),
Number Col Edit Box(
"Elevation (meters)",
{8611, 681, 5895, 4199}
),
Plot Col Box( "", {8611, 681, 5895, 4199} )
)
);
tb <<
Set Cell Changed Function(
Function( {this, col, row},
Print(
(col << Get Heading) || ": row:" ||
Char( 3 ) || " is now " ||
Char( col << Get( row ) )
)
)
);
table box<<Set Column Borders(Boolean)
Draws a line on each side of the column.
table box<<Set Heading Column Borders(Boolean)
Draws a line on each side of the column headings.
table box<<Set Locked Columns(n)
Locks the first n columns. You cannot drag the locked columns or drag columns before them.
table box<<Set Row Borders(Boolean)
Draws a line above and below each row.
table box<<Set Selectable Rows(Boolean)
Makes the rows of the table box selectable or not.
table box<<Set Selected Row Color("color")
If the rows of the table box are selectable (Set Selectable Rows(True)), sets the background color for the selected rows.
table box<<Set Shade Cells(Boolean)
Shades the background of every cell in the table.
table box<<Set Shade Alternate Rows(Boolean)
Shades the background of every other row in the table.
table box<<Set Shade Heading(Boolean)
Shades the background in column headings.
table box<<Set Underline Headings(Boolean)
Draws a line underneath the column headings.
table box<<Sort By Column(<colnum|coltitle>, <ascending(Boolean)>
Sorts all rows based on the values in the specific column. The default order sorting is descending. You can sort by multiple columns by sorting the first column and then sorting the second column.