On Saturday 03 December 2005 05:27 am, CPHennessy wrote:
> On Sat November 26 2005 14:22, + Lawrence Tuppen wrote:
> > [ MODERATED ] ********************
> > I now use OpenOffice (previously I used ClarisWorks which is not
> > supported on Windows any more) to keep track of my bank accounts, credit
> > cards and such. Each line has spending details (date, description etc.)
> > amount and a running total column containing formula such as =E6-D7. When
> > the bank statement arrives I shuffle the lines into a matching sequence.
> > This worked with ClarisWorks but OpenOffice throws a fit. It alters the
> > formula in the running totals column to reflect the moves. Then the total
> > is not correct. Even worse, this can confuse OpenOffice 1.1 into freezing
> > so hard that I can not even cancel it with the little "x" at the top
> > right. I escape using the Windows XP Task Manager to cancel OpenOffice. I
> > tried to prevent these unwanted updates by changing the formula with
> > dollar signs such as =$E$6-$D$7 without success. Now I try to remember to
> > delete the running totals column completely, shuffle the lines, and
> > rebuild the column. Surely this can not be the best way of working. What
> > should I do?
>
> Hi Lawrence
> As you are not subscribed you may not have seen that:
>
> On Mon November 28 2005 17:20, David Chapman wrote:
> > Have you tried naming cells to make meaningful formulae?
> > eg =health_club_due - health_club_payment
> >
> > As far as I understand, names are attached to constant cell references
> > eg $E$6 - so you should
> > be able to move different values into place and have the same formula
> > - just different values.
>
> Please reply to [email protected] only.
Second suggestion: Why not revise the spreadsheet so that it looks like
the bank statement? Then set up your formulas the way you want them.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
