Mark text not for translation Thread poster: QUOI
| QUOI Chinese to English + ...
Hi all, I am new to XTM and am aware that I can mark text not for translation by applying "DoNotTranslate" style to text concerned. I am wondering however if I can achieve this by marking text in a particular color like you can do with Excel files in DVX (ignore red)? I am currently dealing with many excel files in which the client has already marked non-translatable text in red. Any information will be appreciated. Thank you in advance. | | | XTM Intl United Kingdom Local time: 15:19 Excluding text marked in certain color from translation | Mar 4, 2014 |
Hello, In XTM version 8.2 we have introduced the possibility to exclude text marked in any color from translation in Excel files by preparing a proper ITS rule. In order for us to prepare it for you, please provide your company name, customer name to which this rule should be applied and the mentioned Excel file. Please send your reply to [email protected] Kind regards, XTM Support Team | | |
This may sound very strange, but it's based on the fact that the Track Changes feature of MS Office (and only MS Office, it seems) doesn't track changes if those changes were made outside the program. And it just works, as we say. - Open the spreadsheet. - Set Track Changes. - Delete the cells you don't have to translate (Find red text, replace with nothingness) - Save. - Translate in your CAT tool - Export. - Open in Excel. - Reject All Cha... See more This may sound very strange, but it's based on the fact that the Track Changes feature of MS Office (and only MS Office, it seems) doesn't track changes if those changes were made outside the program. And it just works, as we say. - Open the spreadsheet. - Set Track Changes. - Delete the cells you don't have to translate (Find red text, replace with nothingness) - Save. - Translate in your CAT tool - Export. - Open in Excel. - Reject All Changes. Especially the very last item on the list sounds very counterintuitive, but it's crucial. Please try on a copy of the Excel file. Cheers, Hans ▲ Collapse | | | QUOI Chinese to English + ... TOPIC STARTER
Appreciate your info. Hopefully it can become a user-defined option instead of having to request it every time when there is a need. Thanks. XTM Intl wrote: Hello, In XTM version 8.2 we have introduced the possibility to exclude text marked in any color from translation in Excel files by preparing a proper ITS rule. In order for us to prepare it for you, please provide your company name, customer name to which this rule should be applied and the mentioned Excel file. Please send your reply to [email protected] Kind regards, XTM Support Team | |
|
|
QUOI Chinese to English + ... TOPIC STARTER Interesting solution | Mar 4, 2014 |
A bit mad but I shall try. Thanks. Translation will be regarded as changes and if you reject all changes, doesn't that mean your translation is also rejected? Meta Arkadia wrote: This may sound very strange, but it's based on the fact that the Track Changes feature of MS Office (and only MS Office, it seems) doesn't track changes if those changes were made outside the program. And it just works, as we say. - Open the spreadsheet. - Set Track Changes. - Delete the cells you don't have to translate (Find red text, replace with nothingness) - Save. - Translate in your CAT tool - Export. - Open in Excel. - Reject All Changes. Especially the very last item on the list sounds very counterintuitive, but it's crucial. Please try on a copy of the Excel file. Cheers, Hans
[Edited at 2014-03-04 09:52 GMT] | | | Quantum-mechanics | Mar 4, 2014 |
QUOI wrote: A bit mad but I shall try. Completely crazy. I found out by leveraging my rocket engineering and quantum-mechenics classes, and sheer intelligence. And a bit of luck. Lots of luck, actually. Cheers, Hans | | | Sorry for not answering your last question | Mar 5, 2014 |
QUOI wrote: Translation will be regarded as changes and if you reject all changes, doesn't that mean your translation is also rejected? No. You don't seem to understand the very strangeness - and essence - of this solution. The translation is not rejected, because MS Excel didn't track it. It can't. Excel (Word, PPP) can only track changes if made in Excel (Word, PPP), and you performed the translation in your CAT tool. So after rejecting the the changes, you'll end up with an Excel file containing the translation and the untranslatables in red, exactly what you want. I admit it may take some time to get used to the idea. Cheers, Hans | | | QUOI Chinese to English + ... TOPIC STARTER A workaround it is... | Mar 5, 2014 |
Thanks for the trick. Cheers. [quote]Meta Arkadia wrote: No. You don't seem to understand the very strangeness - and essence - of this solution. The translation is not rejected, because MS Excel didn't track it. It can't. Excel (Word, PPP) can only track changes if made in Excel (Word, PPP), and you performed the translation in your CAT tool. So after rejecting the the changes, you'll end up with an Excel file containing the translation and the untranslatables in red, exactly what you want. I admit it may take some time to get used to the idea. Cheers, Hans | |
|
|
Post removed: This post was hidden by a moderator or staff member for the following reason: duplicate post | There is no moderator assigned specifically to this forum. To report site rules violations or get help, please contact site staff » Mark text not for translation CafeTran Espresso | You've never met a CAT tool this clever!
Translate faster & easier, using a sophisticated CAT tool built by a translator / developer.
Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools.
Download and start using CafeTran Espresso -- for free
Buy now! » |
| Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |