spreadsheet

This is a terminal-based spreadsheet that aims to feel familiar for people knowing excel.

The data is stored in simple CSV files. Consequently, formatting (e.g. left/right alignment or cell width) is not stored. The sheet can either be saved in source form (including formulas) or in evaluated form. A source file can also be evaluated without using the TUI by using the --eval command line option.

Key bindings

• Arrow keys and page up/down move the cursor
• Enter will start full edit mode. -, = or a digit will start quick edit mode. The difference between the two modes is the behavior of arrow keys: In full edit mode, arrow keys move the text cursor. In quick edit mode, arrow keys move the cell cursor (after submitting the changes).
• # - Start drag mode (blue). Move the cursor to a different cell and press enter. The area between the two cells will be filled with the formula from the first cell. References to rows and columns that are not prefixed with $ will be adapted.
• v - Start visual mode (green). You can then use y to copy ("yank") or d to cut ("delete") the selected cells. After that, you can use p to paste the copied contents somewhere else.
• Delete - clear the current cell
• >/< - increase/decrease the width of the current column
• w - Write the sheet to a file (source form).
• W - Write the sheet to a file (evaluated form).
• h - show help
• q - quit

Formulas

Cells can have the following values:

• Integer (e.g. 1)
• Float (e.g. 1.2)
• String (e.g. "foo")
• Formula (e.g. =A1 + 1)

Formulas can contains the following functions:

• sum(A1:B2) - calculate the sum of all fields from the given range
• min(A1:B2) - calculate the minimum of all fields from the given range
• max(A1:B2) - calculate the maximum of all fields from the given range
• power(a, b) - calculate a to the power of b
• exp(a) - exponential function
• sin(a) - sine function
• cos(a) - cosine function
• tan(a) - tangent function
• log(a) - natural logarithm
• bar(a) - draw a bar for a value between 0 and 1

Similar projects

• sc - spreadsheet calculator
• sc-im
• visidata - interactivly explore tabular data
• cell