Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 18:10 , Jean-Francois Nifenecker wrote: Le 21/03/2011 17:59, James Wilde a écrit : What I'd now like todo is to change the contents of the first name column from left(1;x-1) to John or Jane, and the last name column likewise, from being a formula which displays as a name to being a name. Select, then Copy Special at the same place with Formula option unchecked. Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. //J -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On 2011-03-21 4:14 PM, James Wilde wrote: Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. sure it does, I use it all the time... -- Best regards, Charles -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) -- Jean-Francois Nifenecker, Bordeaux -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
Re: [libreoffice-users] Convert formulae to actual
On Mar 21, 2011, at 21:46 , Jean-Francois Nifenecker wrote: Le 21/03/2011 21:14, James Wilde a écrit : Sorry, Jean-Francois. There is no Copy Special. Only Paste Special. And Paste Special does not have a Formula option. Ooops! Yes, it should read Paste special, sorry for the typo. And I confirm there *is* a Formula option :) Ah, thanks. I didn't realise that, by select, you meant I had to copy the cells in question. When I copied them first, it worked exactly as you said. Thanks for the help. //James -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***