To make Advanced DSI [Excel Cell Shading Rekon]

Former Member
Former Member

[2nd Edit starts]
I have mad a workaround. It makes all the changes which made by this codes to its orignal status, as if nothings have happened.
So, all the workaround procedures made perfect, I guess. Enjoy !!
[2nd Edit ends]

[1st Edit starts]
It has a better one, a kind of updated
https://community.sdl.com/product-groups/translationproductivity/f/autohotkey/27314/to-make-a-good-use-of-cadf-excel-cell-shading-rekon-ii
[1st Edit ends]

It stems from this post.


Excluding cells in Excel based on fill colour
community.sdl.com/.../excluding-cells-in-excel-based-on-fill-colour

SDL Trados Studio blinds to MS Excel cell shading and cell numbers.

I have tested this tiny code and make it a little bit better.

tested only with very simple project. - One MS Excel file project.
that is all I have and all I wanted


1.
MS Excel has cell shadings, it has two WorkSheets.

2.
Of course, SDL Trados Studio's default DSI is Dummy. (no cell numbers, no shadings at all)

3.
You just ClickOnce this code.

-of couse, firstly close the document (do not have to quit SDL Trados Studio itself)
-it makes a "BAK" file, just in case (located at the same folder - target folder)

4.
Now, You are seeing "Advanced DSI", full of colors and full of information.
-Dear SDL please delete that useless " + " signs.


As You can see, You can use "Advanced Community Display Filter" perfectly.

Enjoy


Attached
-AutoHotkey source code and a sample MS Excel color file.

advancedDSI.zip

Parents
  • It sounds as though you created something useful... but I can't make it work.  I think you need to provide better instructions as all I get is this:

    Error dialog box in Trados Studio showing 'Error: Call to nonexistent function' with code snippets and an 'OK' button.

    This obviously adds structure to the sdlxliff and I wanted to see what this did to the files in the rest of your workflow.  Where do you run the script from?  I'm guessing it only support full projects as well given you said "target folder"

    Dear SDL please delete that useless " + " signs.

    They are not useless. They are there to indicate to a user that there is more information available than you see in the DSI column.  Don't keep thinking you only ever see this in an Excel file... you don't.  For example:

    Trados Studio Document Structure Information dialog box with a list of items such as 'List Item' and 'Unordered List', and an arrow pointing to the '+' sign indicating more information available.

    If there was no + symbol the user would not know there was anything else to see.

    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

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 4:14 AM (GMT 0) on 5 Mar 2024]
  • Former Member
    Former Member in reply to Paul

    looks like, your AHK version problem..

    Trados Studio screenshot showing the Format function documentation with parameters and format string explanation.

    it is my wild guess..

    emoji


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