Spreadsheet Population
The following macro was developed by Lanedo in order to use LibreOffice charting capabilities with data stored in a SQL database.
Project Description
The following macro was developed by Lanedo in order to use LibreOffice charting capabilities with data stored in a SQL database.
After downloading the populate-spreadsheet-from-db.ods LibreOffice file:
Open the document and enter the information to connect to your SQL DB
Press the "load data" button
If the data was successfuly imported, press "create chart"
NOTE: The macros connect to a database and will do nothing if that database is not available. So you can not expect it to just work from downloading the file alone.
Current Release
Spreadsheet Population 1.0
Released Sep 26, 2011 — tested with LibreOffice 3.3, LibreOffice 3.4
Populate Calc from an existing MySQL DB
More about this release…
-
Get
Spreadsheet Population
for
All platforms
- If you don't know, how to install an extension in LibreOffice, see our howto about installing extension for detailed instructions.
All Releases
| Version | Released | Description | Compatibility | Licenses | Status |
|---|---|---|---|---|---|
| 1.0 | Sep 26, 2011 | Populate Calc from an existing MySQL DB More about this release… |
LibreOffice 3.3
LibreOffice 3.4
|
LGPL-v3+ |
final |
Legal Disclaimer and Limitations for Downloads
Responsibility of Website User
The Document Foundation has not reviewed, and cannot review, all of the material, including computer software, available on or by means of The Document Foundation's websites, and cannot therefore be responsible for that material's content, use or effects. By operating its websites, The Document Foundation does not represent or imply that it endorses the material there available, or that it believes such material to be accurate, useful or nonharmful. You are responsible for taking precautions as necessary to protect yourself and your computer systems from viruses, worms, Trojan horses and other harmful or destructive content.
- The Document Foundation's websites may contain content that is offensive, indecent or otherwise objectionable, as well as content containing technical inaccuracies, typographical mistakes and other errors.
- The Document Foundation's websites may also contain material that violates the privacy or publicity rights, or infringes the proprietary rights, of third parties, or the downloading, copying or use of which is subject to additional terms and conditions, stated or unstated. The Document Foundation disclaims any responsibility for any harm resulting from the use by The Document Foundation's visitors of The Document Foundation's websites, or from any downloading by those visitors of content available on or by means of The Document Foundation's websites.
Changes
Content contained on The Document Foundation's websites, including these Legal Disclaimers and Limitations, may be changed at the sole discretion of The Document Foundation and without notice. You are bound by any such updates or changes, and so should periodically review these Legal Disclaimers and Limitations.
If you believe any file is present on the site contrary to any TDF rule or applicable law, please supply full details to info@documentfoundation.org for impartial consideration.
