• Replies 11 replies
  • Subscribers 76 subscribers
  • Views 7263 views
  • Users 0 members are here
Options
Related

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
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply
  • in reply to Former Member

    I had a little play with it and can't get it to work.  Or rather, when I thought it wasn't working and started doing something else an excel spreadsheet suddenly popped up but it didn't contain what I expected.

    I think the problem is the test files I used were too large and complex and the approach generates a lot of data.  Take a look if you're interested?

    Excel Shading (AHK).zip

    I do like the idea though... might take a look at this and see whether we can use the approach another way.

    Paul Filkin | RWS

    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

Children