EmpressG 2 Posted June 16, 2018 Posted June 16, 2018 I know I used to be able to copy/paste a spreadsheet into a note. I did it all the time when organizing past projects. Today when I tried to add one, it isn't going. I get the text in one big list with spaces or I get nothing when I tried copying to a document, then pasting. I would assume a recent upgrade is the issue. Any suggestions? I was using Libreoffice. Also I tried just dragging the document into the program and that didn't do anything either. I seem to recall it was possible, but since I would see little useful information, just a link, I did not use it often.
Level 5* CalS 5,311 Posted June 16, 2018 Level 5* Posted June 16, 2018 46 minutes ago, EmpressG said: I know I used to be able to copy/paste a spreadsheet into a note. I did it all the time when organizing past projects. Today when I tried to add one, it isn't going. I get the text in one big list with spaces or I get nothing when I tried copying to a document, then pasting. I would assume a recent upgrade is the issue. Any suggestions? I was using Libreoffice. Also I tried just dragging the document into the program and that didn't do anything either. I seem to recall it was possible, but since I would see little useful information, just a link, I did not use it often. Yeah something squirrelly here, just tried it. I did find, however, if you copy/paste the cells and then right click inside that table area you can select Update Table to get the table format. It looks like a table is being created but without the formatting. Small PITA, but still a PITA.
EmpressG 2 Posted June 17, 2018 Author Posted June 17, 2018 Sorry, could you step by step the procedure for that. I have my spreadsheet and I copy it (it is 5x20 ) then paste it...where ? In the first cell on a table also 5x20? When I paste it into a table all the info goes into that cell, just like it was if I paste it onto the page by itself, just in a single cell. I see no right click Update table choice, only add rows, etc.
Level 5* CalS 5,311 Posted June 17, 2018 Level 5* Posted June 17, 2018 1 hour ago, EmpressG said: Sorry, could you step by step the procedure for that. I have my spreadsheet and I copy it (it is 5x20 ) then paste it...where ? In the first cell on a table also 5x20? When I paste it into a table all the info goes into that cell, just like it was if I paste it onto the page by itself, just in a single cell. I see no right click Update table choice, only add rows, etc. Copy the 5x20 in the spreadsheet. Create a new note and right click paste into it (or someplace in an existing note I suppose) Position the cursor withing the recent paste and right click (in the example below I clicked on the diagonal between Col 1 and Col 4). Select upgrade table. Before and after below.
EmpressG 2 Posted June 20, 2018 Author Posted June 20, 2018 Not working for me... I get no columns, just a list. Upgrade table not a choice as I presume it won't paste as a table? I tried to screen shot that, but the right click box goes away if I try.
Level 5* CalS 5,311 Posted June 20, 2018 Level 5* Posted June 20, 2018 3 hours ago, EmpressG said: Upgrade table not a choice as I presume it won't paste as a table? This is what I see. Highlight the cells in the spreadsheet Right click - copy and paste into a note Right click anywhere in the text Select Upgrade Table and this is what I get
EmpressG 2 Posted June 20, 2018 Author Posted June 20, 2018 Mine is definitely not pasting as any sort of table, hence the lack of upgrade table. I will try uninstalling and reinstalling the program.
Level 5* CalS 5,311 Posted June 20, 2018 Level 5* Posted June 20, 2018 2 minutes ago, EmpressG said: Mine is definitely not pasting as any sort of table, hence the lack of upgrade table. I will try uninstalling and reinstalling the program. You might try a File - Exit to reset EN. Something funky is going on for sure, but before you go to the trouble of a reinstall a reset is worth a try.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.