Jump to content
You must now use your email address to sign in [click for more info] Ă—

Tables: Pasting content to table


IOIO

Recommended Posts

First of all, affinity, I love you! Thanks for awesome and affordable software! đź’–

About the bugs:
1. When I copy content from an HTML table and paste it into a table in Publisher, the content in the clipboard is not interpreted as a table and is therefore only inserted into the first cell.
This is a feature I have to use often and it worked well in InDesign and works also in software like Numbers or Excel.

2. When I insert table content from Apple Numbers, the content is inserted not from the first but the second table line. So there is always an empty line at the top and at the bottom another line is added.
Pasting from Excel works correctly.

Thanks!

Link to comment
Share on other sites

1 hour ago, IOIO said:

When I copy content from an HTML table and paste it into a table in Publisher, the content in the clipboard is not interpreted as a table and is therefore only inserted into the first cell.

I think you should post this in the Features Requests & Suggestions section.

2017 27” iMac 4.2 GHz Quad-Core Intel Core i7 • Radeon Pr 580 8GB • 64GB • Ventura 13.6.4.

iPad Pro (10.5-inch) • 256GB • Version 16.4

Link to comment
Share on other sites

5 hours ago, Gabe said:

I can copy-paste html tables and they work fine.

This will depend in large part on how each browser copies the table. @IOIO If the table from Gabe's link above does not work for you, I suggest you try it in a different browser.

Also, it may depend further on how the table is written in HTML, for example, whether <thead> and <tbody> are explicitly defined or the <table> just includes a bunch of <tr> as its immediate children.

Copy and paste from one program to another involves quite a lot of variability for how each handles the variety of content possibilities, so I am sympathetic to Serif if it does not work perfectly in every combination, and I do appreciate their making a reasonable effort to support as much as possible.

Link to comment
Share on other sites

10 hours ago, garrettm30 said:
16 hours ago, Gabe said:

I can copy-paste html tables and they work fine. Try it with this table: https://www.w3schools.com/html/tryit.asp?filename=tryhtml_table_intro

This will depend in large part on how each browser copies the table. (...) If the table from Gabe's link above does not work for you, I suggest you try it in a different browser.

Thanks for the valuable supplement.
Otherwise I might have started to paste the copied text somewhere else and fiddle around with f&r for the tab keys, which occurred by copying from my daily browser:

1073037911_htmltotablecopy-paste.jpg.3160515e58c3f489c173761e52ecc68b.jpg

p.s.: @Alfred "Alfreds Futterkiste" ;)

macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1

Link to comment
Share on other sites

14 hours ago, garrettm30 said:

This will depend in large part on how each browser copies the table.

I've just tried this. Copied the table linked by Gabe using Safari.

I then selected the right number of columns and rows and pasted the table successfully.

However, this doesn't work if I leave the cursor in a cell and paste. All get's pasted into one cell.

I think Publisher should realise that the contents of a table are pasted into an existing table and it should paste that to appropriate cells.

So, there is room for improvement here as far as I am concerned. 🙂

2017 27” iMac 4.2 GHz Quad-Core Intel Core i7 • Radeon Pr 580 8GB • 64GB • Ventura 13.6.4.

iPad Pro (10.5-inch) • 256GB • Version 16.4

Link to comment
Share on other sites

6 hours ago, Seneca said:

I then selected the right number of columns and rows and pasted the table successfully. (...) I think Publisher should realise that the contents of a table are pasted into an existing table and it should paste that to appropriate cells.

In my two trials above I had created a new table of 'any' size first, then placed the cursor in the 1st cell (without selecting any cell) and pasted – with different results for quite the same situation: worked for 1 of 2 trails.

Now I tried again but with selecting the appropriate number of cells before pasting – with the content copied from the Cliqz browser again it gets pasted in the first cell only.
Also pre-selecting a number of cells which is higher than needed doesn't work with this copied content.

In case it really would need me to select the appropriate number of cells before pasting then it feels like not working, because with large tables one hardly can count ('manually') the number of cells/rows first.

macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1

Link to comment
Share on other sites

  • Staff

I believe have an answer for this inconsistent behaviour.

  • When you just click inside the cell, the text will get pasted inside the text frame, without formatting it as table
  • When you select the table cell image.png and then paste, it should bring the formatted table across.

 

Link to comment
Share on other sites

Gabe, maybe this makes a difference. But there also is a different result within 1 same workflow:

In the two screenshots above for both tables I had "placed the cursor in the 1st cell (without selecting any cell) and pasted" – it appeared that only content copied from Safari gets placed as expected, from Cliqz (~Firefox) it did not.

Also I tried for content from Cliqz to select both a.)  either all and b.) exactly the needed number of cells before pasting. Both did not work either.

macOS 10.14.6 | MacBookPro Retina 15" | Eizo 27" | Affinity V1

Link to comment
Share on other sites

  • 8 months later...
  • 2 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.