Simple Spreadsheet Instructions

I’ve been asked several times to put the instructions for Simple Spreadsheet online so that they can be referred to while using the application.
These are taken directly from the About page in the application. I’ll try to keep both copies up to date.

This application is still in Beta. While very functional and almost complete, please do expect frequent updates (for new features and bug fixes) and uncaught bugs (which should, hopefully, be few). If you find a bug, please email me to let me know so that I can fix it for the next release.

Main menu:
– Hit Create to create a new sheet. You will be asked for a filename, and the file will be created on the SD card. When you exit the app, or click on ‘Back’ to go back to this main menu screen, the application will automatically save the file
– Hit Load to load previously saved files. A list will be presented. Long-press on any file to rename, delete, copy, or mail the file. Single tap to load the file.
– Hit about to load this screen! šŸ˜‰ Shows the instructions and the changelog. And the donate button!
– Hit exit to exit the application.

Editing, and Longpress
– Single tap a cell to select it and enter some text. Defaults to entering just numbers (signed and decimal). To enter a formula, press the = button. Press the < button to move the cursor one char to the left, > for one character to the right. Press F(x) button to display a list of functions (only when there is an = in the formula). To enter normal text, long-press the = button.
– When entering a formula, tapping on a cell will insert the cell name at the cursor. Long-press on the input area, or press the f(x) button, to bring up a list of available formulae, a description of what they do, and how to use them. Tap on the formula you want and it will be inserted into the input area for you.
– Long press on a selected cell to change the attributes of the cell – text and background colours, borders, and text formatting and alignment.
– Long press on an unselected cell (with one already selected) to select a range. Long press on this range to change the attributes of all of the selected cells
– Tap of a column name (the letters) to select a column. Swipe finger right and left on the main sheet to change the width. Long press on the selected cells to change their attributes. Long press on the selected column’s name to insert or delete. Long press on an unselected column’s header to expand the range of selected columns. Long press the header of the selected columns to insert/delete multiple columns. Slide finger left/right to resize all of the selected columns
– This also works for rows!
– Tap the top-left corner (above the A and left of the 1) to select the entire sheet. Again, long press the selected cells to change the attributes.
– The back button will 1) close the keyboard if open, 2) unselect a cell if selected, 3) exit to the main menu (saving the file) if nothing is selected.
– The DPad keys work as follows:
— once a cell is selected, the DPad up/down/left/right will select the next corresponding cell.
— pressing the centre button will start a range-selection. Pressing up/down/left/right will then extend the range. Long-press the range as usual to set the attributes.
– When using the DPad, if you select a cell off the screen the screen will scroll according. The app will attempt to keep the full cell on the screen, unless the cell is wider or higher than the screen.

Remember, long press is your friend. Most things are done with long press.

Attributes Window:
– for an individual cell, it will display what is currently set, and allow you to set/unset borders, text style (italics, bold, underline, strikethrough), alignment (left, right, centre), and text and background colour.
– for a range (including column, row, or full sheet), it will not display what is currently set. However, within each tab, those settings will be left unchanged in all of the selected cells unless you change something. Eg. if you set the background colour to be black, the individual foreground colours will not be changed; if you change a border, all borders will be reset, but text alignment would remain unchanged.
– For the top row of the 2 colour tabs, the first colour is default. The default colour is black text and white background. This can be changed for your entire sheet by selecting the whole sheet, long pressing to bring up the attributes window, and setting a foreground and background colour. This new default will be for the current file only.
– If you set a column or row background colour, all used cells in that column/row will have their backgrounds changed. If there is an unused cell at the intersection of a colours row and column, the colour of that cell will be a blend of both colours. A used cell’s background at an intersection will be set to whichever colour was set last

Formulae:
– currently, only ranges of the type A1:B24 are supported. If you need a full column, you can use B1:B500. [eg. =sum(B1:B500) ]
– All formulae must start with =, otherwise they will be assumed to be just text. Press the = button to start a formula. If you are in text-entering mode (as opposed to just numbers), you can press = on the keyboard too.
– If you want to add a string as part of a formula (for example, a date), surround it with double-quotes: =\”String\” =\”7/5/1997\” =dow(\”7/5/1997\”)
– When entering a formula, it will be checked for syntax as you enter it. If the text is all red, the syntax is not yet valid, and the point of the error will be underlined. If valid, the formula will appear in black text, with any cell references or ranges coloured. The cells and ranges will be boxed with the same colour on the sheet.
– When you hit the Next button on the keyboard (or the back button) to commit the formula, if there are any syntax errors you will be prompted with an error message telling you what the error is. If all is OK, the formula will be calculated. If there is a cyclical reference, you will receive an error (eg. If cell A5 refers to cell B7, and cell B7 refers to cell A5). If there is an error in calculation, the cell will display @ERROR.
– Dates are accepted in several formats – the application will try to parse the dates using several methods, based on your locale. So in the US, dates can be entered in MM/DD/YYYY format, and for most of the rest of the world in DD/MM/YYYY format. Times can be included. Integers can be added to dates. If a date is invalid and used in a formula, #DATE will be displayed.
– String values can be added together using the + operator – this will append one string to another, eg: =\”Spread\”+\”Sheet\” will display SpreadSheet. Trying to add a number and string this way will cause the number to be treated as a string. =\”String\”+5 will give String5. If the string is a date, adding an integer will add to the date. =\”28/2/1999\”+1 will display 1/3/1999 (UK locale)
– For functions that accept ranges, String values will not be included in the calculation, but the cells will count for calculating AVG(). Empty cells will be counted as a 0
– Math functions will display NaN if there is a numerical error in calculation, such as divide by zero, or asin() of a number outside of the range -1 to +1.

Menu Button
– When the menu button is pressed, a menu will appear with several options
1) Export – this will export the displayed (calculated) values to a CSV file on the SD card. On your PC, this will appear directly on the SD card, not in any folder.
2) Zoom – this will allow you to select a zoom level, from 25% to 200%
3) Freeze – this will allow you to freeze the first row, the first column, both, or neither
4) Copy – this will copy the selected cells, whether a single cell, range, row, columns, or the full sheet.
5) Paste – this will paste the previously copied cells using the following rules:
– if a single cell was copied, that single cell will be pasted into the selected single cell, or all of the selected multiple cells (row, columns, range, all)
– if a range was selected, that range will be pasted starting at the single selected cell, which marks the top-left of the pasted range; or a range of the same size as the copied cells. If pasting into a range, it must be the same size as the copies range, so it’s probably best to just select a single cell as a top-left starting point.
6) More
> Copy Values – same a copy, but will copy the displayed values, not the formulae
> Recaulate All – recalculated all formalae on the sheet. Especially useful if you use rand()
> Save – this will save the file. The file is automatically saved with you exit the application or hit the back button to to back to the main menu. This allows you to save and keep editing.
> Save As – this will prompt you for a new file name and will save the file.
> Load another file – this will save and close your file and bring up the file list, as if you exited to the main menu and clicked on the Load button.
> Scan Barcode – if you have the Barcode Scanner application installed, you can scan a barcode and the value will be inserted at the cursor.
> Device Info – information about your device, memory used, etc. Shows basic info initially – tap the text to view all the info available.

A note on permissions:
This application requires the following permissions on your phone:
– Full internet access is required for the embedded ads.
– SD Card permissions as so that files can be saved.

Advertisements
%d bloggers like this: