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. On 11/26/05, Lawrence Tuppen <[EMAIL PROTECTED]> wrote: > 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? > > Lawrence Tuppen > Email: [EMAIL PROTECTED] Web: http://homepage.ntlworld.com/tuppenl > -- My OpenOffice Calc Website http://www.openofficetips.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
