[libreoffice-users] Calc, paste special, transpose and link
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. -- 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
Re: [libreoffice-users] Calc, paste special, transpose and link
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
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+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