1TableMatrix::Spreadsheet(3) perl/Tk Documentation TableMatrix::Spreadsheet(3)
2
3
4
6 Tk::TableMatrix::Spreadsheet - Table Display with Spreadsheet-like
7 bindings.
8
10 use Tk;
11 use Tk::TableMatrix::Spreadsheet;
12
13
14
15 my $t = $top->Scrolled('Spreadsheet', -rows => 21, -cols => 11,
16 -width => 6, -height => 6,
17 -titlerows => 1, -titlecols => 1,
18 -variable => $arrayVar,
19 -selectmode => 'extended',
20 -titlerows => 1,
21 -titlecols => 1,
22 -bg => 'white',
23 );
24
26 Tk::TableMatrix::Spreadsheet is a Tk::TableMatrix-derived widget that
27 implements some bindings so the resulting widget behaves more like a
28 spreadsheet.
29
30 Bindings Added:
31
32 ·
33 Row/Col resize handles appear when the cursor is placed over a row/col
34 border line in the rol/col title area.
35
36 Dragging these handles will resize the row or column. If multiple rows
37 or columns are selected, then the new row/col size will apply to all
38 row/cols selected.
39
40 Note: With the base Tk::TableMatrix, it is possible to resize the
41 row/cols by dragging on any cell border. To be more spreadsheet-like,
42 Tk::TableMatrix::Spreadsheet defaults to enable row/col resizing only
43 thru the title row/col dragging. To override this default behavoir,
44 set the -resizeborder option to 'both' at startup.
45
46 ·
47 A popup menu for row/col insert/delete appears when the mouse is
48 right-clicked in the row/col title areas.
49
50 ·
51 Cells activate (i.e. the contents become edit-able) only when the cell
52 is double-clicked or the F2 button is pressed. The default
53 Tk::TableMatrix behavior is for the cell to be activated when the cell
54 is single-clicked.
55
56 ·
57 The Escape key causes any changes made to a cell to be canceled and
58 the current selection cleared.
59
60 ·
61 The return key causes the the current cell to move down.
62
63 ·
64 The tab (or shift tab) key causes the current cell to be moved to the
65 right (left).
66
67 ·
68 The delete key will delete the current selection, if no cell is
69 currently active.
70
71 ·
72 The Mouse button 2 (middle button) paste from the PRIMARY. (Control-v
73 pastes from the clipboard).
74
76 Widget methods, options, etc, are inherited from the Tk::TableMatrix
77 widget. See its docs for additional information.
78
79
80
81Tk1.23 2020-01-30 TableMatrix::Spreadsheet(3)