Sc-im: Difference between revisions
From wikinotes
(→Usage) |
|||
Line 52: | Line 52: | ||
= Usage = | = Usage = | ||
<blockquote> | <blockquote> | ||
== Basics == | |||
<blockquote> | |||
help | |||
<syntaxhighlight lang="bash"> | |||
:h | |||
</syntaxhighlight> | |||
insert info | |||
<syntaxhighlight lang="bash"> | |||
= # enter a number or formula | |||
< # insert left-justified text | |||
> # insert right-justified text | |||
\ # insert centered text | |||
</syntaxhighlight> | |||
edit info | |||
<syntaxhighlight lang="bash"> | |||
x # delete cell contents | |||
e # edit number (vi) | |||
E # edit string (vi) | |||
</syntaxhighlight> | |||
syntax | |||
<syntaxhighlight lang="bash"> | |||
=a1 # ref to cell a1 | |||
=@sum(a1:a5) # sum a1-a5 | |||
</syntaxhighlight> | |||
navigation | |||
<syntaxhighlight lang="bahs"> | |||
w/b # jump forwards/backwards to filled cells | |||
v # visual select | |||
</syntaxhighlight> | |||
rows/columns | |||
<syntaxhighlight lang="bash"> | |||
f{h,j,k,l} # change cell height/width vi-style directionally | |||
{i,d}{r,c} # insert/delete row/column (supports vi-command number prefix) | |||
{Z,s}{r,c} # hide/show row/column | |||
</syntaxhighlight> | |||
</blockquote><!-- Basics --> | |||
== Functions == | |||
<blockquote> | |||
There are tons, you can even run lua scripts (see :help). | |||
<syntaxhighlight lang="bash"> | |||
@upper("abc") | |||
@lower("abc") | |||
@avg(A1:A5) | |||
</syntaxhighlight> | |||
</blockquote><!-- Functions --> | |||
== Saving == | |||
<blockquote> | |||
<syntaxhighlight lang="vim"> | |||
:w file.sc " write a (native) .sc file | |||
:e csv foo.scv " write a csv file | |||
:e mkd foo.mkd " write markdown table | |||
</syntaxhighlight> | |||
</blockquote><!-- Saving --> | |||
</blockquote><!-- Usage --> | </blockquote><!-- Usage --> | ||
Revision as of 17:09, 19 February 2024
A cli spreadsheet editor.<
An improved fork of sc
.
Supports:
- .sc
- .csv
- .tsv
- .md
- .txt
Imports from:
- .ods
- .xls
- .xlsx
Documentation
github https://github.com/andmarti1424/sc-im official docs https://github.com/andmarti1424/sc-im/wiki/SCIM-command-examples
Tutorials
gentoo wiki https://wiki.gentoo.org/wiki/Sc-im
Locations
~/.config/sc-im/scimrc
config
Install
aur sync sc-im
Usage
Basics
help
:hinsert info
= # enter a number or formula < # insert left-justified text > # insert right-justified text \ # insert centered textedit info
x # delete cell contents e # edit number (vi) E # edit string (vi)syntax
=a1 # ref to cell a1 =@sum(a1:a5) # sum a1-a5navigation
w/b # jump forwards/backwards to filled cells v # visual selectrows/columns
f{h,j,k,l} # change cell height/width vi-style directionally {i,d}{r,c} # insert/delete row/column (supports vi-command number prefix) {Z,s}{r,c} # hide/show row/columnFunctions
There are tons, you can even run lua scripts (see :help).
@upper("abc") @lower("abc") @avg(A1:A5)Saving
:w file.sc " write a (native) .sc file :e csv foo.scv " write a csv file :e mkd foo.mkd " write markdown table