Table Cell Importing oddness (Publisher v2)

[MobiusTempus]

A couple of odd issues have come up that didn't happen (at least as much as I can remember) in V1 when pasting data into cells. I accept it could be something I'm doing wrong but honestly trying to find the solution to this is...frustrating lol.

When I post data into cells from another spreadsheet (in my case LibreOffice)  the data is added correctly, but the following also occurs 

1. An extra row is added....why??
2. The cell text format defaults to times new roman and a much smaller font - this is despite, as far as I can tell, having the correct table format option selected.

 

 

 

[Dan C]

Hi @MobiusTempus,

Welcome to the Affinity Forums

4 hours ago, MobiusTempus said:

1. An extra row is added....why??

I'm not seeing an extra row being added when pasting from Libre Calc - however I can see that a return character is copied and pasted when selecting a cell in Libre Calc and pasting into Publisher.
This occurs in both V1 & V2 of the Affinity apps, and does not occur when copy and pasting from Google Sheets, therefore appears to be due to the data that Libre Calc adds to the clipboard and is not controlled by Publisher.

 

4 hours ago, MobiusTempus said:

1. The cell text format defaults to times new roman and a much smaller font - this is despite, as far as I can tell, having the correct table format option selected.

In my testing, the data pasted into the table cell retains the formatting already set for my table - in my case Arial 12pt.
The font formatting within your table will be determined based on the 'Table Body' Text Style so I would recommend checking your settings here.

I hope this helps!

[MobiusTempus]

Thanks, its gives me something to look at... "funny" thing is i was pasting from LibreClalc because of other issues before...but i'll definatly double the Table Body Text. Could have swore that it was set correctly but... *shrugs*

[MobiusTempus]

