Any thoughts? WOMFL

[f4f3]

Originally posted by fiendish_catat WOMFL

I am trying to create a simple 'to do' list in Open Office Calc.

What I would really like is a way to click on something when a task is completed which will then put a strikethrough through that task.

I had thought of have an extra column with a checkbox - but can't work out a) how to insert a checkbox and b) how to make it link so the other columns get struck through when it's ticked.

Any thoughts?

(If you have any thoughts for how to do it in Excel but don't know about OOCalc then they might still be useful.)

((Also - if people know they have people on their f-lists who might be helpful and would like to re-post the query that would be amazing.))

Comments

[andrewducker]

I think they're trying to squeeze something in to Calc which it just isn't designed to do. I doubt it will ever do it well, if it can be made to do it at all.

A dedicated to-do list would probably work a lot better.

[fiendish-cat.livejournal.com]

Thanks. I think you're right about it not being designed to do it. Which is a shame as I like Calc/Excel. (And I thought it would be easy - tick in cell b2 leads to crossing out across the whole row.)

I haven't found a dedicated to-do list that works the way I want it to (or indeed one that isn't an online one) but I haven't looked very hard.

[andrewducker]

The only one I've found that I actively like is:
http://www.abstractspoon.com/tdl_resources.html

Which gives me a hierarchy of tasks, keyboard shortcuts, and all sorts of options I never use.

For an online one I use Workflowy, which I adore. But it doesn't have the same granularity.

[f4f3.livejournal.com]

Thank you sir.

[andrewducker]

I am pretty much incapable of _not_ giving my opinion on tech stuff.

Oh - did you manage to get hold of Dan for next week?

[f4f3.livejournal.com]

Well, yes :)

Dropped Dan a line and he'll clamber along it if he's not otherwise, um, tied up.