My client sent me for Excel files and told me to translate only the cells that he has highlighted yellow. If this were a Word document, I could use a handy tool in TransTools to automatically hide everything highlighted yellow, and then import it. However, TransTools doesn't work on Excel files (I emailed Stanislav to confirm this). Are there any clever tricks or SDL Apps to solve this problem?
Michael
OK, I think I discovered a workaround, which I'm going to try. No idea if it will work though, so if you're reading this and know they won't, please warn me! ;-)
1. Select piece you wish to hide
2. Right-click: Format Cells
3. Switch Category from "General" to "Custom"
4. Type ";;;" over "General"
5. Press OK
This will hide the cells so they are no longer imported into your CAT tool.
Once you've finished translating and exported your final documents, remember to un-hide them by selecting the same cells and changing the Category "Cusom" back to "General".
This will obviously only work well if your cells are easy to identify visually, because if they are not you will have a very hard time un-hiding them all afterwards.
Michael
Unknown said:No idea if it will work though, so if you're reading this and know they won't, please warn me!
Hi Michael,
Not a workaround I've seen before but seems quite clever. Will be interested to know if it works!
Regards
Paul
Paul Filkin | RWS Group
________________________
Design your own training!
You've done the courses and still need to go a little further, or still not clear?
Tell us what you need in our Community Solutions Hub
I can confirm that the ";;;" trick worked perfectly!
I did ask Stanislav (the developer of TransTools ) about it the other day, whether he could include it in TransTools for Excel, and this is what he said:
*****************************
Hi Stanislav,
A client just sent me 4 Excel files with certain parts highlighted yellow. Is there a quick way to hide all parts not highlighted?
I was going to just use memoQ's little trick (see screenshot), via "Import with options", but thought it might be even faster via TransTools.
Regards,
Michael
*****************************
Hi Michael,
I can confirm that the ";;;" trick worked perfectly!
I did ask Stanislav (the developer of TransTools ) about it the other day, whether he could include it in TransTools for Excel, and this is what he said:
*****************************
Hi Stanislav,
A client just sent me 4 Excel files with certain parts highlighted yellow. Is there a quick way to hide all parts not highlighted?
I was going to just use memoQ's little trick (see screenshot), via "Import with options", but thought it might be even faster via TransTools.
Regards,
Michael
*****************************
Hi Michael,
Hmm, good question. I don't have time to check, but as far as I remember, the stuff I was asked not to translate was just a ton of exact reps anyway, so they might very well have been parsed by Studio and I didn't even notice it ;-)
I'll try to check when I have a moment!
Edited to add: I better check, as it might have affected the final word count I used to calculate my total fee for the client ;-)
Translate
