Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by Loquos

  1. I didn't see any unusual overlaps, but I did have to manually refresh to get it to accept that I had changed the language. I'll mess around in the back end a bit more later, and see if I can discover the underlying problem. Otherwise, I'll report a bug. 🙂 Thanks!
  2. I have it as a Character style. But I see no way to set a Character Style language.... WAIT! When did they add that? I swear I'd never seen a Language option under Character, only under Paragraph, so I have a bunch of Paragraph styles that should be text styles... OMG. Snake would have bit me. So now I've done that, but it continues to mark them as incorrect unless I select reach one and reapply the style. Is there an 'update' button I'm missing?
  3. One of the most tedious parts of finalizing a Publisher file for print is the last spell check. Inevitably, it flags all emails and URLs as unknown words. I have to go through all of these, ignoring or 'adding to dictionary' just to find the few outliers. Is there some way to tell Affinity to not bother with anything with an @? Or .com .net .org etc. in it?
  4. There are only certain lines that need to be formatted a certain way. It's still a problem because I can have anywhere between 5 and 15 records per page. So I guess Pearl is the way to go!
  5. Old comparison because that's when my knowledge of what Adobe InDesign could do. So no idea what they are doing now. I have records of varying length. I want each entry to have one line break between them, and then flow from page to page. Some pages may end up with 10 records, some with 5, some with 13. Unless I'm missing something, the current beta merge means that each new record gets its own text frame - which means I have to manually move all the text frames, or move all the text into one text frame. But if I'm missing something, please let me know! I'd love to know how to do a data merge that doesn't make massive amounts of text frames as a result.
  6. I absolutely love that Affinity Publisher now has data merge. It's definitely better than what Adobe was offering a million years ago. But after trying it I realized I was still going to be stuck with multiple text frames when what I really needed was for all of the merged data to flow from one columned text frame to another, page by page. When you're dealing with hundreds of entries, there's nothing quite as mind-numbing as putting everything back together so that you can adjust for pagination, unused space, etc. Well, my husband (who writes code for scientific database uses) offered to make a little bit of Pearl code for me that I could then use to do my own data merge, which results in a simple .txt document being created with all of the info exactly as it needs to be all in one place that I can then copy and paste into Publisher and quickly do a bit of hand formatting (using a combination of find/replace for specific characters and and applying paragraph styles). It has made my life a million times simpler - though it still means if my client comes back to me with a change, I either have to manually go in to make the update (which can sometimes require updated pagination), or redo the entire directory. I realize Publisher's data merge functions are still in beta, but I would be ecstatic to know there's something in the works to have the resulting data merge exist in one continuous text frame. Barring that, would there be a way my husband's code could mark up the data merge in such a way that when I copy and paste it into Affinity, Affinity will automatically apply certain formats? Or is that a bit too outside the box? I'm attaching the little program here. For anyone who understands these sorts of things. It's custom made for me, so don't expect to be able to download as is and use it for your project, unless you know how to change the code. convert_directory.pl
  7. As this was the first time I'd messed with either Index or Table of Contents, I don't know if anything I did was unusual or not. This is a file that was originally built out a few years ago. I simply 'save as' and create the next year's file from the previous. Not sure if that could cause anything odd? I did the Table of Contents first. In fact, I deleted the old frame that was there and completely redid it - styling and everything. Another day, I created the Index. This is a new element for this file. Previous versions did not have an Index. It took me a few tries to understand how to build it out. In fact, I'm sure I deleted the entire original frame and started over at one point. Everything has always been in the same file, and I didn't copy any of the textual elements from any other file. If I recall anything else, I'll come back and make an update.
  8. Yes. I've tried all the buttons and ways to update. It still gives an error, but as far as I can tell there is nothing out of date.
  9. Sorry! got busy with work and forgot to come back to this in time. The DropBox link seems to be dead now. Do you mind posting again? The issue still persists. In fact, it does 3 separate alerts. Two include page numbers where these items are located. The 3rd does not include a page number, and seems to be the one that does go away.
  10. Either I've found some weird bug, or I'm doing something wrong. My Preflight says that "The document index needs updating." and provides a "Fix" button. However, every time I mash the button, nothing happens other than additional entries showing up in the Index Panel (but not on the page). The error remains, and the Index Panel resets itself back to one entry per after a few moments. (see screenshots attached) If I delete the frame with the entry, the error still remains. I have only 1 index and 1 table of contents inserted in the entire document. Am I missing something here?
  11. Yes, that was a problem in InDesign as well. I know Microsoft Word will ignore them, if you're doing a data merge there. It would be nice to have a way to ignore empty cells in Publisher as well.
  12. Now we're just missing a feature to ignore empty cells. And is there any way to merge all the text cells afterwards? I ask because for my use some cells end up having more lines than others, and it would be nice to be able to adjust the flow of text without having to move every single cell individually. Yes, I realize this is still in beta. I'm just wondering if this is in the works or if it's something I missed during my self-taught crash course.
  13. Ok... never mind. I just remembered that to do this in Adobe InDesign you had to start with a file with only ONE page, and then it would create others as needed. So I tried that in Affinity Publisher and it worked just fine. 🙂
  14. I think I'm missing something. I can get the Data Merge fields set up just fine, formatted the way I want them, and have it create a page of merged data. But I'm missing a setting that tells it to create a new page should the amount of entries not all fit on one page. I have .csv files that will span multiple pages when processed through Data Merge, and I'd hate to have to only do one page at a time! Is this a feature of the beta? Is it possible to connect Data Merge frames or otherwise tell the program to duplicate the process on subsequent pages until all the entries have been created? Because I'm not seeing a way to do that.
  15. Hello! I'm on Publisher 1.8.4 on OS 10.15.7. First, I must say I love the Preflight checker for Publisher! It saves me so much time, and is miles beyond what I was able to do with Adobe InDesign. Especially some of the things you can hit the 'fix' button and move on. Such a time-saver! However, one of the things I struggle with in the Preflight check is when I double-click on an error to take me to that error. With larger text frames, it becomes difficult to pinpoint where this character error is (such as 'straight quotes used') when it highlights a text frame with thousands of characters but only the error is in gray. One character, highlighted in gray! I cannot find a way to adjust the color Preflight uses to highlight these errors, but it would be lovely if you could control this color to easily spot that one errant straight quote that needs to be fixed. I know this seems like a really minor request, but it would make that last file check before sending to the printer so much easier. Thanks!
  16. Have you checked your keyboard settings for any other languages listed there? If PT is checked there, that might be the problem. If it's not, try checking it, looking to see if that changes anything in your file, then unchecking it and looking again. "English" spelling appears to default to US English (odd, because Affinity is not based in the US). If you don't see the UK English options in the General Settings, that's probably the problem. I had the same issue, wanting to check UK English but it kept overlooking spellings because it was checking in US English. Once I updated my Keyboard settings to include UK English, I could then pick UK English from the General settings and it started checking the document correctly. As far as stop PT being the default, I'm unsure... but if you change the language setting in the BASE style, that should populate any new styles you makes with the same setting.
  17. All I know is that nothing I did in Affinity made any difference at all until I made sure my System settings indicated UK English as a language I use. I just tried to create what I had noticed the first time... but now I cannot reproduce.... so I guess we can forget that 'discovery'. 🤣 I do know when it was showing as ("Unknown [insert language here]") nothing worked properly, and it was only after I went into this odd setting under Keyboard that it stopped doing that. System Preferences > Keyboard > Text > Spelling > Setup... and then make sure the languages you want to use are actually selected. When I first checked this while trouble-shooting, while my Language & Region System Preferences included UK English, it was NOT checked in the Keyboard settings, even though it showed in that dropdown box. And once I checked it, tadaaa! UK English was finally a language I could select, both in Spell Check and in the Text Style options. Maybe you have to have them set in both Language & Region and Keyboard? I'm not sure at this point, but it's working and I don't want to mess with it. (Why are there THREE options in my Language & Region settings I have no idea, but I recall trying to get rid of the "English" one and it just came back again, so that must be a System bug.) Edit: I don't know how to do the cool video embed, so if you want to see the settings I tweaked, you'll have to download. Sorry! Screen_Recording_2020-08-25_at_14_22_24.mov
  18. I should add, the Preference Panel Auto Correct setting seems to be linked to the working document. If I open Publisher with no file open and check the Auto Correct settings, it's back to English (US). When I open the file with the UK English and open the Auto Correct setting again, it shows English UK. Not sure that will help anyone, but I thought I'd point it out.
  19. I just discovered the difference between these two and it's beautiful... Publisher has an Auto Correct preference in the Preferences Panel, which also has a language dropdown box. It appears that even if you set your language in the Text Style, if the language in the Preference Panel is something else, and the Base Style as something else, it doesn't work properly. Setting to UK English in the Text Style but having the Base Style or Preference Panel indicate something else (English - which appears to be US English) results in errant zeds not being picked up as a misspelling in the UK English text. If I set the Auto Correct preference to the main language I'm working in, then set my Base Style to that same language, then as I make new styles, I only need to indicate the language if it varies from the Base. Since the publication I'm working on is in UK English and Brazilian Portuguese, I have the Language in the Preference Panel set to English (United Kingdom), then the Base Text Style set to UK English, and then I can set up my Text Styles for Brazil PT by indicating that language in the a Text Style that I apply to the Portuguese text. So when I pop in some non-UK English text in a text frame, until I set the correct Text Style, the Auto Correct is going to mark everything wrong. As soon as I apply the PT Text Style, it overrides the UK English. (I don't know why the UK English wasn't being overridden when I selected that even though my Auto Correct was set to English US... still some bugs to work out in the system? But this is how I got it all to work properly, and now that I see it, it seems so obvious!) Here I'd been selecting the UK English language each time because I couldn't sort out what the issue was and it still kept relining everything, and all I needed to do was set the Auto Correct and Base Style to the correct language, and the rest cascades! Yay! I guess this is all just a long-winded way of saying, if you see something funny happening with your Spell Check, go check the Auto Correct language preference and your Base Style language setting. Those may be your culprits.
  20. Once I realized you meant the Keyboard system preferences, I found the Text section and checked the Spelling dropdown. British English was listed, but for shiggles I hit Set Up, and guess what? It wasn't checked there! I checked it, fired up Publisher, and now it's an option in the Language dropdown. Then my problem was getting it to stop marking the spelling wrong. First I changed all the text styles to the correct language. But it was still marking words wrong even though they were ok. Then I remembered that Publisher has it's own settings for Spell Check and went in there, changed to UK English, and then everything was good! Is there a reason you can indicate language in the Text Styles but the Publisher Spell Check option overrides wether it considers something spelled wrong or not? But yay for finally getting the UK English dictionary to work. An obvious bug in the computer OS, and not within Affinity. Thanks!
  21. Hello! I find my situation ironic, as I dealt with all my US English text being underlined because it wasn't UK English for the longest time, and now that I need UK English checks, it simply won't come up in AP. I am attaching multiple screenshots here, as I'm at my wit's end as to why I cannot get UK English to show up as a spell check option. First, I checked my system languages, realized English (UK) wasn't listed there under 'Preferred languages', added it, and restarted my computer. However, it doesn't matter if I go into the Text Style panel, the AP preferences itself, or the character panel, no where does English (UK) show up as a language option. But it does show up under the Hyphenation panel. My mind is blown. I don't see how it would affect anything, but I added the British keyboard layout to my system preferences, and restarted my computer once again. I'm getting the same results. English (UK) doesn't show up as an option for spelling. There is, however, a en-GB folder in the AP Resources folder. What do I do to get English (UK) to show up as a spellcheck/language option? Do I dare copy the en-GB data file elsewhere, delete it from the AP folder, then drag and drop in an attempt to 'reinstall'? Will this break anything? I cannot think of anything else to do. Help! I am on Mac OS 10.15.5 / AP 1.8.4
  22. Going to assume you're trying to copy and paste from something other than Microsoft Excel or LibreOffice. I noticed this problem when trying to copy and paste from a Google Spreadsheet. However, there is a workaround. Save out the spreadsheet as an .xls - then open it up in LibreOffice, select all the rows and columns you want to transfer. (Make sure you have the same rows/columns ready in your Affinity Publisher file.) Copy & paste. At least for Google Spreadsheets, this works. Must be something in the Google Spreadsheets online coding that doesn't currently play well with Publisher. This same trick should work if you load the document in Excel. LibreOffice is free and is what I use if I'm not online to use Google Suite.
  23. OMG! I should have read further. Who would have thought 'Automatic by Language' would have been set to UK English??? Restarted Publisher after updated the System preferences... and now I can find all the styles with the 'missing dictionary' error and fix them so it stops underlining all the differences in spelling between US English and UK English. Thanks so much!
  24. Ah! This is probably my issue. I live in Brazil, but I have my language settings set to US English. All is fine on my computer, and in Affinity Publisher preferences I can select English US, but upon restart, this option doesn't show in the Text Style option. I'd really rather not change my region to US to avoid a weird bug. I too prefer my temps, units, etc. to match the culture I'm living in on my computer.
  • Create New...

Important Information

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | 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.