copy/paste data from excel/libreoffice add new column

[ExiE]

I tested Excel 2007 and LibreOffice 6 with Publisher 1.7.0.227 beta with the same results

I selected part of excel table (2 columns, 10 rows) and copy/paste it to table of the same size in Publisher.

All cells were inserted ok but Publisher added one more empty column to the end of my table. Looks like a bug to me.

[Jon P]

Hi ExiE,

Thanks for reporting this, I've reproduced it and logged it for the developers

[Andyz]

My problem is a little different.  If I try and copy and paste multiple rows, it drops the content into one cell.  If I select all of the cells first before trying to paste, it will not give me an option to paste!!  What am I doing wrong?

[Jon P]

Andyz if you have the caret inside a cell it will try paste all the content into that one cell, but if you select the table or the cells you want the data to go in you should get the behaviour you expect (ignoring the extra row/column due to this bug)

[Andyz]

Hi Jon, When I select the cells I want to drop the data in it will not come up with a paste option

 

 

[Jon P]

I was using CTRL+V.

It should probably have paste on the right click menu so i'll have a check with the developers and log that.

Thanks

[Andyz]

Thanks Jon,

CTRL+V works but sticks the extra column on as you are already aware of. 

[hamdogger]

I am experiencing Andyz's first problem using copied cells from Google Sheets. No matter what I select in the table (or not select), all the columns paste into the first cell. Is this not possible with google sheets?

I don't have Microsoft Excel to test it.

Thanks