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
  • Former Member
    Former Member

    for Mr. Filkin's 2nd MS Excel sample file "shading_simplecolumns.xlsx"

    It is quite simple but a little bit alien one (to me)

    It is a Table (funny, Excel itself is a table, I guess)

    whatever it is, it made an Alert message at the last stage, fortunately that is not a severe/fatal error so one can have a final file though.

    It says the error is related with Table. so... what ? I DunNo...

    In this case my recommendation is quite "Clear and Simple".

    Do not use this workaround. Stop at it. I have prepared a BAK for this kind of instance.

    OK ?

    Good Luck To You

    (ah, Mr. Filkin's first MS Excel sample file did not make any kind of wrong beep. I love it....)

Reply
  • Former Member
    Former Member

    for Mr. Filkin's 2nd MS Excel sample file "shading_simplecolumns.xlsx"

    It is quite simple but a little bit alien one (to me)

    It is a Table (funny, Excel itself is a table, I guess)

    whatever it is, it made an Alert message at the last stage, fortunately that is not a severe/fatal error so one can have a final file though.

    It says the error is related with Table. so... what ? I DunNo...

    In this case my recommendation is quite "Clear and Simple".

    Do not use this workaround. Stop at it. I have prepared a BAK for this kind of instance.

    OK ?

    Good Luck To You

    (ah, Mr. Filkin's first MS Excel sample file did not make any kind of wrong beep. I love it....)

Children
  • It is a Table (funny, Excel itself is a table, I guess)

    Well, Table is actually relatively new thing in Excel (since Office 2003? or 2000? not sure...) and it's completely different beast than the standard Range. Not only it offers much better functionality, user experience and data access, but from programming perspective requires a completely different approach - it uses its own extra "API" since Table is a completely different object than Range - to manipulate its data.

    So it's not unusual that macros/programs too simple to take in account Table objects fail to work or show various errors.