Bilingual Excel format not applied when opening a document

Question

Dear community! 
 Trying to prepare a bilingual Excel so that the translation from column "Requisito" would go directly into the column "Requirements". All the necessary configuration (previous to the opening of the file) is done, however, the Editor window shows the entire content of the document and when translations are done, they are not inserted into the F column (Requirement), but appear in their original cells (Requisito column): 
 
 I checked the configuration with a another (newly created) Excel, containing cells with text and numbers and several columns and it works just fine (segments with numbers only are excluded and only text content is shown). 
 Maybe the reason is the format of the document I am working with (with all these pop-ups)? 
 Can anything be done? Or just translate as a common Excel and then fix it manually? 
 Thanks in advance!

Paul · Answer

Yulia Kovalskaya 
 Yulia Kovalskaya said: however, the Editor window shows the entire content of the document 
 This seems to be a give away that you are not actually using the filetype you think you are. If all the file content is being brought into the editor the you are most likely already using the "common" Excel filetype and not the Bilingual Excel filetype at all. 
 I would check your project templates to make sure that the Bilingual filetype is set up so it can actually be used.

Paul · Answer

Yulia Kovalskaya 
 What settings are you expecting to see there? Have you reviewed this wiki? 
 https://community.rws.com/product-groups/trados-portfolio/rws-appstore/w/wiki/6290/multilingual-excel-filetype#mcetoc_1g2pr3qm51 
 Yulia Kovalskaya said: And then an error is shown, which says that the source file is incorrect.... 
 Could mean that you have not configured the filetype settings correctly... especially f that page is the only place you looked?

Jerzy Czopik · Answer

Yulia Kovalskaya Your Studio runs in Spanish, making trouble shooting harder. Please check this article: https://gateway.sdl.com/apex/communityknowledge?articleName=000002159 and the related one quoted there.

Paul · Answer

Yulia Kovalskaya 
 Yulia Kovalskaya said: Needless to say, I will be more than grateful for your help.... 
 Needless to say a sample file would be helpful :-) 
 So I made a small one up that seems to be like yours: 
 
 I created a project, exactly the same settings as you, and translated the first segment with too many chars:

I deliberately used too may chars and on confirming an error is thrown. 
 The error reports my target length 44 exceeds the max. 20. 
 The context is also shown. 
 
 So, first point is your settings seem fine and the file seems to handle perfectly. Of course this doesn't preclude your file not being the same. A sample would have helped! Here's mine in case you want to test it: ML_Excel.zip 
 Yulia Kovalskaya said: As for default font/size, it cannot be set unless I indicate a specific column with this data (Pixels), which I don´t have: 
 So I just leave it blank (by the way, what is the difference between the length in characters and pixels?) 
 Given you don't seem to know what this is for why are you even trying to complete it? Here's a nice answer from ChatGPT! 
 Character length and pixel length are measures used in different contexts, often in digital design, software engineering, and data management. Here's the difference between the two: 
 1. **Character length**: This refers to the number of characters in a given string of text. For example, the character length of the word "Hello" is 5 because it has five letters. This is a common measure in software engineering, particularly when handling text data. It's essential in areas like database design (to limit the size of stored text), text processing, and many other areas of computer science. In terms of coding and computing, each character is typically represented using a certain number of bytes depending on the encoding scheme being used (like ASCII or Unicode). 
 2. **Pixel length**: This, on the other hand, refers to the length of a graphical element or text as displayed on a screen, measured in pixels. It is primarily used in digital design and web development. For instance, a line in an image that is 200 pixels long has a pixel length of 200. The pixel length of a string of text can vary greatly depending on factors like the font, font size, screen resolution, and display settings. For instance, the word "Hello" might take up 50 pixels in one font and font size, but 100 pixels in another. Pixel length is crucial in graphic design, web design, and anywhere else where digital visuals are involved. 
 So, in summary, character length is related to data and information processing, while pixel length is more associated with visual representation and display. 
 Yulia Kovalskaya said: So when I open my excel, the texts for translation are these:

The plugin takes texts from the column defined as context (classification field). I have done the process from the beginning 3 times and I am really desperate. So ...I cannot continue until I get the right texts to translate in my source column in Trados... 
 I think it's clear you are not using the right filetype! I suggest you do some basic checks. For example... when you create your project take a look and see which filetype is associated with the file... that's always a good idea before you waste all your time: 
 
 If it's not being picked up ten check the obvious: 
 
 are you using a different template to create your project than the one you configured? 
 is the Multilingual Excel filetype enabled? 
 Is the Multilingual Excel filetype above your other XLSX filetypes in your filetype settings? Studio will take the first enabled Excel filetype it comes to. 
 
 Yulia Kovalskaya said: Another question: supposedly I set a 20-characters limitation to the target column, but Trados gave me no warning on that in line 6: 
 Obviously because you are not using the Multilingual Excel filetype! Once you are just make sure that you also run the Import Multilingual Translations (Excel) batch task when you create your project because this is how the context gets in there. 
 I always use this custom task for Multilingual Excel: 
 
 Yulia Kovalskaya said: I also have doubts regarding the difference between Context Information / Comments. Context is the information that does not need translation? 
 Neither need translation. These are just columns that contain information you might want to expose to the translator. 
 I hope that helps? In the meantime I think you'd probably benefit from some basic training... maybe take the certification training? I think it'll help you with understanding how the application works and what you can do to help yourself.

Trados Studio > 1. Trados Studio

Bilingual Excel format not applied when opening a document

Top Replies