1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
|
<h1 align="left">
<img src="https://raw.githubusercontent.com/andmarti1424/sc-im/dev/logo.png" alt="sc-im" height="25%" width="25%">
</h1>
# NOTE 06/01/2023:
This project needs some help.
This is a one person project and lost sponsoring in the last months. There are only just a few left. 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 (see at the bottom), please do. Your help would be really appreciated!!
Thanks.
# sc-im
Spreadsheet Calculator Improvised, aka sc-im, is an ncurses based, vim-like spreadsheet calculator.
sc-im is based on [sc](https://en.wikipedia.org/wiki/Sc_(spreadsheet_calculator)), whose original authors are James Gosling and Mark Weiser, and mods were later added by Chuck Martin.
## Some of the features of sc-im
- 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.
- Autobackup.
- Direct color support - specifing 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. The following alphabets are supported: English, Spanish, French, Italian, German, Portuguese, Russian, Ukrainian, Greek, Turkish, Czech, Japanese, Chinese.
- Sort of rows.
- Filter of rows.
- Subtotals.
- Cell shifting.
- Clipboard support.
- GNUPlot interaction.
- Scripting support with LUA. Also with triggers and c dynamic linked modules.
- Implement external functions in the language you prefer and use them in SC-IM.
- Use SC-IM as a non-interactive calculator, reading its input from an external script.
## Quick start
| 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 in sc format |
| j | Move down |
| k | Move up |
| h | Move left |
| l | Move right |
| goab12 | go to cell AB12 |
| u | undo last change |
| C-r | redo last change undone |
| yy | Copy current cell |
| v | select a range using cursor/hjkl keys |
| p | paste a previously yanked cell or range |
| ir | insert row |
| ic | insert column |
| dr | delete row |
| dc | delete column |
## Screenshots
## Installation
### Dependencies
* Requirements:
- `ncurses` (best if compiled with wide chars support)
- `bison` or `yacc`
- `gcc`
- `make`
- `pkg-config` and `which` (for make to do its job)
* Optionals:
- `tmux` / `xclip` / `pbpaste` (for clipboard copy/paste)
- `gnuplot` (for plots)
- `libxlsxreader` (for xls support)
- `xlsxwriter` (for xlsx export support)
- `libxml-2.0` and `libzip` (for xlsx/ods import support)
- `lua` (for Lua scripting)
- threads support (in case you want to test this in Minix, just disable autobackup and HAVE_PTHREAD)
### Manual
* Edit [`src/Makefile`](src/Makefile) according to your system and needs:
```
vim src/Makefile
```
* Run `make`:
```
make -C src
```
* Optional: You can install the binary `sc-im` in your system by typing with a privileged user:
```
make -C src install
```
### Building on OS X
You can follow the instructions as above, but if you would like Lua scripting
support, you will need to install Lua 5.1, which you can do with,
```
brew install lua@5.1
```
And then follow the instructions as above.
### Homebrew for OSX users
```
brew install sc-im
```
### Ubuntu with XLSX import & export
See [this wiki page](https://github.com/andmarti1424/sc-im/wiki/Ubuntu-with-XLSX-import-&-export).
### Other distros / OS
Please check [wiki pages](https://github.com/andmarti1424/sc-im/wiki/)
### Configuration
The `scimrc` file can be used to configure `sc-im`. The file should be placed in the `~/.config/sc-im` directory.
Here is an example `~/.config/sc-im/scimrc` :
set autocalc
set numeric
set numeric_decimal=0
set overlap
set xlsx_readformulas
Other configuration variables are listed in the [help file](https://raw.githubusercontent.com/andmarti1424/sc-im/freeze/src/doc).
### Issues and questions
Please open an issue if you find a bug.
If you are now sure if its a bug, please take a look at the discussions and/or ask there.
If you have a question please check out current discussions and if you still are in doubt, open a discussion as well.
If you want to ask for a feature request, the same, check out current discussions.
Thank you!
### Tutorial
[sc-im tutorial](https://github.com/jonnieey/Sc-im-Tutorial)
### Related projects
- [vim-scimark](https://github.com/mipmip/vim-scimark) - Vim plugin, edit embedded markdown tables with sc-im in vim terminal.
### Helping us
Want to help? You can help us with one or more of the following:
* giving sc-im a star on GitHub
* taking screenshots / creating screencasts showing sc-im
* making a donation (see below).
* telling if you use it / like it. I really don't have a clue if this app is used by someone.
### Donations
If you like sc-im please support its development by making a DONATION with Patreon or PayPal.
It would really help a lot.
<a href="https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=U537V8SNQQ45J" target="_blank">
<img src="https://www.paypalobjects.com/en_US/i/btn/btn_donate_LG.gif" />
</a>
If you wish to make a donation, please click the above button or just send money to scim.spreadsheet@gmail.com via PayPal, choosing "Goods and Services".
or with Patreon.
Thank you!
|
