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