MicroCalc is a spreadsheet aplication for java enabled devices, such as mobile phones and PDA. You can find list of phones supporting java technology on Sun's site.

Currently MC2 (MicroCalc 2) is under development, a beta version is available here (new site)

MC2 is based on a Lisp kernel and it allows to write macros both on phone and in .jar file. User interface is also customizable in Lisp.

The current version of Microcalc (MC) is 0.7.8 (updated 17 Nov 2004). It's available in several packages:

• basic package for general j2me enabled device: microcalc.jad & microcalc.jar. No additional midlets are included into the package, size under 32k.
• package for Siemens phones (includes export utility to SYLK file): microcalc45sylk.jad & microcalc45sylk.jar.
• MicroCalc Lite: microcalclite.jad & microcalclite.jar - the same as basic package with some features removed to keep jar file size within 30k. Use this on Nokia 3590, 6310, or any other that cannot run the basic package because of midlet size limitation.
• PRC file for use on Palm OS devices: microcalc.prc.

Basic package can be obtained from www.handango.com (for free).

Before installing MC on your device you can test it online in browser in applet emulator. Make sure your browser supports applets, and that this option is enabled in it. We recommend to use Sun's Java available from java.sun.com. You need only JRE (java runtime environment) to run the emulator.

You can download the documentation as a single pdf file (~130kb). Here is its online online version.

MicroCalc midlet is freeware for individual use. But we may charge a fee in future for using MC network server to synchronize your data between phone and PC.

• precision: fixed point decimals with 24 bits for the fraction (40/24).
• operators: + - * / () & (string concatenation) ^(power), comparison operators: = != < > <= >=
• functions: SIN,COS,TAN,COT, ASIN,ACOS,ATAN,ATAN2, SQRT,LN,ABS,EXP,POW, SUM, logical: IF,AND,OR
• constants: PI(),E() (don't forget the brackets - they're implemented as functions without arguments)
• storing sheets in record store
• data types: boolean, long, decimal, string, datetime
• cell formatting options (for numbers and date time at the moment)
• pointer support (use pointer to select a cell, and click again to edit it)

• to enter a formula in a cell use '=' character before expression. Otherwise it's considered as a constant (a decimal or a string one), example: =1+2/3-6
• to refer to the cell type its address, example: =B2+1-3. You can use ranges ie A1:B3 as well: =1+sum (A1:B5,3,7.8+1)
• you can see the name of the currently edited sheet in menu item Sheet.../Save Sheet.
• numbers are right aligned, strings are left aligned
• some kind of BNF grammar used in cell formulas can be found here.
• you can use GOLD key (#, pound) to type number without entering cell edit screen, it's simplier - just press <#> <0>, type value, then <#> again to finish input. Use STAR to enter the decimal dot, double STAR to enter negative value. There're also few options available via GOLD key:
  • <#> <1> - copy cell
  • <#> <2> - paste cell
  • <#> <3> - screen up
  • <#> <6> - screen down
  • <#> <4> - screen left
  • <#> <5> - screen right
  • <#> <9> - cell info mode - cell formula is shown in status bar.
• a tip for users of Siemens phones without MMC cards - to save space on device you can use MC lite, and to export sheets in SYLK format use Siemens SL45i (or other) emulator on PC with full MC package installed (with SYLK midlet). To get sheets from phone just copy content of 'storage' subfolder to PC in Siemens explorer (this tip was provided by Die Amme who uses MC on M50 phone). Siemens phone emulator is part of Siemens J2ME SDK (SMTK) and is available from siemens site (don't remember exact url).
• SonyEricsson P800 HOWTO (thanks to Mats Nummelin for providing this info).

1. 1L - long ('L' character at the end)
2. 1.234 - decimal (with decimal dot, or by default)
3. true - boolean (true/false)
4. "text string" - string (in expressions)
5. '12345 - string (in a cell)
6. A1:B2 - cell reference (relative)
7. $B$2 - cell reference (absolute)
8. #2/10/2002# - date- DD/MM/YYYY format (in expression)
9. 2/10/2002 - date in cell value
10. 2/10/2002 15:35:10 - date with time (HH:MM:SS)
11. 10:40 - time (today)

1. =sin(a1)^2+cos(a1)^2 returns 1
2. =sum(a1:b4)
3. =sin(pi()/2) - returns 1
4. =exp(10) - the same as =E()^10
5. =if(or(a1=1,a=3),"a = 1 or a = 3","else")
6. =#2/10/2002#+1 - next day (3/10/2002)

• sheets can't be saved on Sharp GX-10 phone. If you've got one please test MC Lite and report if it has the same problem.
• basic package may be too large to install on Nokia 6310 (jar is larger 30k), use MC Lite instead.
• heap memory overflow, you may expect this problem even there're no many cells on a sheet. It is reported for Nokia 6310i and Siemens SL45i. Seems that it is some kind of garbage collector bug in siemens j2me implementation. Please inform us if you have any information on this matter.
• after inserting/deleting rows/columns dependencies may be not recalculated correctly. You can force recalcutaing by editing depended cells, or by reopening the sheet.
• If you come across a bug please report to mixaz@mail.ru.

• SonyEricsson P800
• SonyEricsson T610
• Motorola iDEN i50sx
• Motorola Accompli 008/6288
• Motorola Accompli 388
• Nokia 6310i
• Nokia 3410
• Nokia 3510i
• Nokia 7650
• Nokia 7210
• Nokia 6100
• Nokia 6230
• Nokia 6610
• Nokia 5100
• Siemens SL45i
• Siemens M50
• Siemens MT50
• Siemens S55
• Siemens C55
• Siemens C60
• Sharp TQ-GX10 [limited workability, see bugs section]
• Sanyo SCP-4900 (Sprint PCS)
• Samsung SGH X100
• [please report if you managed to run microCalc on other device]

MicroCalc should work on any J2ME MIDP 1.0 compatible device, you can see the list of phones supporting J2ME at Sun's site. It also works on Sun's MIDP for Palm OS.

This software is distributed under GPL. Source code is available from www.sourceforge.net, or from this site: mc_0.7.9.zip.

The software is distributed without charge both for individual and commercial use. But in the last case (selling, distributing along other software/hardware, publishing, etc) you have to obtain a written permission from WAP INDUSTRIAL (still free of charge).

MicroCalc source code was used in NorbSoft's nSheet.

This program uses MathFP software library developed by Onno Hommes, jScience Technologies.

We use MicroEmulator for MC demo.