Calc, paste special, transpose and link

users
#1

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

#2

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)

It seems that, because of this gey, all functions, including the 'transpose' do not work......

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

This works the same as in Office2013, where it is also not possible to 'transpose' and 'link' together.

#3

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

#4

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

#5

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

#6

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