This repository has been archived by the owner on Nov 4, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 3
/
README.md~
58 lines (34 loc) · 1.47 KB
/
README.md~
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
#Text Excel
By Ryan Chan
For AP Computer Science 2016
Feel free to take inspiration from my code, just don't copy/paste it! If you have any questions, feel free to approach me in class.
##Usage
All commands must be in lowercase and typed perfectly. Error handling has not yet been fully implemented
Supported Commands:
* print
* Prints out the entire table
* quit
* Quits the program
* [Cell]
* Prints out the specified cell
* [Cell] = [Value]
* Sets [Cell] to [Value]
* Possible [Value] types and syntax:
* String: "input string"
* Double: 5
* Date: 1/12/1976
* Formula: ( 5 + 3 / 2 * A3 )
* Numbers in a formula can be substituded with a Cell address that contains a double
* The avg and sum commands can be used inside of a formula, ex. ( avg A1 - C2) will take the average of all cells inside the block of cells from A1 to C2
* clear [Cell]
*Clears the specified cell
* clear
*If no arguments are passed, clears the entire table
* save [File]
* Saves current spreadsheet to file named [File] in the current directory
* load [File]
* Loads spreadsheet from file named [File] in the current directory
* sorta [Cell1] - [Cell2]
* Sorts double and formula cells within the specified cell block from [Cell1] to [Cell2] in ascending order
* sortd [Cell1] - [Cell2]
* Sorts double and formula cells within the specified cell block from [Cell1] to [Cell2] in descending order