Jump to content
icreate

Pasting data from Excel only fills first cell

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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. :)

 

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

 

Share this post


Link to post
Share on other sites
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).


-- Walt

Windows 10 Home, version 1809, 16GB memory, Intel Core i7-6700K @ 4.00Gz
Affinity Photo 1.6.5.123 and 1.7.0.258 Beta
Affinity Designer 1.6..5.123 and 1.7.0.258 Beta
Affinity Publisher 1.7.0.270 Beta

Share this post


Link to post
Share on other sites
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. :)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×