Re: [libreoffice-users] Calc, paste special, transpose and link

On 2014-01-01 10:49, TomW wrote:
> On 2014-01-01 06:22, IGraham wrote:
> > Hello and a happy new year
> >
> > Calc, paste special, transpose and link
> >
> > I've done this before but can't get it to work again - I'm blaming 
> > the brain
> > cells
> >
> > In one spreadsheet I select a range of vertical cells and copy
> >
> > In the second spreadsheet I right click a cell go paste special and 
> > select
> > paste all, transpose, link (all selections then go grey)
> > Click ok and the cells are pasted vertical *not horizontal* as required
> >
> > I've done it before ??  But I'm doing a bit of head scratching now
> >
> > Can anyone help
> >
> >
> >
> > -----
> > IGraham
> >
> > W764  LibreOffice 4.1.0.4
> > --
> > View this message in context: 
> > http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407.html
> > Sent from the Users mailing list archive at Nabble.com.
>
> IGraham:
>
> Both versions listed below allow paste link & transpose at the same 
> time to a new sheet.
>
> Vista Home Premium LibreOffice Portable Version: 4.1.4.2
> Vista Home Premium LibreOffice RC1 Version: 4.2.0.1
>
> Tom

Upon rereading the e-mail, I had used paste special | link & transpose 
to a new sheet within the same workbook.  Trying to perform this 
operation to a new workbook gives me a #502 error (invalid argument??) 
on both versions.

TomW

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted