Jump to content

Recommended Posts

Posted

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.

 

 

 

Posted

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!

Posted

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*

Posted

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. 

 

example 1.png

Posted (edited)

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 by MobiusTempus
Posted

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...

Posted
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.

Posted
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

dnw 1.png

dnw 2.png

Posted
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.

Posted
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.

bug.PNG.810a032a3e49d93f16090fc4ff48db6a.PNG

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

Posted
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?

----------
Windows 10 / 11, Complete Suite Retail and Beta

Posted
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)

Posted

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

----------
Windows 10 / 11, Complete Suite Retail and Beta

Posted

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 :)

Posted

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 :)

Posted
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.

Posted
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

Posted

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 - 

image.png

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!

Posted
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 - 

image.png

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

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.