Skip to content

start:

XMerge MiniCalc Plugin


Overview


The MiniCalc plugin converts text data between OpenOffice Calc format and MiniCalc's binary Palm DataBase file format.

Category Feature Supported
Formula


Cell References
 		yes

Add/Sub/Multiply/Divide
 		yes

Integers + Floating Points
 		yes

Functions
 		yes
Formatting


Font
 		no

Bold, Italic, Underline no

Colour
 		no

Alignment
 		no

Using the MiniCalc plugin


The MiniCalc plugin is invoked in the same manner as all other XMerge plugins.   Once the framework has been made aware of the plugin, the only thing needed to use it is to specify its MIME type as a source or destination type for conversion.  The MIME type is specified in the converter.xml file included in the minicalc.jar file.  Currently, this is set to application/x-minicalc .

For example, to use the MiniCalc plugin in conjunction with the test driver supplied with the XMerge framework:

% java org.openoffice.xmerge.test.Driver -from staroffice/sxc -to application/x-minicalc Test.sxc

% java.org.openoffice.xmerge.test.Driver -from application/x-minicalc -to staroffice/sxc Test.pdb

Features

This converter supports basic spreadsheet functionality. It does not support embedded graphics or styles, as these are not supported by MiniCalc.


StarCalc SpreadSheet Orig
                                                                                Original StarCalc Document

Converts to

              PDBOrig                                                PDB mod
                                Converted Document                                                                          Converted Document with Edits

Merging 

   When changes have been made on the small device, the user can either choose to convert the modified MiniCalc Palm Database to a reduced content and style StarCalc file, or the user can choose to merge the content changes made with the original StarCalc Document. In this way, new edits can be retained whilst also retaining document styles and formatting . To merge the modified MiniCalc DataBase, the XMerge test driver program may be used again.

        
% java.org.openoffice.xmerge.test.Driver -from application/x-minicalc -to staroffice/sxc -merge Test.sxc Test.pdb

   
 
StarCalc SpreadSheet Mod
                                                      Original StarCalc Document with Merged  Edits

Building the plugin

The MiniCalc plugin is not currently built as part of the XMerge framework.