Cannot reference to expressions in external spreadsheet

[schloeri]

Good afternoon,

I have designed a body stored in a FreeCAD file. I also do have a different FreeCAD file (master.FCStd) in the same directory just containing a spreadsheet. This spreadsheet does hold all relevant distances. All cells carry an alias name.

Now, these aliases are not accessible from the body file. I do know how to address those expressions as I have already done that in the past (master#name_of_spreadsheet.expression).

Here comes the difference: The file with the body originally contained several bodies together with all their sketches and modeling tools. For reorganizing the project I put every body in its individual file by copying the multi part file and deleting all but one body in each file. At the same time I renamed all entries in the model tree to be "Sketch", "Pad", "Pocket" etc rather than "Sketch001", "Pad001", etc.
Now when I try to insert the external expression (no matter which from the spreadsheet) the formula editor says "Document object not found: Sketch002". There is no Sketch002 for the body, however, there was a Sketch002 in the multi body file.

Any idea of how to get rid of that for the files and if this should be considered a bug?

Best regards

Stefan

[chrisb]

Can you upload the files (Master plus one of the others? And note, that renaming is rather relabeling. You can never change the internal name, only the displayed label.

[schloeri]

Thanks for the feedback.

I realized the internal names in the status line when hovering over the items but even changing the labels back does not repair the file.

Attached two files

[chrisb]

The problem is the name of the spreadsheet. The dash is inside of an expression interpreted as a minus sign. Rename the spreadsheet e.g. to daten_wc_schrank and you can reference things such as master#daten_wc_schrank.hoehe_schrank in the file seitenwand_lang.FCStd.

[schloeri]

Hey chrisb,

thanks for looking into that. That did the trick.

Best regards

[Arturok]

you are the masters, problem solved thanks

[Aleks]

I will also add, that it does not work with capital letters in the filename.

[M4x]

I recommend using links to make your documents easier to maintain. Here is an example of how that could look like:

Here is my example (place files in the same folder). Spreadsheet in the top level assembly file drives components in a separate file.

https://forum.freecadweb.org/viewtopic. ... 60#p540257