JSL Syntax Reference • JSL Messages • Display Boxes • Table Boxes
Previous
 • 
Next
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 hand 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
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.
table box<<Make Data Table(name)
Turns the table entries into a new data table.
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 Locked Columns(n)
Locks the first n columns. You cannot drag the locked columns or drag columns before them.
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.

Previous
 • 
Next
Help created on 9/19/2017