Search the Community
Showing results for tags 'import from excel'.
Found 1 result
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).