Sc-im: Difference between revisions

From wikinotes
 
(2 intermediate revisions by the same user not shown)
Line 20: Line 20:
| github || https://github.com/andmarti1424/sc-im
| github || https://github.com/andmarti1424/sc-im
|-
|-
| official docs || https://github.com/andmarti1424/sc-im/wiki/
| official docs || https://github.com/andmarti1424/sc-im/wiki/SCIM-command-examples
|-
|-
|}
|}
Line 52: Line 52:
= Usage =
= Usage =
<blockquote>
<blockquote>
<syntaxhighlight lang="bash">
sc-im  # start program
</syntaxhighlight>
== 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 -->


Latest 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

sc-im  # start program

Basics

help 

:h

insert info 

=  # enter a number or formula
<  # insert left-justified text
>  # insert right-justified text
\  # insert centered text

edit info 

x    # delete cell contents
e    # edit number (vi)
E    # edit string (vi)

syntax 

=a1           # ref to cell a1
=@sum(a1:a5)  # sum a1-a5

navigation 

w/b  # jump forwards/backwards to filled cells
v    # visual select

rows/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/column

Functions

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

Configuration

Retrieved from "http://willpittman.net:8080/index.php?title=Sc-im&oldid=34628"