spreadsheets
I use the sc tool for spreadsheets needs.
It isn't the most powerful or versatile tool, but it gets the spreadsheets job right.
shortcuts
moving around
Z
: hides a row or columns
: shows a row or columng<XY>
: Jump to cell (e.g.gB13
jumps to cell B13)i
: Insert a row or a columnm<c>
: Mark cell as character (e.g.mu
marks cell asu
)c<c>
: Copies the content of the cell marked with the given character (e.g.cu
copies the content of the cell marked asu
)C-f
,C-b
: Page up / down
managing data
=
: Enters a numeric value or formula<
: Enters left-justified text\
: Enters centered text>
: Enters right-justified texte
: Edit a numeric valueE
: Edit a string valuex
: Clear cell's contentd[rcd]
: Delete a row (r
), column (c
), or cell (d
)y[rcd]
: Yank a row (r
), column (c
), or cell (d
)p[rcd]
: Paste a row (r
), column (c
), or cell (d
)
saving your project
@
: Force re-calculation of all rowsW<filename>
: Writes the sheets in a.txt
fileP<filename>
: Writes the sheets in a.sc
fileG<filename>
: Reads the sheets from a.sc
file