MobiusTempus Posted July 26, 2023 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
Dan C Posted July 26, 2023 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
MobiusTempus Posted July 26, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
MobiusTempus Posted July 27, 2023 Author 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
joe_l Posted July 27, 2023 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
MobiusTempus Posted July 27, 2023 Author 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
joe_l Posted July 27, 2023 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
Dan C Posted August 1, 2023 Posted August 1, 2023 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 Quote
Dan C Posted August 1, 2023 Posted August 1, 2023 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 Quote
MobiusTempus Posted August 1, 2023 Author Posted August 1, 2023 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. Quote
Dan C Posted August 1, 2023 Posted August 1, 2023 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 Quote
MobiusTempus Posted August 2, 2023 Author Posted August 2, 2023 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 Quote
Dan C Posted August 3, 2023 Posted August 3, 2023 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 - 2023-08-03 16-13-56.mp4 I hope this clears things up! Quote
MobiusTempus Posted August 3, 2023 Author Posted August 3, 2023 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 - 2023-08-03 16-13-56.mp4 2.93 MB · 0 downloads I hope this clears things up! It does thank you At least I know i'm not losing it lol Dan C 1 Quote
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.