Embedded Content problem with Excel files

Question

I am trying to block the tags in source excel file . I went to Options menu, selected Microsoft Excel 2007-2013, Embedded content and added tag definition rules, but still the tags seem to appear on my file without being blocked... What am I doing wrong?

Paul Filkin · Answer

Hi Yuko, 
 
Aside from the missing <BR> placeholder tags rule are you opening the Excel file from scratch again? Once you have prepared the translation adding rules won't help as the file is already converted. So you have to add your new rules and then open the file as a new project or single file translation. 
 
Regards 
 
Paul

Paul Filkin · Answer

Also... I just noticed your sdlxliff was created from an XLS which is not the filetype you are using. This would be "Microsoft Excel 2000-2003". 
 
Regards 
 
Paul

Paul Filkin · Answer

Hi Yuko Baba , 
 In theory the PO filetype from Supertext should work, but it's failing for me in 2017 with an error message. This is probably not surprising as the filetype was built for 2015 but I tested it there too and it also failed. 
 The setting you need for your file would be this one because your File has the source text (msgid) in the target slot (msgstr): 
 
 Perhaps Remy Blaettler will have some clue about the error message and comment on whether a 2017 version is forthcoming? 
 
 But in the meantime I also tested your file in POEdit and this opened the file but exactly the same as Studio with the default filter... although it did report a language error. 
 So, if the target text can replace the msgstr value because the msgid is really a developers string then you could use a regex based filetype for your file as it's pretty simple with only single lines (assuming your real ones are the same). Then I get this: 
 
 I'd stress that this filetype is not suitable for all PO files, it's only good for the sample I looked at from you. But perhaps this will help you for now? I put the sample filetype here: 
 yuko_PO.zip 
 Regards 
 Paul

Paul Filkin · Answer

Hi Yuko, 
 Unknown said: Could you tell me where in Studio I can find the segment setting, so I can test and see if I can replace the target as source? 
 You need to download and install both sdlplugin files provided for this app: 
 http://appstore.sdl.com/app/file-type-definition-for-po-extended/566/ 
 Then you'll find the option here after installing: 
 
 To use the settings file I gave you go to the same Filetype Options only this time import the settings file here: 
 
 On your excel tagging, you just need a rule to specifically take out the placeables you show. So maybe something like this: 
 <.+?> 
 Make sure you set it as a placeable and not a tag pair. 
 Regards 
 Paul

Trados Studio > 1. Trados Studio

Embedded Content problem with Excel files