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

PTLtda  Identity Verified
Local time: 09:35
Spanish to English
+ ...
Jul 22, 2006

To Anyone Who Can Help,

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.

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.

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.

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...

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.



Gary Daine (X)
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.)


PTLtda  Identity Verified
Local time: 09:35
Spanish to English
+ ...
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,

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.


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

WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »

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