On Mon, Jan 16, 2012 at 12:52:53PM +0000, Peter Alcibiades wrote:
You're quite right, they are really quite messy because of exactly what you have noticed, being cell based. This is also what makes them so prone to error, but also so easy to use for people who don't realise they are actually writing programmes.
The real answer if determined to use a spreadsheet is probably to use macros in OO, or VB in Excel. But the last time I tried to do anything serious in a spreadsheet, I did what the other writer said, just pasted the formula into the whole column.
The other problem with them is they are so slow. The last time I did this, I found it necessary to do all kinds of lookups and use a matrix. Well, it started to take minutes to load the thing. Not to get the report, to load the thing in the first place, because of all the automatic calculation that was happening as it loaded.
Yes, you can turn that off. But its a total kludge.
Same thing done in high level scripting language, you just put the data into variables in memory, then do 'for each x...' and it takes a couple of seconds.
That's the conclusion I have come to, I'm aiming to write something in Python (simply because it's what I find most comfortable) with a database providing the long term storage. At the same time as doing the sums I'm going to get the Python to help me get the other thing I've been hankering after - a simple way to edit database tables in a multi-row mode.
Sorry, I was just hoping a spreadsheet would be a cleaner/tidier solution to my requirement than it actually is.
main@lists.alug.org.uk http://www.alug.org.uk/ http://lists.alug.org.uk/mailman/listinfo/main Unsubscribe? See message headers or the web site above!