I'd like to process cells this order.
1, 2 , 3, 4, 5, 6...
But, SDL Trados Studio refuses to follow my order.
It insists this order.
1, 4 , 2, 5, 3, 6...
Nagoya Kita, you should define the 'by column' setting before you prepare your Excel file.Also important: the SpreadsheetML v.1 file type ID on your screenshot means that Studio applied the Excel 2016 filter to your Excel 2013 file. You have to move up the Excel 2013 filter (where this setting is available) above the Excel 2016 filter (where this setting is not available at all) and uncheck the latter. In your case the file type must read "Excel 2007 v. 184.108.40.206", but I can see it is "SpreadsheetML v.1" This will work.
Another question to SDL:It seems SDL chose to remove this superfluous feature for newer versions.Is it no longer available for Excel 2016?
At the same time, if you try to select Excel 2013 filter for Excel 2016 files, Studio just will drop an error when saving target:
How do I select the processing sequence for Excel 2016?
sorry, NO It does not work It makes the same result I have set At both "Project setting" and "Options" beforehand like you said. Looks something is wrong.
It is not about SDL Trados Studio 2019. I use 2017 at the moment.I've edited my reply. This explains why it does not work for you.
what do you mean "It" ? I am with version 2017
"...Your Studio uses a filter that does not support what you want to get."
Oh Very Nice Comment I... just pretend to not read this comment at all. Thanks lot.
In your case it must be Excel 2007....
I need replys who know what exactly OR SDL's responsible peoples reply
Not this kind..
Hi Kelly ( Former Member ),
I thought the easiest way to show you what Stepan has already tried to explain was with a video... hope this helps:
I have found it.
I wasted my precious time because SDL Trados Studio's Double Dumb Excel menu structure.
Why it has two fold menus ? Needless and Confusing.
The one I tried earlier;
The other one I just found;
I will tell you for sure that when MS release another one, SDL Trados Studio should have the 3rd Excel options (or SDL Trados Studio version 2020 something)
SDL should clear it out.
Double Menus...... Double nice.