On Wed, 2006-02-22 at 10:40 -0700, Robert Beene wrote: > Thank you for the prompt response to my question. However, the question > remains. I have tried the paste special function, but it just pastes in > the link again. Is there a way to make it paste in the current value > instead of the link? Thanks.
Which boxes did you check/uncheck. In particular you should make sure the "Link" box is unchecked at the bottom of the dialogue. Easily missed, and usually off by default, but I think OOo remembers your last selection. > Robert Beene > > CPHennessy wrote: > > >On Tue February 21 2006 17:51, + Robert Beene wrote: > > > > > >> [ MODERATED ] *********************** > >>I have a question on use of the spreadsheet program. > >> > >>I have a cell in one spreadsheet (file A) which is linked to a cell in > >>another spreadsheet (file B). At some point in time I want to break the > >>link and freeze the value in the cell in file A at its current value. > >>The only way I have been able to figure out to do this is by typing in > >>the value I want. Is there another way? > >> > >>In Excel I could do this by selecting the cell in file A, copy it, > >>select paste special, and select value. > >> > >> > > > >OOo also has "Edit" -> "Paste Special". > > > >Please reply to users@openoffice.org only > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]