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