Hello,
In Studio 2021, I am trying to use the Excel Content processing option to include only cells with the selected font color, but it does not work. It is still processing all cells in the file. If I choose the option to exclude cells with that font color it works fine, but if I want to include only those cells it doesn´t work. Am I missing something? Attached is a video to show the problem. Thanks.
Can you tell us exactly which version of 2021 you are using, and even better provide a small sample of the file you have that also fails for you? I ran a quick simple test and get this without any problems, so we will need to know a little more about your specific circumstances to solve this:
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
Sure. I use SDL Trados Studio 2021 SR1 - 16.1.4.4184 Professional. Here is a sample of the file, Thank you in advance.
This file doesn't contain any coloured text. Only coloured cells and the feature works on text. In your video your file did have coloured text.
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
Sorry. Wrong file. Here it is. Thanks. Excel with red font color.xlsx
Thanks Beatriz de Vega
I'm afraid I still cannot reproduce your problem:
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
Thank you Paul for trying and for your video. I had done exactly the same as you, first using a standard color, then a custom color making sure that the values were correct. I´ve tried with this file and also with another one created from scratch. I´m just puzzled. Obviously Studio recognizes de colors: if I use a red font (or any other colored font) for parts I need to extract for translation, then Studio does the following: Skip cells with the color works, but Only include cells does not work. So I thought, I´ll do it the other way around to get to the same result: I´ll tell Studio to Skip cells with the automatic black color (that I added as custom). In this case, the Skip cells with color does not work, while the Only include cells with that color works. So I can´t use that function.
I decided to try the same file in my own personal Freelance copy of Studio 2021, latest RWS version. Everything worked fine as it should and as you show in your video.
I´ll ask a couple of colleagues to try these same scenarios to see if they have the same problem. I just can´t understand what could cause such a bizarre behaviour. Thanks anyway.
Translate
