Archive for the ‘General’ Category

Easter Egg: starcalcteam()

Monday, September 10th, 2007

There is a new Spanish language OO related blog from Rafael Sanchez

He points out an interesting Easter Egg in the OpenOffice Calc program.

In any cell, type =starcalcteam()

The image below is displayed…


Moving House!

Tuesday, July 10th, 2007

Please bear with me while I relocate my Open Office tips to WordPress.

For an full index of articles in the old blog, see http://www.richhillsoftware.com

Right now, I’m cutting pasting articles from old blog to new. Then I will do cleanup. At the same time I’ll start writing new tips for Open Office Calc.

Toolbar Crazy

Saturday, January 28th, 2006

I’m not a big user of the OpenOffice Calc toolbars - but I was curious what it would look like if I activated them all…

You can enable/disable a particular toolbar with the View - Toolbars menu option. As you can see, it can get quite crowded if you anable them all! In my next installment, I’ll introduce you to some of them.

toolbars.jpg

A Sudoku Solver!

Friday, January 6th, 2006

I have been wanting to do this for the longest time - ever since I became aware of this puzzle last year. So for the past week, I’ve been busy putting together this spreadsheet that will assist you with solving a Sudoku puzzle.

Anyway, three days and 900 formulae later, I present… ooo_sodoku.

sodoku_1.jpg

This is not a push-button solver. Perhaps the next version will allow that. Basically, for each square in the solution grid, the solver will determine all the possible values - saving you a lot of the drudge work associated with these puzzles.

sodoku_2.jpg

As you manually enter the values in the solution grid - top left, the main grid in the center will display one of three colors for each square. Light blue indicates that square already filled in solution grid. Green indicates only one possible value - which has yet to be entered in the solution grid, and brown indicates more than one solution

Your comments, encouragement and feedback are always welcome. As I said earlier, there are 900+ formulae here - so bugs are possible.

Download this utility here

Google Analytics

Monday, November 21st, 2005

From the company that seems to do everything right…

Google Analytics allows you to take a closer look at the folks that visit your website.

One of the coolest features is the ability to create a distribution map - below is the visitors to openofficetips.com in the past two days…

So - to all the folks in Catalunya, Vladivostok, Hanoi, Trondheim, Madeira, Bermuda, Costa Rica, Honolulu, Cape Town, Moscow, Fairbanks, Jakarta, Singapore, etc, etc thanks for stopping by!

map.jpg