Data loader for spreadsheet-0.0.1

Extension:
Extension ID:
org.openoffice.DBForm
Release date:
09/01/2011 - 14:30
Version:
0.0.1
Operating system:
System Independent
Compatibility:
3.4
Binary type:
OOo extension (.oxt)
Release Notes: 


Data loader for spreadsheet is to load a database table into spreadsheet.

Guidlines

Goto database-->import
fill required fields and select the required fields
If you don't want to load the whole table select required fields from the table.
Then you can load these data into spreadsheet.

This will return the string array.
If your table consist of any numerical values do the following

1. Use find and replace.
2. Click More options and check regular expressions.
3. Set the search string to '.*' (without the quotes) and replace string to '&' (again, without the quotes).

This will convert string into numerical values

requirements
You should have mysql running on your machine

future releases
Currently this is enabled for mysql JDBC driver only
In future this will be enabled for other drivers too