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).

-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

  • 2 weeks later...
  • Staff

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. 

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.