Jump to content

Recommended Posts

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:

  1. I have been working from converted Indesign CS 5.5 files (exported as PDFs and opened in A-Pub)
  2. Select all the old text and replace by pasting Excel content over it without formatting (CTRL+ALT+Shift+V)
  3. 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).

Share this post


Link to post
Share on other sites

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. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×