Integrating Google Forms in a WordPress Site [Following up requests]

I've had two requests in the last week for the following: "How can we have a form that people can use to request a copy of a download, and then we can follow up later? I just want to use a spreadsheet." There are a number of autoresponder-type systems that allow you to create a form, where a mailer is sent day 0 (when they sign up) and then follow up emails are sent on the days that you specify … [Read more...]

Transitioning Google Apps [Manage Conflicting Accounts]

I know quite a few people that are going through a little bit of pain at the moment with conflicting accounts on the Google Apps for domains transmission. I also know this is not normally an Office software problem, however I have enough users that use Google Docs and other Google services (like Google Groups and Youtube), that this has become an issue that warrants a solution. If you have no … [Read more...]

SOLVED – Java Issues on OpenOffice.org for Apple Mac Users

Earlier this week I posted 3 Options for Java Issues on OpenOffice.org for Apple Mac Users [Show Stopper]. I'm happy to report over at the reported bug page this is now solved, and for those that are experiencing difficulties you can apply a patch. If you find all the tech-speak a little intimidating, then please proceed to the page of Raphael Bircher who has a handy set of instructions on … [Read more...]

3 Options for Java Issues on OpenOffice.org for Apple Mac Users [Show Stopper – SOLVED]

Amazon affiliate: Mac Os X-Only Free Software: Textedit, Neooffice, Quicksilver, Camino, Adium, Bean, Colloquy, Shiira, Smultron, Seashore, Texshop, Cog, Growl Update: This issue has now been solved. :) I have been on leave for a month, and came back to a software update for Java 1.6 on my Mac. As usual, I installed it. Unfortunately, the next time I opened OOo to put together a tutorial, I … [Read more...]

OpenOffice.org 3.2 – Guide to Programming in OOo Basic [How-to Guide]

The guide linked below provides an introduction to programming with OpenOffice.org Basic. It includes examples to help you quickly develop your own OpenOffice.org Basic programs. It is recommended in the preface that you have a familiarity with other programming languages, however it does start with some very basic examples, so anyone familiar with writing macros in MS Office or other suites … [Read more...]

Why this is probably the best spreadsheet Gantt Chart Template you’ll find this year [Project Management with OpenOffice & Excel]

Amazon affiliate link: Introduction to Project Management Hubby hit me with a request for a Gantt chart in Excel this week, which is OK. I can colour the background of cells with the best of them! But then I decided to turn this into a project where you get Excel and OpenOffice templates to use, free! As I was putting it together, however, I was starting to wonder if there was a way … [Read more...]

FAQ: How do you use the If-Else Statement in Calc? [OpenOffice Calc Decision Making]

Recently I had a client that wanted to automatically calculate rental increases based on the date that the lease expired. He didn't have a large amount of criteria, so I used an If-Else test to evaluate which percentage increase should be applied to the rental amount. We ended up with a spreadsheet that looked like this: This used two functions: IF(Condition;Perform if TRUE; … [Read more...]