1TableMatrix::Spreadsheet(3)  perl/Tk Documentation TableMatrix::Spreadsheet(3)
2
3
4

NAME

6       Tk::TableMatrix::Spreadsheet - Table Display with Spreadsheet-like
7       bindings.
8

SYNOPSIS

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

DESCRIPTION

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

Additional Information

73       Widget methods, options, etc, are inherited from the Tk::TableMatrix
74       widget. See its docs for additional information.
75
76
77
78Tk1.29                            2023-01-20       TableMatrix::Spreadsheet(3)
Impressum