sc-im Spreadsheets in Your Terminal

New release v0.8.5 - This project needs your help! This is a one person project and have very little sponsoring. I want to still maintain and develop sc-im, but I am the only income in my family and its becoming difficult to work as much as I would want. If you can make a donation, please do. Your help would be really appreciated!! Thanks.

Spreadsheet Calculator Improvised, aka sc-im, is an ncurses based, vim-like spreadsheet calculator.

sc-im is based on sc, whose original authors are James Gosling and Mark Weiser, and mods were later added by Chuck Martin.

Key Features

• Vim movements commands for editing cell content.
• UNDO / REDO.
• 65.536 rows and 702 columns supported. (The number of rows can be expanded to 1.048.576 if wished).
• CSV / TAB delimited / XLSX file import and export. ODS import. Markdown export.
• Key-mappings and Autobackup.
• Direct color support - specifying the RGB values, screen colors can be customized by user, even at runtime.
• Colorize cells or give them format such as bold, italic or underline.
• Wide character support for multiple languages including English, Russian, Japanese, and Chinese.
• Sort, Filter, and Subtotals functionality.
• Clipboard support and GNUPlot interaction.
• Scripting support with LUA, triggers and C dynamic linked modules.
• Use SC-IM as a non-interactive calculator, reading its input from an external script.

Basic Keybindings

| Key | Purpose | |---|---| | = | Insert a numeric value | | \ | Insert a text value | | e | Edit a numeric value | | E | Edit a string value | | x | Delete current cell content | | :q | Quit the app | | :h | See help | | :w filename.sc | Save current spreadsheet | | j, k, h, l | Move Down, Up, Left, Right | | u | Undo last change | | C-r | Redo last change | | yy | Copy current cell | | v | Select a range | | p | Paste a cell or range | | ir / ic | Insert row / column | | dr / dc | Delete row / column |

Requirements & Installation

Requirements: ncurses, bison or yacc, gcc, make, pkg-config, and which.

Build from source:

1. Edit src/Makefile according to your system.
2. Run make -C src.
3. Optional: make -C src install (with root privileges).

macOS Installation:

brew install sc-im

Configuration

The scimrc file can be used to configure sc-im. The file should be placed in the ~/.config/sc-im directory.

Example ~/.config/sc-im/scimrc:

set autocalc
set numeric
set numeric_decimal=0
set overlap
set xlsx_readformulas

If you like sc-im, please support its development by making a donation via Patreon or PayPal ([email protected]). Your help really makes a difference!