Unlimited conditional formats in openoffice spreadsheet

It’s annoying that openoffice, and I believe Excel too, limits you to just three formats which can be applied through conditional formatting.
For example, in my evaluation work, I have a column of phrases which i want to format each with one of five different formats, according to the number (from 1 to 5) in the column to the left.
But it isn’t impossible, … I just found a beautiful solution here.
Actually I simplified that solution even further, like this:
All you have to do is, in the conditional formatting dialogue, switch the dropdown to “formula is” and paste in this: CHOOSE(condition,STYLE(”_1″),STYLE(”_2″),STYLE(”_3″),STYLE(”_4″),STYLE(”_5″)), where _1, _2 are the names of styles defined in your sheet and condition is some condition which evaluates to a number from 1 to 5. Obviously there is no limit to the number of styles.
It doesn’t matter what style you choose in the “Cell style” dropdown.
And that’s it.

@thierryjoubert rain splashing…

@thierryjoubert rain splashing on soggy leaves outside and i felt rotten but then I read thierryjoubert’s tweet and my day is perfect

@NICKSKY wow my Bro is on twit…

@NICKSKY wow my Bro is on twitter. All that and a new baby too!

@mikesolly Is music more bond…

@mikesolly Is music more bonding than bridging? does it make you feel part of just one group?

http://tinyurl.com/l7p5rk Zaš…

http://tinyurl.com/l7p5rk Zašto podržati volontiranje u BiH - UNV sažetak

@mikesolly good man Mike! just…

@mikesolly good man Mike! just in the shower or anything more auspicious?

http://bit.ly/8ivN0 More wond…

http://bit.ly/8ivN0
More wonders in R: psych as a front-end to make structural models

http://bit.ly/zz7kN Sweden te…

http://bit.ly/zz7kN
Sweden tests new aid model - B&H is still in there

Update - zotero sync is just awesome

following up from an earlier post, zotero 2.0 beta (www.zotero.org) is just fantastic now and we don’t use dropbox. We sync the actual files via a box.net webdav account - a bit silly to pay a bit extra for that when we are paying for dropbox, but it works absolutely brilliantly, without any hitches at all, and so do the word and oo.org plugins. The new groups feature is brilliant for sharing with other people in a remote team. And you can get an rss feed for any part of your library.
Nirvana for the previously sync-challenged.

The eternal sync. Google apps for domains syncs with nokia e71 via Exchange

When I had a palm pilot I didn’t have sync problems, everything just worked. But that was 1997.
Ever since then sync has been a pain. Things only started to get better around a year ago.
Another step in the right direction: I just managed to sync my google apps for domains account with my nokia e71 via Exchange - even though that isn’t listed as an option: http://www.google.com/support/a/bin/answer.py?hl=en&answer=138652
There wasn’t anything to do really, just followed the instructions for normal gmail, added m.google.com as exchange server, nothing for the domain, and my domains email as username. Doesn’t sync tasks or mail yet though - pity.

  • What I'm Doing...

    Posting tweet...

    Powered by Twitter Tools.

  • Archives