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
TomW
--
To unsubscribe e-mail to: users+unsubscr...@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