Unsuccessful application of font adaptation

Question

Hello, 
 I'm giving font adaptation another swing but once again having no luck with finding the right combination to get the desired results. For now, what I just want is for Studio to display a target language in the font of my choice. Eventually, I'd like that font to also be used in the generated target file, but I've been told only the default font settings in the native file will determine the font output. But one thing at a time. 
 I have a test xlsx file written with text in MS P Gothic in Japanese to be translated into American English. Actually, I have a bunch of screenshots explaining my process so please see the powerpoint. And please try yourself using the attached excel file. 
 Thank you in advance. 
 6406.Fontmapping.pptx 
 4353.MS Gothic as default test.xlsx

Evzen Polenka · Accepted Answer

Unknown said: So essentially it's impossible to display a target in a different font in Trados or produce an English file through Trados with Arial font (or anything else) as long as the default language of the source file is MS Gothic (which it always is)? 
 Setting the Font mapping in the appropriate File Type settings should ensure that the selected font(s) will be used in the generated target file (but NOT in the Studio editor during translation!).

Paul · Answer

Unknown said: So it depends on the language and not the document type? I'd be completely fine if the description said: "font adaptation is not available for Japanese to English". Or if it was document-specific: "font adaptation is not available for Excel unless wysiwgym mode is disabled" or the like. Are any of these conclusions accurate? 
 It means that when there is an underlying font in the file, sometimes it will not work. I have not done enough testing to be able to say more than that. But I have had successful results in the past, when using wysiwyg mode and clearly with your files we do not. 
 Unknown said: Whoa, you got it work. But I've googled this for about the last 5 minutes and I cannot find any way to "turn off wysiwyg mode" in either Excel or Trados. Is this code related? 
 Nope, it's simply a display thing. Go to File -> Options -> Editor and change the display to show all tags but no formatting. Formatting would be wysiwyg. Frankly I think all translations should be done in this mode anyway. The no tags options are good for review since the tags don't spoil the flow of the text, but for translation it makes more sense to work with them on... in my opinion.

Paul · Answer

Hi Keenan Cooper , 
 
I have not tested the file but looking at your powerpoint I'd say your problem is you are only changing the font to be used in the final target document. If you want to change the font used on the screen then use the Font Adaptation settings in File -> Options -> Editor. Font Adaptation and Font Mapping are two different things.

Paul · Answer

Hi Keenan Cooper 
 It isn't the clearest explanation really, but this: 
 
 Seems to mean that sometimes, for some languages, the display font will be overridden by the font of the underlying document. So if your document was a plain text file for example then you'd see it works as expected. With the excel file the font is overridden unless you turn off wysiwyg mode and then you see what you're looking for (I set it to Comic Sans): 
 
 The font mapping works without a problem and will generate the target file in the font you set.

Trados Studio > 1. Trados Studio

Unsuccessful application of font adaptation