Pasting data from Excel only fills first cell

[icreate 32]

I was trying to drop in some data from Excel in Publisher (1.7.0.145 on Mac OSX High Sierra) and no matter how many cells I select it only pastes the data into the first cell.

I thought maybe this was maybe how its supposed to work but looking at this post I see that @carl123 is using Windows it works this way but not on Mac for some reason.

Raising it here just in case its a bug.

[Sean P 1,312]

Hi icreate,

I've passed this on to development now! Thanks for letting us know.

[sdkeys 1]

I've been trying to import data from excel into Publisher on a Mac this morning and have the same issues. No matter what I try I have the same result.  I hope Publisher will be a better option for creating catalogues and price lists for my small business. Without the ability to import data from existing excel files this will be a nightmare switch for me.  I really hope this feature can be added or fixed for the Mac version soon. If it is, this software will be the winner.

 

[icreate 32]

3 hours ago, sdkeys said:

I've been trying to import data from excel into Publisher on a Mac this morning and have the same issues. No matter what I try I have the same result.  I hope Publisher will be a better option for creating catalogues and price lists for my small business. Without the ability to import data from existing excel files this will be a nightmare switch for me.  I really hope this feature can be added or fixed for the Mac version soon. If it is, this software will be the winner.

 

Try opening your file in Apple Numbers, copy the data and then select two cells in the first row of the table in Publisher and paste. I tried this the other week and it worked.

[sdkeys 1]

2 hours ago, icreate said:

Try opening your file in Apple Numbers, copy the data and then select two cells in the first row of the table in Publisher and paste. I tried this the other week and it worked.

Thanks so much for your reply icreate

I'll give that a go. I do hope that a workaround isn't necessary when this beta stage is over. I have a lot of price lists ready to go and value my time. I'm hopeful.

 

[walt.farrell 1,789]

55 minutes ago, sdkeys said:

I do hope that a workaround isn't necessary when this beta stage is over.

It will still probably be necessary to highlight two or more cells of your Publisher table before doing the paste. That's what indicates you want to paste the data as a table.

The issue for Mac, I think, is that copying/pasting directly from Excel doesn't seem to work, even with multiple Publisher table cells selected. I think that does work on Windows (though all I can really test is copying from LibreOffice Calc, as I don't have Excel).

[icreate 32]

14 hours ago, sdkeys said:

Thanks so much for your reply icreate

I'll give that a go. I do hope that a workaround isn't necessary when this beta stage is over. I have a lot of price lists ready to go and value my time. I'm hopeful.

 

Hope it helps - let us know how you get on, just in case someone else has the same problem. 

[Titep 3]

Have you a project to make Table to text or text to table option very usefull to transforme data in table

[AdamW 994]

Hi. We have a pending fix for the paste from Excel on Mac. You should see it fairly soon.

Edit: Available now in Build 192. Please note that you have to select a (any) range of cells to paste into more than one cell.