Archive for the 'OpenOffice' Category

Office Compatibility

OpenOffice or Microsoft Office. Use either. It’s like OS X vs. Linux… whatever tool that is best for the job right?

Here’s how you can make the two play a little nicer…

OpenOffice

Users with older versions of Microsoft Office Products, including Word 2000/2002/2003, Excel 2000/2002/2003, PowerPoint 2000/2002/2003)

Users of Microsoft Office 2007

Posted by Karl Herrick on November 20th, 2009 in Apple, OpenOffice, Microsoft, Linux | No Comments »

Connecting MySQL with OpenOffice Base

OpenOffice Base makes it incredibly easy to hook up to a MySQL database. Once this is accomplished you can easily create a front end to browse through your data, edit it, report on it, etc. Below are a few steps I took to create a functional setup:

What I did was:

  1. Have OpenOffice installed
  2. Access to a database (for this example I used my wp_posts table from Wordpress) from the workstation running OpenOffice
  3. Downloaded MySQL® Connector/J and installed
    1. Within OpenOffice clicked, “Tools > Options > OpenOffice.org > Java > Class Path… > Add Archive…”
    2. Selected “mysql-connector-java-5.1.5-bin.jar” or current version
    3. Restarted OpenOffice (had to make sure the process was fully “killed”)
  4. Created a new database within OpenOffice
    1. Within OpenOffice, clicked “File > New > Database”
    2. clicked the “Connect to an existing database” radio button
    3. selected “MySQL” from the drop down list
    4. clicked the “Next >>” button
    5. selected the “Connect using JDBC (Java Database Connectivity)” radio button
    6. clicked the “Next >>” button
    7. entered the “Name of the database” into the text field
    8. entered the MySQL “Server URL” into the text field
    9. clicked the “Test Class” button and received “The JDBC driver was loaded successfully”
    10. clicked the “Next >>” button
    11. entered as “User name” into the text field
    12. checked the “Password required” checkbox
    13. clicked the “Finish” button and save
  5. Made a form based on wp_posts:
    1. This screenshot is of the form I made to browse the raw data of my Wordpress posts from my Thoughts and Notions weblog and is showing data from this post in particular:
    2. OpenOffice Base wp_posts

Posted by Karl Herrick on February 17th, 2008 in Wordpress, OpenOffice | 1 Comment »

Free Office Suite

Here it is, OpenOffice has just released version 2.0.

Some of the exciting features it has:

Most importantly it is free and standards compliant.

Download it:
http://download.openoffice.org/2.0.0/index.html

Read about it:
http://www.openoffice.org/dev_docs/features/2.0/index.html

See it:
http://www.openoffice.org/screenshots/ooo20/index.html

For more information:
http://marketing.openoffice.org/2.0/featureguide.html
http://www.openoffice.org/

Posted by Karl Herrick on October 20th, 2005 in OpenOffice, Microsoft | No Comments »

Still using Microsoft Word?

Yeah, I know, I like grammar check too. I also, enjoy… wait a second, I think that is all I miss when I use programs other than Word, say OpenOffice. It is well beyond my understanding why people perpetuate vendor lock-in by continuing to use a program that has been made a commodity.

Think generic drugs. Does anyone buy Tylenol when they know they can get the same thing cheaper. It’s called Acetaminophen. Well, I don’t anyway… I guess you could buy specially packaged, elderly friendly, long lasting, Tylenol gel tab, eh… back to word processors… :-)

Anyhow, why pay the extra? In this case it is 100% more expensive to buy Microsoft Word, than to download OpenOffice. And, there are others who are tired of Word… and not just because it is expensive. John Dvorak of PC Magazine fame seems to think it is time to ditch the software.

And while you are at it, check out OpenOffice Impress. Think of all of those times you have used “Power Point” as an noun… “I am going to make a Power Point”… how about we change that to, “I am going to make an Impress Presentation”…

Yeah, it doesn’t sound as catchy, but I can still hope someday it will change. :-)

Posted by Karl Herrick on September 13th, 2004 in OpenOffice, Microsoft | No Comments »