MobiusTempus Posted July 26, 2023 Share Posted July 26, 2023 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 An extra row is added....why?? 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. Quote Link to comment Share on other sites More sharing options...
Dan C Posted July 26, 2023 Share Posted July 26, 2023 Hi @MobiusTempus, Welcome to the Affinity Forums 4 hours ago, MobiusTempus said: 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. 2023-07-26 11-37-31.mp4 4 hours ago, MobiusTempus said: 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! Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 26, 2023 Author Share Posted July 26, 2023 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* Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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. Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 See my answers and videos in this thread. This was discussed here Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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 Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 5 minutes ago, MobiusTempus said: As I am copying from a spreadsheet this is not helpful or relevant It doesn't matter. The principle is the same 2023-07-27 о 09.26.54.mov Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 (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 July 27, 2023 by MobiusTempus Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 1 minute ago, MobiusTempus said: Are you saying I have to paste, then undo then paste again? No, in the video I showed different ways and places to insert a table Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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... Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 I just tried this with Google Sheets. It doesn't work on Mac. You need to save the table first and then place it using File-->Place. This is how it works. Or copy it from LibreOffice as shown above. If you're using Windows, try inserting the table via Edit-->Paste special. Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 7 minutes ago, anto said: If you're using Windows, try inserting the table via Edit-->Paste special. I checked it out. It doesn't work. Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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: I'm doing something wrong (very possible) There is an issue in V2 Honestly, thanks for the help, but its starting to feel like I'm just repeating myself now. Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 How to make it work. Watch the video carefully. Just select the table with Move Tool and paste the table from Google. 2023-07-27 о 09.57.26.mov Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 6 minutes ago, anto said: Just select the table with Move Tool and paste the table from Google. Is it works for you? Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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 Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 6 minutes ago, MobiusTempus said: This...is what I get - The first picture is with the relevant cells selected to paste into from google, the second using your method Didn't you go inside the table? You just need to select it. There should be no cursor and headers (A,B,C,...). If there is, it won't work. It works for me. That's weird. Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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. Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 Are you working on Mac or Windows? On Windows, you need to use Edit-->Paste Special to insert tables. For Mac, just use Paste. Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 Windows, and the same issues occur with paste special as well, no matter which version of paste-special i choose Quote Link to comment Share on other sites More sharing options...
anto Posted July 27, 2023 Share Posted July 27, 2023 8 minutes ago, MobiusTempus said: Windows, and the same issues occur with paste special as well, no matter which version of paste-special i choose 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( Quote Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 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 Quote Link to comment Share on other sites More sharing options...
joe_l Posted July 27, 2023 Share Posted July 27, 2023 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? copypaste.mp4 Quote ---------- Windows 10 / 11, Complete Suite Retail and Beta Link to comment Share on other sites More sharing options...
MobiusTempus Posted July 27, 2023 Author Share Posted July 27, 2023 2 minutes ago, joe_l said: Maybe pasting a tab separated list might help? copypaste.mp4 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) Quote Link to comment Share on other sites More sharing options...
joe_l Posted July 27, 2023 Share Posted July 27, 2023 Export as tab separated list and copy the content of that list into the table. Yes, I know, this is too much work too. Quote ---------- Windows 10 / 11, Complete Suite Retail and Beta Link to comment Share on other sites More sharing options...
Recommended Posts
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.