Is it possible to find out where my spreadsheet aliases are being used via a search?

[bassamanator]

Hi,

My part is mostly completed, and I want to do some cleanup.

I want to delete all the useless aliases that I created in the spreadsheet. I want to find out where a particular alias is being used.

Is it possible to search for aliases in Freecad?

Thanks!

[chrisb]

You can unpack the FreeCAD file and search through the File Document.xml. Unpacking can be done with a common unzip or with the tool available via menu->Tools->Project utility.

[alexu]

Is it possible to search for aliases in Freecad?

Perhaps you could modify Macro TreeToAscii to show this information?
(or petition the macro author to add it)

[Chris_G]

Hi,
You can run this little function to list all the objects of the active document that use the given string in expressions :

Code: Select all

def search_alias_connection(name=""):
    """Search all the objects of current document that contain
    the given string in an expression"""
    doc = App.ActiveDocument
    for o in doc.Objects:
        if hasattr(o, "ExpressionEngine"):
            for exp in o.ExpressionEngine:
                if name in exp[1] or name is None:
                    print("{} used in property {} of object {}".format(exp[1], exp[0], o.Label))

search_alias_connection("Alias_1")

you can then perform new searches by simply repeating the last command with other string :

Code: Select all

search_alias_connection("Alias_2")

[cadcam]

search_alias_connection("Alias_2")

Really useful, thank you. Generating a macro for this

[Should this be part of FC - Spreadsheet -> Select cell -> Alias .. Where used ...?

[bassamanator]

Hi,
You can run this little function to list all the objects of the active document that use the given string in expressions :

This works wonderfully. Thanks!

[chrisb]

Should this be part of FC - Spreadsheet -> Select cell -> Alias .. Where used ...?

+1