Buzz: Google Docs adds Charting …

For those Google Apps fans out there, Google has just added charting to the functions of the spreadsheet. I’ve added a few images to show what it looks like. Here’s what they say:

Now it’s easy to show data in simple graphics to friends or co-workers with charts. Select from various styles to meet your visualization needs. new charts

Now here’s what it looks like in real life. Just click on the pie to add a chart.

googlechart

Then you will see the following options appear. If you are used to Excel or OpenOffice charts, you will find these straightforward.

googlechart-options

And welcome to my first Chart in Google Apps. Not thrilling perhaps. But it does illustrate my average income from Blogging and other Passive Sources since I started this blog.

googlechart-image

So, quite functional charts, courtesy of Google Apps. If you decide to change the chart, just right click over it, and you will see some options.

And lastly, you can export the charts…, too. So look for that chart in a future posting!

Happy Blogging.

We’re Back… and it was easy this time!

Thanks for your patience as I updated my blog. php-version The problem I was experiencing was that my plugins page wouldn’t load. I checked through the Domains to see which version of PHP I was using. Dreamhost had updated to version 5.2.1 and obviously something in WP at least in the plugins I had installed was quite incompatible with 5.2.1.

Fortunately, Dreamhost has the feature that allows you to choose, (yes choose) which version of PHP you can use. I switched back to version 4.4.2 and within 5 minutes, my pages were all loading properly again.

Anyway, I was already doing a couple of WP upgrades on minor sites with little traffic through their One-Click Installs on Dreamhost, when I noticed that the upgrade process was actually much smoother than before. Before they backed everything upto domain.com.old then erased the old directory.

When the new install was up and running, you used to have to copy all your old themes and everything in the /wp-content. Now, it’s all done for you! Much easier. Much faster. And you’re much less likely t o forget something!

Neat! So I backed up my Database and emailed it to myself, then proceeded with the upgrade. When I was one-click-install done, my theme and everything, plugins, and almost all of the tweaks were still there: widgets, theme tweaks, pictures, uploads, everything. I only had to re-enter some javascripts on the theme I use, and I was done.

That was an upgrade I was dreading, but it was so EASY. Gosh, thanks, Dreamhost!

Disclaimer: I am after all a Dreamhost customer.

Buzz: OpenOffice 2.2 released in the wild

OpenOffice Version 2.2 is now out. It’s official. I’m now downloading the version as we speak, thanks to Digital Nomad’s website! It fixes some vulnerabilities in the software, as well as enhancing the fonts to make for better reading.250px-OOoWrite22

While it doesn’t have the complete range of tools that Microsoft Office has, we’ve been running it in our business since version 1.1, with few problems. Certainly no more problems that if we’d had to update Office regularly.

InvestorBlogger’s view of OpenOffice:

1. Very useable software with a lot of power to do quite sophisticated documents. With some experience of Office, you can be up and running fairly quickly. It will take you a little while to get used to the ‘weird’ factors of Openoffice, but in truth, its weirdness isn’t so different from learning any new software.

2. If you are used to lower power word processors than this, OpenOffice offers a good, and inexpensive, way to try out more sophisticated systems, without the pain. I used to use Works 4.5 as my primary word processor, and it worked well. Subsequent versions really didn’t run well as MS decided to separate Works from Office very clearly. Works became a ‘home’ application (with *ALL* that that entailed including lots of fluff, instability in the primary apps, etc.) while Office became just that. And it’s quite clear where MS placed its long term bets.

3. It has four great applications that will really benefit you, including word processing, spreadsheets and a database. There are one or two additional programs that help out with graphics and mathematical formula, but the applications are well developed and largely stable.

4. It installs cleanly and removes just as cleanly without a reboot, without spraying files and dlls everywhere, and without a fuss.

5. When the program does crash, there is a document recovery feature that saves almost everything from loss, even newly opened files that have been saved properly yet.

6. Openoffice is available across a wide range of platforms, more than most users would ever use, but primarily of interest to us are Windows (95/98 and upwards) and Macs. This flexibility of platforms means a lot, and provides a huge competitive advantage over MS. Office is now only available on XP/Vista and an outdated version on a Mac.

Challenges:

1. Some of the normal features in Word or Office are in slightly different places, for example, if you want to change the page size, it’s now in the Format menu, NOT the File menu.

2. For Word Document users, you will need to set the file formats as a standard, which can be somewhat confusing. The ‘Options’ features are indeed extensive, but it’s not always clear what you need to change if you wish to change the behavior of the program. I had to turn off the auto-correct feature. That took nearly thirty minutes to find the option, as well as a search on the internet.

3. The standard settings are very annoying for myself, including inches not centimeters, tabs, page sizes (letter not A4), and the worst is Auto-correction, when it tries to correct tables, numbering, etc.. These features are annoying, but can be reset. MS Office does most of these to annoy users, too.

4. Openoffice offers help features but they are not as well developed as Office 97, even. More often than not, searching online provides the best help as users do post their own solutions. Finding this information isn’t always easy.

5. The conversion features from Office to Openoffice don’t always produce documents that are rendered well or accurately. Conversion has improved greatly, but users will still experience problems with spacing between lines, complex formats, and graphical differences. Tidying up these documents takes quite a bit of time.

So, we’ve already made the decision to switch over to OpenOffice in the long term. Our PCs all have OpenOffice installed, but two older systems are still running legacy copies of Office 97 and 2000. The users have already been notified that these copies cannot and will not be updated, though this has not been without some resistance.