I just want to add that, in Excel you could type things like "=sum(A:A)". I miss that behaviour in OpenOffice.org. It's the only (I think) Excel feature that I actually miss… A:A means "the whole A column". I have tried this in Calc but failed, so I guess Calc lacks that feature.
J.R. 2008/6/7, Jerry Feldman <[EMAIL PROTECTED]>: > > On Sat, 07 Jun 2008 13:57:03 +0100 > "mike scott" <[EMAIL PROTECTED]> wrote: > > > Not so, in fact following that discussion all my columns are now 300 > > entries long, which should see me through. But one day, someone > > /will/ accidentally go over such a preset length, not notice, and pay > > the price with erroneous results. > > > > (And the help file does need clarifying IMO) > > > I personally prefer something relatively clean. While it is good to > know that empty cells are not included, considering that someone else > may have to use the worksheet is a very good consideration. In my case, > the sheet was constructed from a model provided by the Society of > Actuaries and built by a Financial Engineer who is also an actuary and > PHD. This was one of the tasks among a number of other tasks she was > working on, so giving me a clean spreadsheet was not going to happen. > Since this spreadsheet serves as both a product specification as well > as a model to code C++ code, I want to be able to clean it up a bit, > primarily correcting some errors, and being able to hand it over to > another Financial Engineer. > > That said, I am personally interested to learn new things about OO.o > calc both in terms of functionality, but also in terms of style. > > > -- > -- > Jerry Feldman <[EMAIL PROTECTED]> > Boston Linux and Unix > PGP key id: 537C5846 > PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846 > >
