SCIM command examples

Basic

@ — force re-calculation

= — enter a numeric value (eg, 25, F13-D14) or formula (eg. @sum(A2:A145)).

< — insert left-justified text.

\ — insert centered text.

> — insert right-justified text.

x — remove cell content.

e — edit a numeric value (vi-style editing)

E — edit a string value (vi-style editing)

b — back

w — forward

r — redo

Pc — paste and adjust cell references: Pc

Formulas

=@avg(B1:B4)

=@sum(A2:A10)

Formatting

fl — increase column width

fh — decrease column width

fj — increase row height

fk — decrease row height

Navigation

You can use arrow keys...

h, j, k, l — vi keys motion (or cursor keys).

gtB13 — go to cell B13.

Ctrl-f, Ctrl-b — page up or down (also pgup, pgdown).

Insert, delete, hide, show

ir, ic — insert row, insert column, eg. 5ir to insert 5 rows

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, eg. 9dc to delete 9 columns

Zr, Zc — zap (hide) row or column, eg. 30Zr to zap 30 rows

sr, sc — show row or column

Marking cells

ma (mb, mc, etc.) — “mark” cell as a (or b, or c, etc).

ca (cb, cc, etc.) — copy contents previously marked with ma.

File-handling

:e txt <filename.asc> — write plain-text file.

:e csv <filename.csv> — write csv file.

:e mkd <filename.mkd> — write mark down file.

:w <filename.sc> — write an .sc file.

Importing xlsx formulas

sc-im --xlsx_readformulas test.xlsx

Other resources

• The embedded help is launched using command :help