No More New Fonts May Be Applied

[Faith Lienhard]

Notbeing familiar with how to run VB code on an excel sheet I gave it a go using this as a guideline but with 24 sheets in just one of many files I am hoping I am doing something wrong and a better approach is available. I have done it one sheet at a time but so far have not detected any issues using this code

After using said code to detect issues other code exists to fix but maybe a script could be run to detect and fix the whole Excel file or another way exists to resolve the issue. Not trying to write a book just telling what was tried so far.

I realize this has been a long time ago since my original post. This has been something I have worked with on and off since my post. Uninstalling 32 bit Office 2013 and installing the 64 bit version did not help; at least the worksheets that had been exhibiting this behavior still do as in 32 bit.

I ran into the same issue (No more new fonts can be applied in this workbook) a few days ago, on Windows 10 with Office 365 installed. I had multiple Excel worksheets with hundreds of columns and no charts on them. The error appeared every single time I tried to type something into a cell.

Bother question Excel H&B 2019 : Alert " No more new fonts may be applied" every time edit cell. File size is not that big ( 7xx KB ) but have 16 sheet ( in sheet have many formula and link )

This problum can fix by which method?

For MSKB article about "Error New font". I found and read but Link to Microsoft web is lost "not found page" ( found article in Office 2007 ).

Update : Windows and Office update to current complete.

I search in google found an article about this error, at takling autoscale in chart, but my excel file don't chart.

I try use excel in safe mode or use this excel file in other computer ( same windows10 and office H&B2019 ) but problum.

I uninstall Office, delete folder about Office, reboot and reinstall still found the same error

Kind regards

Hi, FloJo21

