Insert text as table

[Eddy-2]

In the Help Files, I search for "Insert text as table" and after a bit of searching around, I'm told that:

"It is also possible to copy and paste cell contents from Microsoft Excel spreadsheets into Publisher tables."

However, unless I'm missing something, it doesn't say how.

The following seems to work:

Clip copy the required cells in Excel.

Using the Publisher's Table Tool, place a single column table - say 5 rows - on the page.

Select all the cells within the table (Ctrl-A twice).

Press Ctrl-V.

[atesz]

Here’s a video tutorial on the topic (at 9:39): https://affinity.serif.com/en-us/tutorials/publisher/desktop/video/337317434/

It doesn’t work for me either. It places all of the content in the first cell.

[carl123]

1 hour ago, atesz said:

It doesn’t work for me either. It places all of the content in the first cell.

Where are you copying the "content" from?

[atesz]

I tried with OpenOffice, then tab-separated and comma-separated text.

Now I have Excel on my computer and it works!

[walt.farrell]

If you copy from an OpenOffice Calc table it should work. (Actually, I haven't tried this with OpenOffice, but it does work with LibreOffice Calc.)

Or if you copy from a LibreOffice Writer table it should work. I've just done one like that.

But, you need to make sure you select a cell of the Publisher table. Don't just put the cursor in a cell. Actually select it so the cell is highlighted. If you only put the cursor in a cell it will all paste into that cell.

[carl123]

11 hours ago, atesz said:

I tried with OpenOffice, then tab-separated and comma-separated text.

Now I have Excel on my computer and it works!

Tabbed Text also works but seems to depend on the application you take the tabbed text from.

E.g. Tabbed text works if copied from Word but not from Notepad