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

El 2014-01-01 04:42 p.m., IGraham escribió:
> How i managed to do it before I've no idea ? - the brain cells must be even
> more diminished than i thought
>
> however this worked
> =TRANSPOSE(the cells) then press SHIFT CONTROL ENTER
>
> thanks for looking at the problem people and apologies for distracting you
> from your new year celebrations
>
>
>
> -----
> IGraham
>
> W764  LibreOffice 4.1.0.4
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407p4090468.html
> Sent from the Users mailing list archive at Nabble.com.

I didn't know of TRANSPOSE.  I used it *without* Ctrl+Shift+Enter and it 
transposed the complete matrix and automatically included { and }.


--
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