Till now the problem has not been solved as standard from Microsoft. Fortunately, all my problematic files There wasn't much data, so I fixed it by copying the data to a new file on every page and set formatting it again. after trial Haven't found the same problem yet (but it's a bad approach).

@FloJo21 it's frustrating indeed. The error definatelly is related to multiple data, it might be because you have got multiple references to other cells, or I found there are issues also when you got formulas on merged cells, for e.g if you have 6 columns merged into one cell it seems like excel doesn't like it. What you can try, is to copy the sheets onto new document, but copy it the way I explained, not manually by copying and paste. Also you can try to limit the ammount of sheets of possible and divide it into let's say 2 documents. By this way you limit the data beeing processed at 1 time and so chance to bug your document with no fonts error.

@ruibm suggestion to fix problems within the doc also worked for me - The spreadsheet had a few circular references and formulas that were bonked, File > Info > Check for Issues > Inspect Document located the issues and we repaired each. The ambiguous font error also disappeared when the formulas were corrected and updated. If you close the file in question and open it back up, it should present you with a message indicating the underlying problem with the document. Fix the errors, save the file and close it. Once the error message disappears upon reopening the file, you should be able to continue working on the file without seeing the font error again.

I am still getting the message & if I have 3 Excel documents open at any one time I have to Force Quit Excel (I know it sounds a lot, but it was never a problem in the past to have multiple docs open..)

(2) from a command line, to search for more fonts I use apt-cache search font grep lcd then I use apt-cache show (replacing with the package name) for a more detailed description. installation from the command line has several variants (like aptitude) but good old sudo apt-get install works well.

Hello, I used LibreOffice for more than 6 years and every year it gets betters and more stable, and recently I started reading about typography, and the most important feature for writing is kerning, to activate it I found two places : the first is in Character>Font>Font Features dialog and the second is in Character>Position, my question is what is the difference between them and how they work, and what kind of letters spacing they apply to text : Metric or Optical ? and what happens when they are both activated ?

Kerning as OpenType feature (+kern, the option in your first screenshot) is enabled by default in every font I know, so you should not worry about it: it will be always applied. Turning out the option in your second screenshot has, it seems, the same effect of adding :-kern to the font name, that is, it disables the kerning rules defined by the font. Just keep the second option on and everything will be fine.

So, IMHO, the dialogs have different purpose: the first one controls the OpenType features in a more user-friendly way than the +/-keyword added to the font name, the second one is just a style setting for a designated range.

But OTF feature Horizontal Kerning is always (unticked) disabled and Pair Kerning is the one that is enabled (ticked) by default !

If we keep the second Pair Kerning enabled that means the correct kerning rules made by font designer inside OT font will all be ignored !

For me, the breakthrough was realizing that you must not include the font path in the font item, i.e. "item 0" must be "MyFont.ttf" and not "custom_fonts/MyFont.ttf" -- contrary to what various tutorials have been telling me.

Also worth noting: in XCode 15 with an iOS app under SwiftUI, actually creating an Info.plist file caused build failures that were really hard to debug. Apparently Info.plist isn't the normal way anymore, and you need to add properties in the XCode UI directly for the target.

I'm running Xcode 15 and SwiftUI, and @biztos answer is what did the trick for me. All the tutorials I found talked about an info.plist file which doesn't exist anymore (at least not explicitly), and to add the full relative font path including the directory name the fonts are in.

The full gambit is to select your project in the project explorer (the left side panel that shows your files). Navigate to the Info tab, under the Custom iOS Target Properties section add a new string array key/value pair with the key name being "Fonts provided by application". Add each font file name without any paths associated with it. An additional step I found somewhere was to also add "Fonts" under the Signing & Capabilities section. I'm not sure if this was required or not bc I tried a lot of stuff before I got it working.

My co-worker asked why I was using two fonts, and I at first didn't have an answer. After thinking it through, I answered that it's good for contrast and better hierarchy. My co-worker, however, insisted that I should use just one font.

Font tuning (FT) occurs when observers recognize a sequence of letters presented in the same font faster than in different fonts. ... With a number of different tasks, Sanocki (1987a, 1987b,1988, 1991) studied letter recognition in regular-font (all the letters in the same font) or mixed-font non-word strings (font alternating from one letter to the next). Letter recognition proceeded more efficiently in regular-font than in mixed-font strings, indicating that font information irrelevant to the task is nonetheless encoded by observers. We will call this phenomenon on `font tuning' (FT).

What's important for you is to create visual hierarchy. You can do this by having contrast between font size, weight and color for your header and body text. If you find that using one font for both is not creating enough contrast you can use another font for the headers to create more contrast.

It is definitely common with both designs using a combination of typefaces (typically 2; one for headers and one for body) , and sometimes only 1 typeface. I can't say I have found specific research pointing whether one is better than the other, I guess it depends on the style you are trying to convey (the brand image of the company might play an important role there too; sometimes there is also already existing brand guidelines / style guides in place which needs to be followed).

To me (not a designer by trade, but I've done some) MaaxRounded adds nothing when compared to the all-Roboto version (but the body looks very loose in MaaxRounded). With the contrast in size and weight, spotting the difference in font between the header and body is -- to quote your own example -- nitpixeling. Compare "InVision" in the title and body of the middle example. Even at the size you show (bigger than many users will see) it's subtle.

If you need a font for - then there are good chances you will need Normal, Normal+Italic, Bold, Bold+Italic variants. Personally I also use often the Light variant but it may not be your case. Even assuming you just need Latin language characters (not even Latin Extended) this is a 1 Mb download (more or less). For a mobile application (where Internet speed isn't always good and/or it varies across areas and countries) then it may be an issue. In this way you also force developers/designers to handle FOUT (which for 1 Mb with a low speed connection may be more than a flash).

In short: do it if the benefits are good enough but consider the drawbacks. I can't say if it's an issue or not: is it a LOB application with a stable user base? Is it a web site where most visitors arrives from Google? Is it an application used mostly by travelers (then with a roaming data connection?) To be truly mobile (and truly user) friendly you may need to sacrifice some of your freedom of expression.

If you want to create a distinction between headers & body text then you can try two fonts on the page or in terms of web "font-pairing". Choose what font works best. Hope this solves the problem. Let me know if you any questions.

3a8082e126