Vito Smolej wrote:
....And Column B has a character limit of 70 characters. My question is: When opening the Excel file in Tag Editor, does it automatically “apply” the character limit to the target segment or do I have to do it manually?...
Interactively, no way.
... , you will eventually have to check it all once more time, when things are finished. And this is pretty easy in Excel, anyhow much easier than watching the character counts each tim you are about to end a segment in TE. You just need additional column with a formula If(Len(B1)>70;"XXX";"") propagated through all the lines.
For this purpose you can use directly the QA checker in Tag Editor.
Tools > Plug-ins
Select SDL Trados QA Checker or SDL Trados QA Checker 2.0
Segment verification > Check for segments exceeeding the following character count
The same trick can be used for
i) terminating periods
ii) Uppercase starts of strings
The same, Ponctuation tab.
If you want to control the text length as you type, try Swordfish.
Tasks > Set Target Text Length Limits
It doesn't work in the way you expect (i.e. the text limits are relative not absolute)but:
1) it shows the number of chars (just like TagEditor, in the status line botton, on the right).
2) warns if the string length exceeds the source length (displayed in red)
Swordfish open TTX files, you can try it 30 days.