blob: 367122c549af8d6b7c81cc884af61d717f55ca16 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
# The TUI Spreadsheet
Resources:
* <https://github.com/groessler/scim/blob/master/src/doc>
* <https://github.com/jonnieey/Sc-im-Tutorial>
## Basic editing
* `<`/`\`/`>`: insert left/center/right-aligned string
* `=`: insert numeric expression
* `e`: edit numeric
* If accidentally added to text field, can erase with `=<RET>` (inserting an
empty numeric value)
* `E`: edit string
* `ir`/`c`: insert row/column above/to the left
* `or`/`c`: insert row/column below/to the right
## Copying
* `mc`: (where `c` is a lowercase character) marks cell or range with `c`
* `cc`: (where the second `c` is a previous mark) copies content from mark into
current cell, preserving formatting and adjusting formula.
* `yy`: copy current cell/selection
* `Pv`: paste only the value
* `Pf`: paste only the formatting
* `yr`/`c`: yank row/column
* `p`: paste below/on the left
* `t`: paste above/on the right
## Movement
* `hjkl`
* `^`/`#`: move to top/bottom of column (bottom is the last filled cell)
* `0`/`$`: move to left/right of row (rightmost is the last filled cell)
* `goc3`: go to cell C3
* `g0`/`$`: move to left/rightmost visible column
* `c-e`/`y`: scroll down/up maintaining cursor position
* `zh`/`l`: scroll left/right maintaining cursor position
* `c-f`/`b`: scroll page down/up
## Hiding/unhiding
"Z" for "zap" when hiding.
* `Z[cr]`: zap current column/row.
* `S[cr]`: shows hidden columns/rows in selected range (select with c-v)
## Formatting
* `c-j`: auto-fit column width
* `{`/`|`/`}`: align text left/center/right
* `f-`/`+`: decrease/increase decimal precision
* `f<`/`>`: decrease/increase column width
### Scientific notation
:format "#.##e-#"
The two `#`s after the decimal point give precision. `e-` means scientific
notation, with sign only if the exponent is negative.
|