CalcLink

Bringing the Power of Mathematica to OpenOffice Spreadsheets

Andreas Lauschke

Advantages of OpenOffice

- Completely Platform-independent
- Free
- Highly extensible
- Huge world-wide developer community
- Open Document Standard
- API can be programmed towards wity any
  programming/scripting language: Java, C++, Ruby, php,
  perl, ...

Advantages of CalcLink

- Use the power and sophistication of Mathematica in Calc
- Use the familiarity, convenience, and ease-of-use of Calc
  from Mathematica
- Truly bidirectional connectivity
- Graphics power of the Mathematica system from Calc
- Calc spreadsheet features usable from Mathematica
- Mathematica code can be used as if it were a macro
- Calc can be used to display Mathematica results in
  spreadsheets

Advantages of CalcLink (continued)

- Entire breadth of ALL Mathematica functions becomes
  easily accessible from Calc. No limitations. (3,500+)
- Any Mathematica package, including user-written, can
  be loaded and used from Calc.
- Graphical front-end with full Mathematica graphics and
  color-coding and bracket-matching for quick "scratchpad
  evaluations" from Calc.
- Spreadsheets can be imported and exported

Advantages of CalcLink (continued)

- Data can be sent from Mathematica to any spreadsheet
  location
- Mathematica graphics can be generated from Calc
- The Mathematica front-end can share the same kernel
  with Calc or the CalcPad.
- All Mathematica functions (including user-defined symbols,
  packages, and front-end functions) can be browsed from
  Calc.

Features of CalcLink

- Robust program execution
- Highly configurable: kernel sharing options (see next slide),
  auto-launch at beginning, specify Java runtime, etc.
- Very descriptive error messages / exceptions.
  (related to sheets, sheet indices, sheet names, connection
  object, cell ranges, dimension incompatibilities, ...)
- All members of the CalcLink class fully exposed for further
  downstream Java programming in Mathematica.
- Several intuitive convenience functions.

Kernel Sharing Options

One or two kernels can be shared:

({{, }, {, }})

Advanced Applications of CalcLink

- Upload spreadsheet data to a database using the
  Mathematica database package
- Create Calc spreadsheets programmatically by retrieving
  data from a database or with the Mathematica web
  services package or with the data collections functions
  and displaying in a formatted spreadsheet.
- With Java Mail API: email results directly from
  spreadsheet!
- Data-Mining: Turn a flood of spreadsheet data into
  meaningful information!
- Selective data-viewing for giant-size spreadsheets
  (Calc in OpenOffice 3.0 supports 1,024 columns and
  65,536 rows per sheet)
- Call Java or .Net from a spreadsheet!
- "Script" Calc functions from Java or .Net or C code!
- Use spreadsheets to display data in proprietary formats
  that can only be read using Mathematica's Import
  functions.

How to get CalcLink

Visit www.lauschkeconsulting.com, CalcLink section, and request eval version.

Contact: calclink@rcn.com

Price: $249 USD per seat
(Illinois individuals and businesses add 10.25% sales tax)

Price includes all upgrades to minor versions, new license required for major versions.

Site licenses and volume discounts available upon request.