#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