evtonic3 Posted June 14, 2023 Share Posted June 14, 2023 Can you make it where a copy of vertical cells data from Excel spreadsheet pastes into Publisher table cells? It works like this in inDesign from Excel. Now it will only place the next line in the same cell like a return making the cell bigger to fit the copied data. Quote Link to comment Share on other sites More sharing options...
Print Monkey Posted June 28, 2023 Share Posted June 28, 2023 Yes, this feature. Need proper pasting of data into multiple table cells, not just in RTF but also CSV/TSV. One idea is for Paste Special to have options for how to interpret the clipboard data as multiple cells rather than a huge blob of text pasted into one cell. Perhaps try to make Paste in tables "smart" by default, make "paste without formatting" force everything into one cell, and allow Paste Special to have options like CSV/TSV/RTF table data to force a particular interpretation when the default "smart paste" behavior doesn't interpret the data as intended. Quote pRiNt! mOnKeY! 🖨️🙊💻Lenovo Legion 5 Pro*, Intel(R) Core(TM) i7-12700H, 2300 Mhz, 14 Core, 32GB DDR5-4800, nVidia RTX 3070 Ti 8GB, Windoze 11 💻*Sometimes gets used for something other than games. Link to comment Share on other sites More sharing options...
scott2023 Posted January 3 Share Posted January 3 I found a YouTuber who demos how to do this on Windows, but I can't recreate it on Mac: Quote Link to comment Share on other sites More sharing options...
scott2023 Posted January 3 Share Posted January 3 The solution seems to be: prep your data in your spreadsheet export as an MS Excel doc In Affinity Publisher, use the Place tool to place the Excel doc. (It will be interpreted as a table.) https://affinity.help/publisher/English.lproj/index.html?page=pages/Tables/createTables.html?title=Creating tables Quote Microsoft Excel Workbook spreadsheets (XLSX) can be placed directly in Publisher as tables. The following are not currently supported: Some formatting, but not all, appears to carry over. Posting this here mostly so next time I have this question, when I search it, this answer will pop up! 😄 Quote 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.