To make a good use of CADF [Excel Cell Shading Rekon II]

Former Member
Former Member

it gives you a very nice collection of Segment Numbers
you can use them at CommunityAdvancedDisplayFilter

sample MS Excel file, two sheets and Shadings

Two MS Excel sheets side by side showing segment numbers with different shadings indicating status.

Trados Studio project view with Advanced Display Filter panel open, showing filtered segment numbers.

this code's Result

MS Excel sheet with segment numbers and corresponding shadings listed in columns.

and you use them (copy and paste) at CADF, harmless harmless and haaaarmless..

Comparison of Trados Studio project views with and without errors, highlighting the error message in the Advanced Display Filter panel.

Concerns

There should be some UpperLimits -not tested with several thousands items
- Excel Cell's,
- CommunityAdvancedDisplayFilter's,
- code's internal container ("Dictionary")
- sorry I do not know them clearly. I have completed my simple test "Perfectly".

it makes a text file at ".sdlproj" folder
name under ".sdlproj_extractShadingSegNumbers.txt"
just delete it, almost useless. just in Case(s)...

Enjoy


Attached
-AutoHotkey source code

5751.extract_sdlxliff_CADF_AdvancedUsage_Updated.zip



Generated Image Alt-Text
[edited by: Trados AI at 4:17 AM (GMT 0) on 5 Mar 2024]
emoji
Parents Reply Children