Using bl.reynolds.net.au as a DNS RBL?
You might like to stop
Diary of a geek
| Mon | Tue | Wed | Thu | Fri | Sat | Sun |
|---|---|---|---|---|---|---|
| 1 | ||||||
| 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 |
| 16 | 17 | 18 | 19 | 20 | 21 | 22 |
| 23 | 24 | 25 | 26 | 27 | 28 | 29 |
| 30 | 31 |
- clug - 4
- code - 6
- debian - 126
- geek - 26
- humour - 11
- lca - 16
- life - 652
- americania - 54
- mtb - 2
- repatexpat - 10
- meme - 4
- opinion - 35
- politics - 12
- rant - 3
- tech - 250
- gadgets - 4
- security - 18
- spam - 1
- ubuntu - 8
- uni - 31
- work - 53
- JavaScript required
Wednesday, 18 May 2005
My brief run in with Open Source spreadsheets
Well I just tried to do (what I consider to be) a fairly basic thing I used to do a lot of in Excel, in both OpenOffice.org's Calc and Gnumeric.
That would be categorising my mobile phone bill.
In Excel, I'd turn on the auto filter, and then do an @SUM on the cost column. If I filtered by something in one of the other columns, the total at the bottom reflected the total for the current filter.
I can't seem to do this (at least not by doing the same sort of actions) in either Gnumeric or OpenOffice.
A further annoyance is that if I do use a filter, I cannot access beyond the bottom of the selected rows. So I can't add an @SUM at the bottom of the cost column after I've filtered. I can't even scroll any lower.
How annoying. (Oh and I do like how OpenOffice wants to ask me if I'd like to autosave. How polite. And useless)