tk::tablematrix::spreadsheet(3pm) [debian man page]

TableMatrix::Spreadsheet(3pm)				       perl/Tk Documentation				     TableMatrix::Spreadsheet(3pm)

NAME

       Tk::TableMatrix::Spreadsheet - Table Display with Spreadsheet-like bindings.

SYNOPSIS

	 use Tk;
	 use Tk::TableMatrix::Spreadsheet;

	 my $t = $top->Scrolled('Spreadsheet', -rows => 21, -cols => 11,
				     -width => 6, -height => 6,
				     -titlerows => 1, -titlecols => 1,
				     -variable => $arrayVar,
				     -selectmode => 'extended',
				     -titlerows => 1,
				     -titlecols => 1,
				     -bg => 'white',
			   );

DESCRIPTION

       Tk::TableMatrix::Spreadsheet is a Tk::TableMatrix-derived widget that implements some bindings so the resulting widget behaves more like a
       spreadsheet.

       Bindings Added:

       o
	Row/Col resize handles appear when the cursor is placed over a row/col border line in the rol/col title area.

	Dragging these handles will resize the row or column. If multiple rows or columns are selected, then the new row/col size will apply to
	all row/cols selected.

	Note: With the base Tk::TableMatrix, it is possible to resize the row/cols by dragging on any cell border. To be more spreadsheet-like,
	Tk::TableMatrix::Spreadsheet  defaults to enable row/col resizing only thru the title row/col dragging. To override this default behavoir,
	set the -resizeborder option to 'both' at startup.

       o
	A popup menu for row/col insert/delete appears when the mouse is right-clicked in the row/col title areas.

       o
	Cells activate (i.e. the contents become edit-able) only when the cell is double-clicked or the F2 button is pressed. The default
	Tk::TableMatrix behavior is for the cell to be activated when the cell is single-clicked.

       o
	The Escape key causes any changes made to a cell to be canceled and the current selection cleared.

       o
	The return key causes the the current cell to move down.

       o
	The tab (or shift tab) key causes the current cell to be moved to the right (left).

       o
	The delete key will delete the current selection, if no cell is currently active.

       o
	The Mouse button 2 (middle button) paste from the PRIMARY. (Control-v pastes from the clipboard).

Additional Information
       Widget methods, options, etc, are inherited from the Tk::TableMatrix widget. See its docs for additional information.

Tk1.23								    2007-01-09					     TableMatrix::Spreadsheet(3pm)

Table(3pm)						User Contributed Perl Documentation						Table(3pm)

NAME

       Tk::Table - Scrollable 2 dimensional table of Tk widgets

SYNOPSIS

	 use Tk::Table;

	 $table = $parent->Table(-rows => number,
				 -columns => number,
				 -scrollbars => anchor,
				 -fixedrows => number,
				 -fixedcolumns => number,
				 -takefocus => boolean);

	 $widget = $table->Button(...);

	 $old = $table->put($row,$col,$widget);
	 $old = $table->put($row,$col,"Text");	# simple Label
	 $widget = $table->get($row,$col);

	 $cols = $table->totalColumns;
	 $rows = $table->totalRows;

	 $table->see($widget);
	 $table->see($row,$col);

	 ($row,$col) = $table->Posn($widget);

DESCRIPTION

       Tk::Table is an all-perl widget/geometry manager which allows a two dimensional table of arbitary perl/Tk widgets to be displayed.

       Entries in the Table are simply ordinary perl/Tk widgets. They should be created with the Table as their parent. Widgets are positioned in
       the table using:

	$table->put($row,$col,$widget)

       If $widget is not a reference it is treated as a string, and a Lable widget is created with the string as its text.

       All the widgets in each column are set to the same width - the requested width of the widest widget in the column.  Likewise, all the
       widgets in each row are set to the same height - the requested height of the tallest widget in the column.

       A number of rows and/or columns can be marked as 'fixed' - and so can serve as 'headings' for the remainder the rows which are scrollable.

       The requested size of the table as a whole is such that the number of rows specified by -rows (default 10), and number of columns specified
       by -columns (default 10) can be displayed.

       If the Table is told it can take the keyboard focus then cursor and scroll keys scroll the displayed widgets.

       The Table will create and manage its own scrollbars if requested via -scrollbars.

       The table can be emptied using

	$table->clear

       the widgets which were in the table are destroyed.

       The Tk::Table widget is derived from a Tk::Frame, so inherits all its configure options.

BUGS 
/ Snags / Possible enhancements
       o   Very large Tables consume a lot of X windows.

       o   No equivalent of pack's -anchor/-pad etc. options

SEE ALSO

       Tk::grid, Tk::HList, Tk::TableMatrix, Tk::MListbox, Tk::Columns

perl v5.14.2							    2010-05-29								Table(3pm)