Table Boxes

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.