From 56f013973c92f198249bb22b9fa5ca8a15b627ed Mon Sep 17 00:00:00 2001 From: Marcin Chrzanowski Date: Wed, 1 Feb 2023 17:34:34 +0100 Subject: Add sc-im sheet --- sc-im.md | 61 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 sc-im.md diff --git a/sc-im.md b/sc-im.md new file mode 100644 index 0000000..367122c --- /dev/null +++ b/sc-im.md @@ -0,0 +1,61 @@ +# The TUI Spreadsheet + +Resources: + +* +* + +## Basic editing + +* `<`/`\`/`>`: insert left/center/right-aligned string +* `=`: insert numeric expression +* `e`: edit numeric + * If accidentally added to text field, can erase with `=` (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. -- cgit v1.2.3