SDL Trados Studio 2017 and xlsm files Thread poster: Nora Escoms
| Nora Escoms Argentina Local time: 21:57 English to Spanish + ...
Hi all, I'm working on a large Excel file in Studio 2017 where some cells have dropdown lists, but Trados editor doesn't show the text in those lists. Any ideas on what the problem may be and how I can solve it? Also, when I save the translation as target, the buttons (those that open the dropdown lists and others) don't work. I'd appreciate your help, this is rather urgent. Thanks in advance! | | | Beata Baika Romania Local time: 03:57 German to Hungarian + ... | Nora Escoms Argentina Local time: 21:57 English to Spanish + ... TOPIC STARTER Thank you, but | May 15, 2020 |
Thank you, Beata. I tried it, but then I get something like this: =INDIRECTO(BUSCARV(B4;QLookup1;2;FALSO)) (Sorry, my Excel is in Spanish) and I have no idea what to do with that... | | | Jorge Payan Colombia Local time: 19:57 Member (2002) German to Spanish + ... And, what is inside cell B4? | May 16, 2020 |
Nora Escoms wrote: Thank you, Beata. I tried it, but then I get something like this: =INDIRECTO(BUSCARV(B4;QLookup1;2;FALSO)) (Sorry, my Excel is in Spanish) and I have no idea what to do with that... While "INDIRECTO", "BUSCARV" and "FALSO" are Excel functions/operators, and "QLookup1" is a range name (untranslatable), the content of cell B4 is the one to translate. I assume that by now you have unhidden it. In that case, you have to reimport the file for Studio to "see" the newly unhidden content. | |
|
|
Nora Escoms Argentina Local time: 21:57 English to Spanish + ... TOPIC STARTER Thank you, Jorge. | May 17, 2020 |
This document is a survey tool, with several worksheets. There's a list of questions, and people must choose their answers from the drop-down lists. The content of B4 is one of the questions, which are all in column B. Theoretically, I've already translated everything, including the answers (there's a separate worksheet with all the questions and answers). However, the drop-down lists are still in English. I've tried unhiding a couple of columns that are hidden but nothing happens. I've checked ... See more This document is a survey tool, with several worksheets. There's a list of questions, and people must choose their answers from the drop-down lists. The content of B4 is one of the questions, which are all in column B. Theoretically, I've already translated everything, including the answers (there's a separate worksheet with all the questions and answers). However, the drop-down lists are still in English. I've tried unhiding a couple of columns that are hidden but nothing happens. I've checked the original document again and even there the lists don't all open, so I guess there's something wrong in the source to begin with. There are also certain cells that are protected, and I can't unprotect them without a password. So I guess what I'm going to do is just talk to the client about it. Thanks anyway!! ▲ Collapse | | | To report site rules violations or get help, contact a site moderator: You can also contact site staff by submitting a support request » SDL Trados Studio 2017 and xlsm files Wordfast Pro | Translation Memory Software for Any Platform
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
Buy now! » |
| Protemos translation business management system | Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!
The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |