Jump to content
riball

Copying data into tables

Recommended Posts

When copying data into tables from other applications such as PP, word or excel, all the data is placed into one cell rather than being distributed between cells as in the original.

All other applications I use are able to place the data appropriately.  Is this a 'feature' or am I doing something wrong?

Hopefully it will be remedied.

R

Share this post


Link to post
Share on other sites

Select more than one cell, then paste.


MacBook Pro (13-inch, Mid 2012) Mac OS 10.12.6 || Mac Pro (Late 2013) Mac OS 10.14.5

Affinity Designer 1.7.2 | Affinity Photo 1.7.2 | Affinity Publisher 1.7.2 | Affinity Designer Beta 1.7.2.2 | Affinity Photo Beta 1.7.2.151 | Affinity Publisher Beta 1.7.2.458

Share this post


Link to post
Share on other sites

I can conform that copying data (comma separated or tab separated) does not work on the macOS version. I tried all hints that I could find in the forum (select several cells etc.) - no luck. I would expect this to be fixed for the release version, it is such a basic feature. How it works in QuarkXPress: copy anything from the clipboard that looks like structured data (lines of comma/tab separated text fields) anywhere on the page and Quark will create a generic table with no styling, just thin table/cell borders and text in a default font - and that's perfectly fine.

Share this post


Link to post
Share on other sites
On 13 October 2018 at 11:31 AM, peja said:

I can conform that copying data (comma separated or tab separated) does not work on the macOS version. I tried all hints that I could find in the forum (select several cells etc.) - no luck. I would expect this to be fixed for the release version, it is such a basic feature. How it works in QuarkXPress: copy anything from the clipboard that looks like structured data (lines of comma/tab separated text fields) anywhere on the page and Quark will create a generic table with no styling, just thin table/cell borders and text in a default font - and that's perfectly fine.

For now you can open your comma or tab separated file in Excel, copy the cells and paste into a Publisher Table.

Just remember to select at least 2 cells in Publisher before doing the paste


Due to the fact that Boris Johnson is now our Prime Minister, punctuation, spelling and grammar will never be worried about ever again.  We now have far bigger problems to be concerned about.

Share this post


Link to post
Share on other sites

Have tried copy and paste from PP table and highlighted more than one cell in AP but data still copied to one cell.

I have also tried it from excel and that works fine.

PP produces a tab delimited output when data is copied from a table, please can AP be set up to recognise tab as well as comma delimited data?

R

Share this post


Link to post
Share on other sites
On 10/15/2018 at 12:45 PM, riball said:

Have tried copy and paste from PP table and highlighted more than one cell in AP but data still copied to one cell.

I have also tried it from excel and that works fine.

PP produces a tab delimited output when data is copied from a table, please can AP be set up to recognise tab as well as comma delimited data?

R

This.

I've been struggling with copy and pasting from a Google Spreadsheet. Now that I have 50+ cells to pull from, the individual copy & paste wasn't going to cut it, so I dug around on the forums. I found that downloading the Google Spreadsheet as an XLSX file, then opening it in Libre Office (because that's what I have) and then copy & pasting from there seems to stop the aggravating "all in one cell" issue I was having with Google Spreadsheet. Though this was never a problem in ID, so I'm guessing it's an issue on the AP side?

Share this post


Link to post
Share on other sites

Also was having this problem. Tried pasting from Google Sheets, XL and Libre Office. Tried with two cells selected. Tried with exact number selected. Tried with more selected. Cleared existing data. All still ends up in one column.

Eventually got it to work by pasting a single column at a time.

Share this post


Link to post
Share on other sites

In my opinion, the lack of functionality within tables is the biggest drawback to moving over to use AP rather than PP.

It is all very well introducing fancy graphic tools, but this is a really a word processor and should have all the tools for handling text and tables as well as useful add-ons for mail merge etc.

 

Share this post


Link to post
Share on other sites
16 hours ago, riball said:

It is all very well introducing fancy graphic tools, but this is a really a word processor

This is really a desktop publishing (layout) app, not a word processor. There are missing features indeed, particularly as we still are still on the very first release, but it would be helpful to manage our expectations with an understanding of what Publisher is, and word processor isn't it.

(This is a side note, not intended as a comment on the validity of the feature request in the thread.)

Share this post


Link to post
Share on other sites

My apologies. Word processor was not the correct terminology.

What I would expect is to be able to edit text and tables within the application.  At present the lack of table functionality means that they often need to be created in another application and then imported as a picture.

With the integration of the other Affinity apps so that they can now be called from each other, it seems out of line with the implied aim of making this a complete package, to have to go to other apps for the more basic text/table functions.  I would hope (in time) that I can go to AP and prepare all my content: text, images, tables, photos, in one package.  I would hope, also in time, that this could include mail merge so that I can include variable fields tailored for each recipient. 

I wait to see.

Share this post


Link to post
Share on other sites

Absolutely.

 

From Apple Numbers only Function’s result into table cell.

I create Calendar on Numbers. Because this application uses  database functions for typing day integers.

I mean a one cell input “1”, and next cell input “= Former cell + 1” or “= Above cell + 7”. And copy to horizontal or vertical cells. These work input automatically days in cell.

Just now copy and paste work is as image.

Thanks Affinity team 

203F49C8-D282-4C3A-836C-4637FFE75E14.png

AA73A530-7327-4126-9E60-20D81E0B00A6.png

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

×