On Sunday 08 July 2007, Peter Moran wrote: > Hi > > Use open office a lot - keep up the excellent work > > Ive just written a spreadsheet that required a large number of formula > copies. There were a mix of absolute and relative location references > in the formulae. > > I created the absolute reference by placing a $ sign in front of the > location reference (eg $B6 ).
This is absolute for all values in B6..n $B$6 is absolute for B6. Richard. > When I copied these were all treated exactly as relative references. > > Have I missed something in the help or is there a bug? > > Thanks > > Peter Moran --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]