litanin Posted June 20, 2019 Share Posted June 20, 2019 A common practice for me is to pull lists of sponsors from an excel spreadsheet into my layout for creating thank you ads, banners, etc. I have had a recurring issue crop up when I link the overflowed text to a new text frame to create columns. The overflowed text comes into the new linked text frame tiny, and with various different text properties (size, leading, paragraph spacing, right indent, etc.). It is difficult to manually correct the text, as it seems to have a mind of it's own. Here is what I'm doing: I have been working from converted Indesign CS 5.5 files (exported as PDFs and opened in A-Pub) Select all the old text and replace by pasting Excel content over it without formatting (CTRL+ALT+Shift+V) Create new empty text frame & link with existing text frame If there is already an existing text frame that came in with the original document, it works fine. If it's a brand-new document, or all new text frames, it works fine. It only seems to crop up when mixing old and new frames. Correcting it is difficult. The best way I have found is to use paragraph styles applied with character style override, but it's not perfect--more of a workaround. The problem doesn't actually go away, because if you change the text frame's size and it reflows, the text that is reflowed changes (gets bigger or smaller, depending on the direction of the reflow). I am still running Windows 7 (service pack 1), if that factors in. I have the complete Affinity suite, all updated to the latest versions--though this issue was in the Beta of Publisher as well (found it a couple days prior to release, so thought I'd wait and see if it was addressed). Quote -Lita Intel Core i7-14700K | 32GB RAM | NVIDIA GeForce RTX 4060 Ti Windows 11 Pro, Version 23H2, OS Build 22631.4460 Affinity Publisher Beta 2.6.0.02861 Link to comment Share on other sites More sharing options...
Staff Gabe Posted July 2, 2019 Staff Share Posted July 2, 2019 Hi @litanin, Sorry for the delayed reply. If you attach an Excel document + an afpub file that's causing that issue, we can have a look for you. Ideally, we would also want to see a screen recording of your workflow in action. Thanks, Gabe. 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.