Spreadsheet

 Create Spreadsheet

From Option Menu in Dashboard view, select New list to bring up new list window
 
 Fields:
  • Title: enter name of the spreadsheet
  • Type: select Spreadsheet type by clicking on the spreadsheet icon
  • Columns: click the button to setup spreadsheet columns
  • Category: assign the spreadsheet to a specific category from the drop down menu
  • Note: enter any additional information about the spreadsheet

The Save button will get enabled once the Title field is filled in. Click Save to create the spreadsheet or Cancel to clear the fields.

 Column Setup

Click the Columns button to set up the columns in New Spreadsheet / Edit Spreadsheet windows
 
The column setup window lists all the columns already being created for the spreadsheet

Press + icon to add new column to the spreadsheet
Press - icon to remove particular column from the spreadsheet

Press any row to select and edit a column, this will bring up Column Setup dialog window

 
 Fields in Column Setup dialog:
  • Name: name of the column
  • Type: there are 4 types of columns available
    • Text
    • Number (enables analytical summary features)
    • Date (date, time, or date & time formats; time and date & time formats are available for Pro version only)
    • Boolean (shown as a checkbox in spreadsheet)
  • Weight: indicates how much of the space in the spreadsheet will be allocated to the column
  • Alignment: aligns text in column at center, left or right. (left and right alignments are available for Pro version only)
  • Summary: choices of summary analytics (enabled only for number column type) - sum, average, count, minimum, maximum;
    • average, count, minimum and maximum functions are available for Pro version only



 Edit, Delete, Export & Share Spreadsheet

Long click the spreadsheet in dashboard view to bring up the Spreadsheet context menu

 
List Options:
  • Edit list: edit the spreadsheet fields
  • Share list via email: email the spreadsheet as ListWizard format (can be opened by ListWizard app) or HTML format (Pro version only)
  • Export list to SD card: export the spreadsheet to SD card; the file will be stored under directory [SDCARD_ROOT]/listwizard/ with the same file name as the spreadsheet title
  • Delete list: delete selected spreadsheet

Spreadsheet View

Click or touch a spreadsheet in dashboard to bring up Spreadsheet detail view
 

 


There are two modes in spreadsheet detail view: View Mode and Edit Mode
In View mode, user can only view the spreadsheet
In Edit mode, user can add / edit / delete items and perform other operations

You can toggle between View Mode and Edit mode by clicking the Spreadsheet icon or from Option menu by pressing the phone Menu key

Context menu
contains most of the operations in Spreadsheet view
 Title Item
  •  Add item: add a row at the end of the spreadsheet
  • Insert item: insert an row under the selected item
  • Move up: move the row up one level
  • Move down: move the row down one level
  • Delete item: delete the row from the spreadsheet


Č
ą
ď
Support Team,
Nov 22, 2010, 8:12 PM
ą
ď
Support Team,
Nov 22, 2010, 8:12 PM
ą
ď
Support Team,
Nov 22, 2010, 8:41 PM
ą
ď
Support Team,
Nov 22, 2010, 8:51 PM
ą
ď
Support Team,
Nov 22, 2010, 8:00 PM
ą
ď
Support Team,
Nov 22, 2010, 8:42 PM