[ANN] XMLmind XML Editor V2.8
Lists Home |
Date Index |
V2.8 (October 21, 2004)
XMLmind XML Editor now has an easy to use and yet
extremely powerful integrated spreadsheet engine.
No, it does not work by embedding an external
spreadsheet component in the document. The XML
document is the spreadsheet. Click anywhere in a
document and use a specialized formula editor to
insert a new formula.
* The formula language and the predefined
functions are very similar to those used by
other spreadsheet software. Example:
"sum is " & SUM(A1:A3).
* More than 80 predefined functions are
provided. If this is not enough, you can write
your own functions in Java[tm] or, more simply,
using the formula language. These user-defined
functions will be dynamically loaded by XXE
and they'll look and feel as if they were
* 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: A1:C3).
* A formula can access any part of the document
that contains it (or any part of an external
XML document) using XPath escapes. Example:
get the last 8 characters of the value of
attribute id of the element containing the
* A formula is represented by processing
instruction xxe-formula. Using such specific
processing instructions is allowed by the XML
standard. xxe-formulas are ignored by XML
software other than XXE.
* A formula computes a value. This value can be
used to add/replace the text node immediately
after the formula or this value can be used to
add/replace an attribute of the element
containing the formula.
* The spreadsheet engine is readily usable with
any document type without having to configure
* XMLmind XML Editor Standard Edition will not
save the xxe-formula processing instructions
contained in a document. Of course, this
restriction does not exist in Professional
For more information, please read XMLmind XML
Editor - Using the Integrated Spreadsheet Engine.