Hyperlink cells in OpenOffice using Find/Replace

I’m using spreadsheets from time to time to keep minutes of phone calls. Definitely not the best way to do it, but.. well..

In these spreadsheets I have a column with numbers and I want them to link to a website so it opens up the case the notes are related too. I ended up using ‘Find & Replace’ like this in OpenOffice 3.0 (should work since 2.4):

  • Find: ([0-9]{4,5})
  • Replace: =HYPERLINK("https://yourwebsite.loc/$1"; "$1")

Make sure you switch on the ‘Regular expressions’ in ‘More Options’.

Silly, but it kept me busy for 14 minutes..

Turning 31 today

Listening to The National‘s ‘City Middle’ I wondered who Tennessee Williams is. Reading up, I learned how he died.. Choked on the cap of his eye drop bottle..

Anyway, another year browsing earth behind me, I celebrated and still celebrating it in my current hometown Aschaffenburg. Past night in the pub it was really great with Julia and Ingo surprising me with a birthday cake and candles to blow out! And some great gifts like a freshly made Freiwild MacBook Air sleeve.
Tonight I’m spending a few drinks and cake in Hannebambel.
Happy birthday to all born on 14th June!

Compiling Stackless on Mac OS Intel

I’m a bit fooling around with Stackless and spend some time trying to compile it. Hopefully this post might help other folks trying to build it on Intel Mac OS 10.5.

If you are just like me and only read the instructions after the first attempt, you’ll probably run in the following error:
./Stackless/platf/switch_x86_unix.h:37: error: PIC register 'ebx' clobbered in 'asm'
There is a hack which just involves removing the ‘ebx’ from line 37, but that’s what it is: just a hack. Looking further in the mailing lists, I found some further hints. Actually, it was all there in the ./configure –help output.
Using the latest SVN checkout I used the following ./configure option line. Note that I’m installing in /opt/stackless, because you don’t want to screw up your other billion Python installations!
shell> ./configure --prefix=/opt/stackless --enable-framework --enable-stacklessfewerregisters
I tried the –enable-universalsdk option, but it failed for the PPC architecture.
Once Stackless’ Python is installed, and you’ll launch the python CLI, you’ll notice the lack of readline support. Readline is GPL so doesn’t fit Mac OS to much. I learned from another old blog post¬†how to make it work but links don’t work there anymore. So I installed it through Darwin ports first:
shell> sudo port install py25-readline
That only works when you actually have Python 2.5 installed from the ports before. Well, it will compile everything new for you in /opt/local. Let me know how you did it without ports!
Next, you’ll need to make a symbolic link:
shell> cd /opt/stackless/lib/python2.5/site-packages
shell> ln -s /opt/local/lib/python2.5/site-packages/readline.so .

Well, that’s it!

June Web Montag in Frankfurt am Main, Germany

It was a beautiful day to start with, but rain and thunderstorms did mess with the barbeque planning Germans are famous for. So, lots of people attended Web Montag yesterday!

Darren Cooper opened Web Montag this time. He repeated a few times “1st of September”, which is the next meeting in Frankfurt. For next events he really want to see more non-technical presentations. I think that’s indeed a good thing. Darren also got some good jokes, seriously!

Andreas Demmer was first speaker, talking about Presentation Zen. It made us, the other speakers look bad afterwards.. just kidding! I knew bits and pieces about this approach for doing presentations, but it’s what it is: an approach, not a method. I still can learn lots.

My talk was about MySQL Proxy, but to be honest it went not well. First of all, my cold was still there, speaking through the nose. Additionally, I have a terrible buzzing in my left ear making my voice irritating me and I was looking to much for the German words. I’m not really preparing enough for these short talks. Anyway, there will be video about it!

The important links are:

Michael Vog talked about the Google Web Toolkit or GWT. This was probably nice of the Web Designers in the audience. Particular interesting for me was the talk about Selenium IDE by Thorsten Biedenkapp. I’ll probably never use it, but I made something similar in my previous job testing regressions and errors in websites. The last speaker, Sebastian Fastner, introduced the audience to OSGi. So, quite some Java stuff that evening!

Next Web Montag in Frankfurt am Main is on 1st September 2008, and if all goes well the following is on 1st December. Hopefully more talkers will be present, and not doing to much technical stuff. Maybe some ‘tracks’ can be introduced, but that might it make to complex again.
Was a nice evening, hope everyone enjoyed and learned something. Or at least got interested in checking out more stuff!