[Bug] (or maybe [Working as Intended]) Pasting into tables not always working?

[eyduh]

Hi,

I've been using publisher for layout of a lot of data that I get from spreadsheets. Most of the time I make an object that I repeat across a lot of pages then link the different sections together and this works fine, I make one text box large enough to fit one line thus one row in the spread sheet. Then I can just copy the data over column by column and all is good. (pictured)

 

My problem is when I want to actually present the data in the spreadsheet as a table in affinity. I have tried to use Place which correctly imports the .xlsx file as a table. The problem is that these usually have too many rows and there is no easy way to reflow it across pages.

 

The next idea was to setup the table the way I want it to look in Publisher then paste the data into it.

According to a post I found here on the forum I should be able to select the cells I want to paste into the table in the spreadsheet, then simply select at least two cells in the table in Publisher and paste which is supposed to make the data from the clipboard flow into the right columns and rows in the table in Publisher.

Now this kind of works some times? It seems to work when I copy and paste from Microsoft Excel specifically, but copy-pasting from the same .xlsx file open in LibreOffice, Collabora or Google Sheets does not work. In these cases everything ends up in the first cell I had selected in the table. I didn't find the solution to it until I installed a trial of Microsoft Excel and before I was experiencing the problem with everything in one cell.

I usually make custom layouts with linked text frames and don't use the table function very often, so this is not super urgent, however, in some situation with lists and schedules it would be nice to have the ability to "crop" a table frame and reflow it elsewhere. This would make the ability to copy/paste from other programs than Microsoft Excel redundant as I could just save the files as .xlsx

Anywho, thanks for a sweet alternative to the adobe mafia ❤️

[DWright]

You can copy and paste from Excel into a flowing text frame but I was not aware of an issue with Excel equivalents I will install these programs and test them and if I get the same issues I will log this with our developers.

[Wolf-z]

Hi,

please take a look at my post below. Depending on the selected paste options I get very different results, but can never get the pasted content formatted to the Publisher2 style, could be a related issue:

An example table in Publisher2 below shows the header from the master in row1, a simple paste (Ctl V) in row2 (which is in Times Roman - the cell style is reset to none from TableBody, the source cell is Arial) and Paste Without Format in row3. Row 3 is actually not in the table, but this paste generated a separate ArtText box for each cell in the paste buffer. I tried the other paste options with different results, but none would fill the table with the table format (TableBody).

Of course I can re-apply the style in row2, but was hoping not to have to for each item in the collection.

Appreciate your input, Wolfgang