ClarkSheets 1.1.0

Shell based spreadsheet application

Clark Sheets

Clark Sheets is a shell based spreadsheet application.

Features

• Supports 32768 rows and 702 columns
• Copy/Paste
• Quick scroll
• Go to any coordinates on the grid
• Undo/Redo
• Insert and Delete rows/columns
• Search

Installing

install with pip

pip install ClarkSheets

Using the Program

There are 2 ways to use the program:

1. You can run it with python3 on a CSV file and start using it, ex:

python3 Clark_Sheets.py some_file.csv

2. You can also pass in a series of commands as extra arguments and the program will open the file passed in, execute the passed in commands, save the data, and exit

python3 Clark_Sheets.py some_file.csv command1 command2

key_mappings.py has all the key mappings for the commands, you just have to send those in. Currently the program can only insert and delete rows and cols.

Running the tests

Go into test_cases and each subdirectory to run each test case(I will make a bash script to run all of them at once soon)

Things I'd like to add

• individual resizable columns
• general resizable columns
• perhaps multiple pads to increase the dimensions this program can handle (right now I am only using one pad and it's max dimensions seem to be 32768 rows by 702 cols)
• when searching implement a next option to cycle through all matches
• customizable key key_mappings
• formulas
• Better testing, as well as testing more features such as go_to, quick_scroll, things that don't impact the data but could cause crashes because they move off screen
• when passing in extra commands, be able to write data

Contributing

Will figure this one out after our meeting as I(Clark) am not the creator of this repo and am not aware of the permissions granted to contributors

Authors

Clark Chan