flipsheet - a Hiptop Spreadsheet

I have written a spreadsheet for the T-Mobile Sidekick, using Danger's Beta SDK.

Documentation

beta documentation

Normal flipsheet view

[Show a cell screenshot] [Show a cell screenshot]
[Cell Plan Comparison] [Division Result]

Menu

[Menu screenshot] [flipsheets menu screenshot]

Full Screen

Fullscreen (Menu-Shift-T and Menu-T) mode showing some background colors.

[Color Table]

Using the spreadsheet

[Using the spreadsheet screenshot] [Editing a formula screenshot]

Readme

flipsheet -- a spreadsheet for the hiptop (tm)
http://hipme.com/applications/flipsheet
See the file LICENSE.

flipsheet (c) 2003 Leigh L. Klotz, Jr. All Rights reserved
PRATT-PARSER Copyright 1990, George J. Carrette. All Rights reserved
BigDecimal Copyright IBM Corporation, 1996, 2000. All Rights reserved

* User Interface

** Menus
Action menu:
- About
- Toggle Tiling (Menu T)
- Mail (Menu M)
- Clear Sheet
- Import
- Evaluate On Load
- Sheet 0 -- Sheet 9 (Menu 0 - Menu 9)
- New Sheet (Menu N)

There are additional menu items when editing a cell.
There is a context menu when editing a cell.

** Keys
- Arrow and Wheel move the cursor.
- Space toggles Wheel scrolling direction.  
  See upper left cell.  Horizontal mode wraps.
- Typing inserts edit an empty cell.
- Enter edit a cell and selects all.
- Wheel Button edits a cell and puts cursor at end.
- Enter saves edit to cell and moves down or right (see Space)
- Wheel saves edit to a cell and does not move.
- Jump and scrolling out of a cell commit the edit.
- Back cancels edits.

** Hidden Shortcuts
Menu-Shift-V: 
  Edit CSV directly.  
  You must press Jump or Back to exit flipsheet in order to save your changes.
  Each line must have 3 elements, double-quoted if non-null.  
  No spaces after commas.
  Be careful with spaces the initial comment line.

Menu-Shift-D
  Clear master dependencies list.

** Syntax
- Expressions
Start with an "=" (equals).

- Numbers
Uses IBM BigDecimal package and preserves precision 
(i.e., 2/3 is different from 2.0/3.0 and 2.00/3.00 etc.).

-Strings 
May be quoted and must be if they are operator names.

** Functions
Ranges: A1:A3, A1:D1, A1:D3
Unary Math operations: - +
Infix Math operations: + - * / ^
Prefix cell/range operations:
sum(cells...)
product(cells...)
max(cells...)
min(cells...)
count(cells...)
debug(arg1,arg2...)
setcolor(fontcolor, cells...)
setbg(bgcolor, cells...)
Math Comparisons: < > <= >= = !=
Parentheses: ()
Boolean: ! | &  (1=true, 0=false)
if: returns a value: if(pred, consequent, alternative)

** Errors
Circular References:
All circular references must be cleared before calculation will resume
Other errors: show up in cell and syslog

* Bugs
- I have some code for making the wheel always go into horizontal mode
  and Menu Wheel always scroll vertically if the screen is closed, but
  it doesn't work and so I have no experience with it, so I don't know
  if it's a good idea.
- Menu-Scroll scrolls the screen but not the cursor, so once you move
  the cursor the screen jumps back.
- Import is in the menu but not implemented.
- See also the TODO file.

Availability

Soon coming...


See more Hiptop Software