Skip to content

SCIM command examples

mutagenfork edited this page Jan 16, 2019 · 11 revisions

`e = edit number E = edit text b = back w = forward dd = delete r = redo 5ir = insert 5 rows 9dr = delete 9 rows download =@avg(B1:B4) = average contents of B1:B4 =@sum(A2:A10) To paste and adjust cell references: Pc To import xlsx formulas: scim --xlsx_readformulas test.xlsx 30Zr = zap 30 rows

sc /usr/share/doc/sc/tutorial.sc

http://n-t-roff.github.io/sc.1.html

fl = increase column width fh = decrease column width

hjkl — vi keys motion (or cursor keys). gB13 — go to cell B13. ir, ic — insert row, insert column. ma (mb, mc and so on) — “mark” cell as a (or b, or c and so on). ca (cb, cc and so on) — copy contents previously marked with ma. Ctrl-f, Ctrl-b — page up or down (also pgup, pgdown). dr, yr, pr — delete row, yank row, put row. dc, yc, pc — delete column, yank, put column. dd, yd, pd — delete, yank, put a cell. = — enter a numeric value (25 or F13-D14) or formula (@sum(A2:A145)). < — insert left-justified text. \ — insert centered text.

— insert right-justified text. x — remove cell. W<filename.asc> — write plain-text file. P<filename.sc> — write an .sc file. G<filename.sc> — read (“get”) an .sc file. Zr, Zc — zap (hide) row or column. sr, sc — show row or column. @ — force re-calculation. e — edit a numeric value. E — edit a string value.`