Did what you suggested for the copy and paste issue and the same issue I had before - Copy/Pasting straight from Google Sheets puts everything into one cell , the first one of those selected (yes I've selected all the cells I want to paste into) - yet keeps the text size and format.  Copying from LibreCalc adds things in the correct cells, yet changes the font format and adds the extra row. (see picture 1 - the one on the left is CP from LibreOffice, and the right when i do the same from google sheets - I see no carriage return symbol  making the cell larger, it literally adds another row)

I selected the correct table styles (I have double, tripled and quadruple-checked this)

YET

When I paste it, the formatting/style changes...

 

As my work relies on a lot of tables, this is proving to be extremely frustrating and annoying. I can see from your example that you are not experiencing the same issue, so I am pulling my hair out trying to figure out what the flip is going on and why did this start after upgrading to V2. 

 

[MobiusTempus]

1 minute ago, anto said:

See my answers and videos in this thread. This was discussed here

 

As I am copying from a spreadsheet this is not helpful or relevant

[MobiusTempus]

I did that, as I mentioned in my third post (yes I've selected all the cells I want to paste into).

Are you saying I have to paste, then undo then paste again? I ask because the vid you sent doesn't really make it clear what I have to do differently then what I am already doing.

 

 

Edited July 27, 2023 by MobiusTempus

[MobiusTempus]

Which as I mentioned I've done that already.  The "phantom" carriage return doesn't show up (yet the row gets added). The table formatting keeps changing, even though I've checked multiple times.

I hope you can see why this is frustrating the *bleep* out of me right now as I am following ALL the examples and instructions and yet they..do...not...work...

[MobiusTempus]

1 minute ago, anto said:

I checked it out. It doesn't work.

So, Publisher doesn't work with Google Spreadsheets

yes...thats why i mentioned LibreCalc before in my first post and what I was doing in Version 1 was 

• do my workings in google sheets
• copy the cells/information into LibreCalc
• copy from LibraCalc into the tables

Which was a bit fiddly, but for the most worked

but it now is NOT working in v2 the way it did before.

which means one of two things:

1. I'm doing something wrong (very possible)
2. There is an issue in V2

Honestly, thanks for the help, but its starting to feel like I'm just repeating myself now.

[MobiusTempus]

3 minutes ago, anto said:

Is it works for you?

no...it doesnt...

This...is what I get - The first picture is with the relevant cells selected to paste into from google, the second using your method

[MobiusTempus]

Just now, anto said:

Didn't you go inside the table? You just need to select it. There should be no cursor. If there is, it won't work.
It works for me. That's weird.

Yes..I did..

 

This seems to be the issue here... What is working for some people is NOT working for me...and I cant figure out why...which is why i came to to the forums in the first place and started a thread.

 

The "formatting and extra row" issue i can...sort of...work with...but's basically now doubled the amount of work I have to do.

[MobiusTempus]

Windows, and the same issues occur with paste special as well, no matter which version of paste-special i choose

 

[MobiusTempus]

1 minute ago, anto said:

I just tried to do it on Windows. In windows, another problem is added in contrast to mac. Blank lines are added.

So, Publisher doesn't work with Google Sheets, unfortunately(

Yes, i've established that already...in my third post in this thread...

Thanks for your attempts at help, but honestly, i'm gonna have to give up trying to get this solved as all the solutions provided do not work in anyway

[joe_l]

17 minutes ago, MobiusTempus said:

i'm gonna have to give up trying to get this solved as all the solutions provided do not work in anyway

Maybe pasting a tab separated list might help?

[MobiusTempus]

2 minutes ago, joe_l said:

Maybe pasting a tab separated list might help?

So.to make sure i have this right...copy from LibreCalc/Google Sheets into a text box, tab separate it, then paste that text into the table? Because if so, thats going to make even MORE work fo me then just reformatting the tables after i paste into them (what i'm having to do now)

[joe_l]

Export as tab separated list and copy the content of that list into the table. Yes, I know, this is too much work too.

[Dan C]

Apologies for the delayed response here @MobiusTempus as I have been out of the office for a few days.

Are you able to attach an .afpub file and a Libre Calc file that shows the issue you've described? If you'd like a private upload link for these files, please don't hesitate to ask

[Dan C]

It appears there are known incompatibly issues when copying data from online Spreadsheet apps into Publisher tables causing the issue you're seeing Anto, from the below thread, this user found that both Google Sheets and Excel 365 online pasted the full results into a singular cell, rather than retaining the table layout -

This would indicate that online services, such as Google Sheets and Excel 365 online are unable to copy the required formatting to the clipboard, in order to retain individual cell data.

In the case of using an online spreadsheet application, I'd recommend exporting in a format that can be opened by a 'local' editor (such as .xlsx, TSV) which can then be copied and pasted into Affinity directly.

However, this isn't directly the issue that the OP was reporting, simply a mistake I had made in trying Google Sheets before installing Libre Calc

[MobiusTempus]

52 minutes ago, Dan C said:

Apologies for the delayed response here @MobiusTempus as I have been out of the office for a few days.

Are you able to attach an .afpub file and a Libre Calc file that shows the issue you've described? If you'd like a private upload link for these files, please don't hesitate to ask

i'm away from the computer that has those files, but might be able to send a link for somethng tommrow. i'll be honest here, ive kinda just given up on getting this sorted - otherwise i'm  going to be spending more time on trying to find a solution than just doing the re-formatting.

[Dan C]

No problem at all, I certainly understand.

If you are able/willing to provide these files, you can do so here - 

https://www.dropbox.com/request/EFbcOGSIucm39eWQ9wSU

Once uploaded, please reply here to let me know

[MobiusTempus]

13 hours ago, Dan C said:

No problem at all, I certainly understand.

If you are able/willing to provide these files, you can do so here - 

https://www.dropbox.com/request/EFbcOGSIucm39eWQ9wSU

Once uploaded, please reply here to let me know

Uploaded the files - i left the last table blank and the data i used is in the second tab of the calc sheet - the rest of the tables in the main doc show you how they should be etc

[Dan C]

Thanks for providing those for me and my apologies for the delay once again!

When copying the cell data from Libre Calc and pasting into a single cell in Affinity, you can see that each line is copied with a tab and return character at the end of each line - 

For this reason, when copy and pasting into multiple cells in Publisher, a new Row is added at the bottom.

Unfortunately this is caused by the data that Libre Calc adds to the clipboard and not Affinity Publisher directly. You can see this by deleting the final return character from the pasted text in a singular cell, then copy and pasting this new data across multiple cells. As the final return character is no longer present, no additional row is added -

 
I hope this clears things up! 

[MobiusTempus]

6 minutes ago, Dan C said:

Thanks for providing those for me and my apologies for the delay once again!

When copying the cell data from Libre Calc and pasting into a single cell in Affinity, you can see that each line is copied with a tab and return character at the end of each line - 

For this reason, when copy and pasting into multiple cells in Publisher, a new Row is added at the bottom.

Unfortunately this is caused by the data that Libre Calc adds to the clipboard and not Affinity Publisher directly. You can see this by deleting the final return character from the pasted text in a singular cell, then copy and pasting this new data across multiple cells. As the final return character is no longer present, no additional row is added -

 
I hope this clears things up! 

It does thank you  At least I know i'm not losing it lol