| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> |
| <html> |
| <head> |
| |
| <meta http-equiv="content-type" |
| content="text/html; charset=ISO-8859-1"> |
| <title>xml.openoffice.org</title> |
| |
| </head> |
| <body> |
| |
| <h1>XMerge MiniCalc Plugin</h1> |
| <br> |
| |
| <h2><font color="#cc0000">Overview</font></h2> |
| <br> |
| The MiniCalc plugin converts text data between OpenOffice Calc |
| format and MiniCalc's binary Palm DataBase file format. <br> |
| <br> |
| <table cellpadding="4" cellspacing="1" bgcolor="#f0f0f0" width="50%"> |
| <tbody> |
| <tr align="center"> |
| <th bgcolor="#00315a"><font color="#ffffff" |
| face="Arial, Helvetica" size="2"><b>Category</b></font></th> |
| <th bgcolor="#00315a"><font color="#ffffff" |
| face="Arial, Helvetica" size="2"><b>Feature</b></font></th> |
| <th bgcolor="#00315a" width="20%"><font color="#ffffff" |
| face="Arial, Helvetica" size="2"><b>Supported</b></font></th> |
| </tr> |
| <tr> |
| <td valign="top" bgcolor="#99ccff" align="center"><font |
| color="#00315a" face="Arial, Helvetica" size="2"><b>Formula</b></font> |
| </td> |
| <td valign="top" bgcolor="#99ccff"><br> |
| </td> |
| <td width="20%" valign="top" bgcolor="#99ccff"><br> |
| </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Cell References<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">yes<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Add/Sub/Multiply/Divide<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">yes<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Integers + |
| Floating Points<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">yes<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Functions<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">yes<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top" bgcolor="#99ccff" align="center"><font |
| color="#00315a" face="Arial, Helvetica" size="2"><b>Formatting</b></font> |
| </td> |
| <td valign="top" bgcolor="#99ccff"><br> |
| </td> |
| <td width="20%" valign="top" bgcolor="#99ccff"><br> |
| </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Font<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">no<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Bold, Italic, |
| Underline</font></td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">no<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Colour<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">no<br> |
| </font> </td> |
| </tr> |
| <tr> |
| <td valign="top"><br> |
| </td> |
| <td valign="top"><font face="Arial, Helvetica" size="2">Alignment<br> |
| </font> </td> |
| <td width="20%" valign="top"><font face="Arial, Helvetica" |
| size="2">no<br> |
| </font> </td> |
| </tr> |
| |
| </tbody> |
| </table> |
| |
| <h2><font color="#cc0000">Using the MiniCalc plugin</font></h2> |
| <br> |
| 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 |
| <code>converter.xml</code> file included in the minicalc<code>.jar</code> |
| file. Currently, this is set to <code>application/x-minicalc</code> |
| .<br> |
| <br> |
| For example, to use the MiniCalc plugin in conjunction with the |
| test driver supplied with the XMerge framework:<br> |
| <br> |
| |
| <blockquote> |
| <pre>% java org.openoffice.xmerge.test.Driver -from staroffice/sxc -to application/x-minicalc Test.sxc<br><br>% java.org.openoffice.xmerge.test.Driver -from application/x-minicalc -to staroffice/sxc Test.pdb<br></pre> |
| </blockquote> |
| <br> |
| |
| <h2><font color="#cc0000">Features</font></h2> |
| This converter supports basic spreadsheet functionality. It does not support |
| embedded graphics or styles, as these are not supported by MiniCalc.<br> |
| <br> |
| <br> |
| <img src="images/spreadsheetorig.jpg" alt="StarCalc SpreadSheet Orig" |
| width="925" height="562" border="1"> <br> |
| |
| |
| |
| |
| <i>Original |
| StarCalc Document </i><br> |
| <br> |
| Converts to<br> |
| <br> |
| <img |
| src="images/mpdborig.jpg" alt="PDBOrig" width="271" height="410" |
| border="1"> |
| |
| <img src="images/mpdbmod.jpg" alt="PDB mod" |
| width="271" height="410" border="1"> <br> |
| |
| <i> |
| Converted Document |
| |
| |
| |
| Converted |
| Document with Edits</i><br> |
| <br> |
| |
| <h2><font color="#cc0000">Merging </font></h2> |
| 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.<br> |
| <br> |
| |
| <div align="center"> |
| <pre>% java.org.openoffice.xmerge.test.Driver -from application/x-minicalc -to staroffice/sxc -merge Test.sxc Test.pdb</pre> |
| </div> |
| <br> |
| <br> |
| <br> |
| <img src="images/spreadsheetmod.jpg" alt="StarCalc SpreadSheet Mod" |
| width="923" height="566" border="1"> <br> |
| |
| <div align="left"> |
| <blockquote> |
| |
| |
| <i> Original StarCalc Document with Merged Edits</i><br> |
| </blockquote> |
| </div> |
| |
| <h2><font color="#cc0000">Building the plugin</font></h2> |
| The MiniCalc plugin is not currently built as part of the XMerge framework. |
| <br> |
| <br> |
| <br> |
| <br> |
| <br> |
| <br> |
| <br> |
| </body> |
| </html> |
