OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   [ANN] XMLmind XML Editor V2.8

[ Lists Home | Date Index | Thread 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
    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

  * 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.


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS