On Saturday 22 October 2005 02:35 am, Andrew Douglas Pitonyak wrote: > David Hawes wrote: > >Hi guys, > > > >I have been using Open Office for some time now. > > > >I have come across a problem in that when i copy a > >formula from one cell to another, the formula stays > >the same rather than adjusting to the new cell. > >Consequently the output of the formula is wrong. > > > >EG f5-e5 as a formula in g5 > > > >when copied to g6, it stays as f5-e5. > > > >Is this a bug or just how open office works? > > > > > >In the same spreadsheet i total a column. > >As values are added in that column, i expected the > >total to change, but it doesnt. > > > >When i edit the formula in the cell deleting the last > >reference then entering it again, the total updates. > > > > > > > > > >I am using 1.1.4 > > > >Regards > > > >David > > Is auto-calculate off? I think that it is somplace like Tools | Cells > | Auto-calculate
Tools > Cell Contents > AutoCalculate Also, you can use to F9 key to update your spreadsheet. Dan --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
