This page has been robot translated, sorry for typos if any. Original content here.

Excel for mobile phone

We continue to get acquainted with useful applications for mobile devices that support Java technology. Today, following the good diligence, we will work closely with the J2ME-application MiniExcel, differing not only in the wealthy functionality of the table processor, but also in the ability to export data to "large" Excel. But about everything according to the schedule.

Requirements for the "hardware", the cost is also the installation of the program

For work with a mobile table processor, almost any phone with support for MIDP 1.0, 2.0 specifications will also work with 56 KB of free memory to run the application. The need for the characteristics of the display is also not so critical. Of course, on the color screen to see the interface of the program is much more pleasant, but in the absence of this, monochrome will come down too. By the way, you can see the list of compatible devices on the developer's site. True, having run through the eyes of the above models, it is permissible to conclude that the above list is far from complete (apparently, the web designers of the company Simprit do not have time for the labor achievements of the phone manufacturers). If you plan to save MiniExcel data on a remote server, then you need to take into account a couple of moments. First, you must first activate the mobile network access service. Secondly, you need a computer with a dedicated IP address on the Internet also installed software MiniExcel Connection Manager, performing server functions on the machine. Before installing the server software, make sure that the Java Runtime Environment version 1.4 or higher is installed on the computer.

Java-midlet MiniExcel (61 kb) is available in the Downloads section of the developer's website or through WAP at http://www.simprit.com/wap.wml.

The cost of the application is 10 US dollars, but those who wish to experiment before purchase will benefit from a free thirty-day version of the program.

The owners of BlackBerry smartphones are also not forgotten: they have their own version of MiniExcel. This program is also a functional richer also at a price more expensive ($ 25).

MiniExcel Performance Specifications

The list of features included in the program is quite impressive, so we will limit ourselves to only a modest enumeration of the main functions, later on we will gradually switch to some features of work with the keyboard.

So, in stock at MiniExcel:
• Working with tables containing up to 26 columns (from A up to Z) also 99 lines (from 1 up to 99). The number of cells can vary depending on the number of available memory
• Perform basic arithmetic operations (addition, subtraction, multiplication, crushing, construction to a power), including support for comparison operations
• Manipulation of different types of data
• Support for trigonometric, logical and mathematical functions
• Work with text values, including the time is also the date
• The presence of a clipboard with the ability to copy as individual cells, as well as entire data areas. It is permissible here to include the manipulation of columns as rows (inserting, deleting, changing the width of columns)
• Support of function keys
• Save data (as separate sheets) in the device memory or on an external Internet server
• Integration with Microsoft Excel also with Intuit's Quicken financial product line

Naturally, all this scop of operations you need to somehow manage, and with a tiny telephone keypad, which the developers have equipped with four modes of operation.
The main mode Browse ("Browse") is used to move through cells, rewind pages, go to the beginning / end of the table. For this mode, the joystick, which most of the modern phone models are equipped with, is the best way. Pressing the joystick or the "5" button switches the keyboard to the data entry mode.

Various keyboard modes (screenshots from the developer's website)

A couple of other modes - F1 also F2 - contain the most frequently used control functions of the program. Among them: insert / delete columns / rows of the table, change the width of columns, conclude information on free memory, save documents and work with the clipboard. In the program parameters it is allowed to configure the server configuration (address, user's login / password), change the format of numeric data, pores also dates.

MiniExcel Connection Manager

We will install the MiniExcel server on your computer. For this we download the archive miniexcel-cm.zip (1.6 Mb) from the developer's website and also slowly unzip it. As a situation, if the path to the Java interpreter (java.exe) is correctly registered in PATH environment variables, then it will be enough to start the application two times once by clicking on it with the mouse. Otherwise, manually go to the bin directory of the installed Java-machine and also open the server application with the command java.exe -jar miniexcel-cm.jar.
From the mandatory settings, care must be taken to the port on which the traffic exchange between the customer and the server will proceed. In addition, do not forget to look in the User Info menu to edit the list of users who will be allowed access to the resources of the manager. Note that for an unregistered version, only one user with the name test is available, also with the password password. Lastly, click the "Test connection" button to test the Internet connection.

MiniExcel Connection Manager

Manager Settings

Now we pick up the phone in the settings of MiniExcel (Settings -> Server) and specify the coordinates of our server, including the login / password of the new user. Everything, now at any time it is allowed to save the table data on the server side (Options -> Sheet -> Save to server).
Specifically, all data sent to the server is stored as ordinary XLS files that are opened by the "mature" Excel program. Thus, it is allowed to copy the excel file to the server for further work with it from a mobile phone. Unfortunately, the attempt to save the act with the Cyrillic alphabet on the server was not successful (the font encoding is distorted), but it is possible to pronounce Russian-language tables without problems.

Summing up

Of course, MiniExcel deserves respect, if only because its developers managed to combine so many features in such a small application. From the positive aspects of this program, we will allocate a wealthy functionality, low demand for telephone resources, low cost, as well as export data to Excel. In the negative, we will write down only one-sided work with the Cyrillic alphabet.