XMLmind XML Editor - Using the Integrated Spreadsheet Engine

Hussein Shafie

Pixware

Immeuble Capricorne,
23 rue Colbert
78180 Montigny Le Bretonneux,
France,
Phone: +33 (0)1 30 60 07 00,
Fax: +33 (0)1 30 96 05 23,
Web: www.xmlmind.com/xmleditor
Email: 

December 2, 2005

Abstract

This guide contains everything you need to know to use the spreadsheet engine integrated in XXE. This document starts with an easy-to-follow tutorial.


Table of Contents

1. Tutorial
1.1. Basics
1.1.1. Three more formulas to finish first version of the invoice
1.2. How does this really work?
1.3. Relative references
1.4. Absolute references
1.4.1. Better absolute references
1.5. External references
1.6. Formatting
2. The language used to write formulas
2.1. Statements and comment lines
2.2. Expressions
2.3. Function calls
2.4. Literals
2.4.1. Numbers
2.4.2. Strings
2.4.3. Booleans
2.5. References
2.5.1. Reference to a variable
2.5.2. Reference to an element having a specific ID
2.5.3. Reference to table cells
2.6. XPath escapes
2.7. Value types
2.8. Automatic conversion between different value types
3. Defining custom spreadsheet functions
3.1. Registering custom spreadsheet functions with XXE
3.2. Specifying custom spreadsheet functions
3.3. Custom spreadsheet functions written in the Java™ programming language