------------------------------ | Manual for SpreadSheet 1.0 | ------------------------------ 0.Introduction -------------- The default size for the matrix is 5 columns and 10 rows. This size can be changed in the "OPTIONS" menu. The minimum size is 6 rows and 1 column. The maximum depends on the memory available. This size should be kept as minimum as possible because the smaller it is, the faster the program is. The size can be changed later if neccesary. The number of columns shown in the screen can be changed in the options menu and it is between 1 and 10. The number of rows shown is fixed to 6. Each cell can contain numbers, formulae or strings. The calculations are not automatic. The command to recalculate the whole spreadsheet is in the "EDIT" menu. 1.Keys ------ The cursor keys move 1 cell to the right, left, up and down. The two big blue keys move one page up and down. The key "A" moves one page to the left. The key "Z" moves one page to the right. To write in a cell put the cursor on it and press "NEW". The key "MENU" opens the "FILE" menu. The key "Category" (between "NEW" and "SPACE") opens the "EDIT" menu. 2."FILE" menu -------------- It has 4 options: 1-Open: open a file. 2-Save: save a file. 3-Directory: opens the "Directory" menu. 4-Exit: Exits the program. Using the cursor keys two more menus can be accessed: "COMMS" and "OPTIONS". 3."COMMS" menu -------------- It has 2 options: 1-Download: downloads a spreadsheet from the PC. 2-Upload: uploads the current spreadsheet to the PC. When uploading the spreadsheet there are two options: numbers or formulae. If the file is uploaded with numbers no formulae will be saved in the PC. Choose this option to use the file with a spreadsheet program (like Excel). The program SPSheet has to be installed to use hose features. 4."OPTIONS" menu ---------------- It has 2 options: 1-Columns: changes the number of columns shown in the screen. 2-Cells: changes the size of the matrix used by the spreadsheet. 5."EDIT" menu ------------- It has 4 options: 1-Cut: cuts the current cell and copies it into the clipboard. 2-Copy: copies the current cell into the clipboard. 3-Paste: pastes the contents of the clipboard into the current cell. 4-Recalc: recalculates the whole spreadsheet. It may take a while. 6."Directory" menu ------------------ It has 5 options: 1-Open: opens the selected file. 2-Save: saves the current spreadsheet in the selected file. 3-Delete: deletes the selected file. 4-Next(or First): goes to the next page or to the first one if the current is the last one. 5-Exit: returns. The directory only shows the files created with this program. In the save option, if your selection is empty you will be asked to enter a file name. 7.Calculations -------------- To write a formula the first symbol has to be "=" and then the formula. The formula has to be entered in "inverse polish notation". This is the same way the operations are done in Hewlett Packard calculators. The operations allowed are: +, -, *, /. For example: to write "2 + 3" it should typed "=2 3 +". Note: there is no space between the "=" and the first number (2). The following numbers and operators are separated by one space. Another example: "3 * (2 + 8)" ==> "=3 2 8 + *" or "=2 8 + 3 *". In order to reference another cell, the symbols "$" or "#" have to be used, followed by the letter and number of the cell. For example: to make a sum of the cells A1 and B4 the formula would be: =$A1 $B4 + The difference between "$" and "#" is that the former is absolute reference and the latter is relative reference. For the moment the column and the row are referenced in the same way. 8.Errors ------------ The program can detect the following type of errors: * Errors in references: those errors are displayed in the cell. - Rec.ERROR: Recursivity error. - Bad.Ref.: Bad references. The references are out of limits. * File errors: those errors are displayed in a window. - File not found. - Bad filename. File name is max 7 characters. And spaces after characters is not recognized as the file name. * Formula errors: those errors are displayed in a window. - Stack error: the number of operands does not match the number of operations. - ERROR: unknown error in the formula. Note: Overflow errors are not handled.