As of XMLmind XML Editor v5.8, the integrated spreadsheet engine is implemented as an add-on. Therefore you may need to download and install it by selecting menu item → and choosing the "Integrated spreadsheet engine" add-on in the "Install Add-ons" dialog box.
An easy to use and yet extremely powerful integrated spreadsheet engine is built into XMLmind XML Editor. This engine may be described as follows:
It does not work by embedding an external spreadsheet component in the document. The XML document is the spreadsheet. That is, a formula can address any part of the XML document using XPath. (More information in Section 6, “XPath escapes”.)
When an XML element is rendered on screen as a table, a formula can address table cells using the usual ``A1 notation'' (example:
"table1"!$A$1:$C$3). If the formula is itself inside a table cell, it can even use relative cell references (example:
The formula language and the predefined functions are very similar to those found in other spreadsheet software (Microsoft Office Excel, OpenOffice.org Calc, etc). Example:
"sum is " & SUM(A1:A3). More than 80 predefined functions are provided.
A formula is represented by processing instruction
<?xxe-formula>. Using such specific processing instructions is allowed by the XML standard.
<?xxe-formula>s are ignored by XML software other than XXE.
You'll find a demo you can play with in