Jaguar Calc add-in-1.0.0

Extension:
Extension ID:
org.sistema.oo.JaguarAddIn
Release date:
28/11/2007 - 15:07
Version:
1.0.0
Operating system:
System Independent
Compatibility:
2.x, 3.0, 3.1, 3.2, 3.3, 3.4
Binary type:
OOo extension (.oxt)
Release Notes: 

Adds the SQLREQUEST function to CALC. This function is similar to the SQL.REQUEST function of MS-Excel.
SQLREQUEST is an array function. This means that it results in an array containing the data returned by the data source. The online help of Calc includes the "Array Functions" section explaining how to use them.


The following is an example of a typical call using the MySQL J/Connector driver:

=SQLREQUEST("com.mysql.jdbc.Driver";"jdbc:mysql://server_ip_address/?user=name&password=abc";"SELECT * FROM table")
Release notes.

  1. This is the first release :)
  2. Data type conversion.
    • SQL Date values are converted to a Calc compatible number.
    • SQL Decimal values are converted to doubles, so be aware of the possible loss of precision.
      All your suggestions to improve this point are appreciated!
  3. This version has been tested using:
    • OpenOffice 2.3.0 (US English)
    • Windows XP SP2
    • JDBC MySQL JDBC driver (com.mysql.jdbc.Driver class)
  4. There is a bug in this version. If the connection to the data source is lost (once it has been established), the code will not attempt to reconnect. As a result, OpenOffice must be restarted to reconnect.