O
Olivier Ishacian
=======================
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.
Highlights:
* 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
stock functions.
* 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
formula: right(`@id`,8).
* 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
anything.
* 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
Edition.
For more information, please read XMLmind XML
Editor - Using the Integrated Spreadsheet Engine.
http://www.xmlmind.com/xmleditor/_distrib/docs/spreadsheet/index.html
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.
Highlights:
* 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
stock functions.
* 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
formula: right(`@id`,8).
* 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
anything.
* 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
Edition.
For more information, please read XMLmind XML
Editor - Using the Integrated Spreadsheet Engine.
http://www.xmlmind.com/xmleditor/_distrib/docs/spreadsheet/index.html