Posts Tagged ‘LibreOffice’

Connect to MySQL database from LibreOffice Base

August 3, 2011 8 comments
LibreOffice’s Base program can provide a quick easy way to access a MySQL database and write some reports against data.  The following outlines how to easily setup LibreOffice Base to connect to MySQL.  It assumes that you already have LibreOffice Base installed.  It works just as easily for OpenOffice Base.First we need to install the JDBC driver for MySQL

sudo apt-get install libmysql-java

  1. Open up any LibreOffice program and then click on Tools->Options.
  2. Expand LibreOffice option and then click on Java.
  3. Click on the Class Path button on the right followed by Add Archive.
  4. Browse to /usr/share/java/mysql-connector-java.jar
  5. Click Ok and choose to restart LibreOffice.
  6. Now open LibreOffice Base and choose to Connect to an existing database.
  7. In the drop-down menu choose MySQL, and connect using JDBC.
  8. Click on the Test class button to make sure the JDBC driver loads successfully.  If it doesn’t, then check that you followed the previous steps properly.  If it does load then simply enter the settings as it relates to your MySQL database.
  9. If you get the JDBC driver to load properly, but you cannot connect to your MySQL database,
  10. then I would recommend installing the mysql client and making sure you can connect from the MySQL client first.
  11. If the JDBC driver loads properly, and you can connect to your database with the MySQL database, then you should not have any problem connecting with LibreOffice.

Note : This Tutorial Article is tested on Debian family OSs.

Ref :

LibreOffice vs. OpenOffice! What’s the difference?

August 2, 2011 Leave a comment

Since the end of September 2010, a group of German OpenOfficevolunteers left definitively the project to join the The Document Foundationand develop a fork version of the famous free productivity platform now controlled by Oracle. Afterjust few months we haveLibreOffice: a (more or less) new cross-platform productivity software based on OpenOffice version 3.3 beta. We compared both the free suites and apparently we did not notice particular differences in features and tools. Also the graphic interface is similar between the two platforms and the buttons position is the same. At the moment LibreOffice supports less languages in its Linux and MAC OS X versions and it is not compatible with Solaris based PCs. Both the productivity platforms are able to use the OpenOffice extension library.  Consequently, it is clear that it’s too early to notice relevant technical differences between the two competitors but, for sure, something will show off in the next versions. In fact LibreOffice has been created to guarantee a vendor independent office suite which can be developed with no copyright software chunks. The goal is prestigious and we can only say, Good Luck LibreOffice!

Source :


Introduction of LibreOffice

July 22, 2011 1 comment

What is LibreOffice?

LibreOffice is a freely available, full-featured office productivity suite. Its native file format is OpenDocument, an open standard format that is being adopted by governments worldwide as a required file format for publishing and accepting documents. LibreOffice can also open and save documents in many other formats, including those used by several versions of Microsoft Office.

LibreOffice includes the following components:

Writer (word processor)

Writer is a feature-rich tool for creating letters, books, reports, newsletters, brochures, and other documents. You can insert graphics and objects from other components into Writer documents. Writer can export files to HTML, XHTML, XML, Adobe’s Portable Document Format (PDF), and several versions of Microsoft Word files. It also connects to your email client.

Calc (spreadsheet)

Calc has all of the advanced analysis, charting, and decision-making features expected from a high-end spreadsheet. It includes over 300 functions for financial, statistical, and mathematical operations, among others. The Scenario Manager provides “what if” analysis. Calc generates 2-D and 3-D charts, which can be integrated into other LibreOffice documents. You can also open and work with Microsoft Excel workbooks and save them in Excel format. Calc can export spreadsheets to Adobe’s PDF and to HTML.

Impress (presentations)

Impress provides all the common multimedia presentation tools, such as special effects, animation, and drawing tools. It is integrated with the advanced graphics capabilities of LibreOffice’s Draw and Math components. Slide shows can be further enhanced with Fontwork’s special effects text, as well as sound and video clips. Impress is compatible with Microsoft’s PowerPoint file format and can also save your work in numerous graphics formats, including Macromedia Flash (SWF).

Draw (vector graphics)

Draw is a vector drawing tool that can produce everything from simple diagrams or flowcharts to 3-D artwork. Its Smart Connectors feature allows you to define your own connection points. You can use Draw to create drawings for use in any of LibreOffice’s other components, and you can create your own clip art and add it to the Gallery. Draw can import graphics from many common formats and save them in over 20 formats, including PNG, HTML, PDF, and Flash.

Base (database)

Base provides tools for day-to-day database work within a simple interface. It can create and edit forms, reports, queries, tables, views, and relations, so that managing a connected database is much the same as in other popular database applications. Base provides many new features, such as the ability to analyze and edit relationships from a diagram view. Base incorporates HSQLDB as its default relational database engine. It can also use dBASE, Microsoft Access, MySQL, or Oracle, or any ODBC-compliant or JDBC-compliant database. Base also provides support for a subset of ANSI-92 SQL.

Math (formula editor)

Math is LibreOffice’s formula or equation editor. You can use it to create complex equations that include symbols or characters not available in standard font sets. While it is most commonly used to create formulas in other documents, such as Writer and Impress files, Math can also work as a standalone tool. You can save formulas in the standard Mathematical Markup Language (MathML) format for inclusion in web pages and other documents not created by LibreOffice.