Mobile menu

Hidden Text From an Excel Document Showing Up in Tag Editor... Why?
Thread poster: PTLtda

PTLtda  Identity Verified
Colombia
Local time: 08:44
Member (2005)
Spanish to English
+ ...
Jul 22, 2006

To Anyone Who Can Help,

THE SITUATION:
I am using TagEditor Version 7.x
Workbench/SDLX, Version 7.x Freelance
Excel 2002

I have been issued several Excel files from a client for a database localization project. The files have quite a bit of text that does not need to be translated (code). It turns out to be approximately half of the text in the files, so it is significant.

I currently need to provide the client with a project schedule and a quote in which I will provide a discount for repeated text. To do this appropriately, I obviously need to produce a TRADOS analysis that disregards the code text as it will not be translated.

CURRENT PROGRESS:
Although it is a highly manual process, I have come to the conclusion that it is best to simply hide the text that should not be translated in the Excel files. This conclusion is drawn from the following statement in the File Formats Reference Guide...

The Excel filter does not process protected or hidden content. As a result, this type of content is not presented for translation in the TRADOStag document. Before processing, check the settings in each Excel document to make sure that hidden or protected content is made available for processing. Conversely, if your Excel document contains content that you wish to exclude from translation, ***you can hide this content before processing***. (p.238)

With that explained, I have been testing on one of the smaller files. My problem is that after hiding the content that should not be translated, I open the file in TagEditor and it is still there. Because about half the text should not be translated, my Trados analysis of the converted file is not accurate.

ADDITIONAL SETTINGS ADJUSTED:
I have set the Excel Filter Settings/Content and Macro Processing so that the "Translate content from hidden rows and columns" option is not checked. Nonetheless, it still shows when I open the file in TagEditor and it is still included in the Analysis.

OTHER SETTINGS ADJUSTED:
I have also tried adjusting the way hidden content for Excel files is handled in TagEditor by adjusting Excel_2_0_0_0.xml in the following way...

Changed this code... Default

...to this...
Off


It should be necessary, as the default value is Off. I thought I would give it a whirl anyway, but this did not help.

Has anyone had similar problems? Any help hiding this text from TagEditor so that I can get a proper analysis would be greatly appreciated.

Thanks!
Andrew


Direct link Reply with quote
 
Gary Daine
English to Spanish
+ ...
Just a thought... Jul 23, 2006

Are you reloading the original file into TE after you make these changes?

I have often made the mistake of changing some parameter and then simply re-opening the ttx file. TE will not re-evaluate the file if it already exists as ttx.

After changing the settings, you must reload the original .xls file to get the changes to work. (I even delete previous ttx files, just to be on the safe side and to force everything to start from scratch.)


Direct link Reply with quote
 

PTLtda  Identity Verified
Colombia
Local time: 08:44
Member (2005)
Spanish to English
+ ...
TOPIC STARTER
Yes I am Reloading Jul 23, 2006

Hello Gary,

Thanks for the input, but I have done that. I even went to the extent of deleting the ttx files, as you mentioned, to make sure that everything was loaded afresh after I had changed the parameters in Excel. I am completely stumped.

Thanks anyway,
Andrew

P.S. Even more confusing is that when I open the files in SDLX Standard, they act as expected. The only problem with that is that SDLX Standard does not have the Analyze tool, so I still can't get the analytical information back to my client without upgrading to SDLX Professional or higher.


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Hidden Text From an Excel Document Showing Up in Tag Editor... Why?

Advanced search


Translation news related to SDL Trados





PDF Translation - the Easy Way
TransPDF converts your PDFs to XLIFF ready for professional translation.

TransPDF converts your PDFs to XLIFF ready for professional translation. It also puts your translations back into the PDF to make new PDFs. Quicker and more accurate than hand-editing PDF. Includes free use of Infix PDF Editor with your translated PDFs.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



All of ProZ.com
  • All of ProZ.com
  • Term search
  • Jobs