Reply

Variables in spreadsheet --> relative path?

Hello,

is it possible to use a relative path when linking variables in a spreadsheet?

Thank you!

Best regards
Robert Goldbach
3 REPLIES

Re: Variables in spreadsheet --> relative path?

Can you provide an example of what you are trying to achieve?
Regards,
Rick B.

Re: Variables in spreadsheet --> relative path?

[ Edited ]
Sorry, the problem has been solved.

I tried it and got the unexpected (by me) result, that the pathes (marked bold in the quote below) are shown as absolute but handled as relative pathes. Means, if i copy the files to another location and open the drawing, the path in the variable table has been updated

(from help file --> variable table, linking variables to spreadsheets)
11. Repeat the previous steps as needed for the other values. The resulting Variable Table should update as follows:



Type | Name | Value | Formula
------------------------------------------------------------------------
Dim | V314 | 35.00 mm | @C:\folder\book1.xls!Sheet!R1C2
Dim | V315 | 65.00 mm | @C:\folder\book1.xls!Sheet!R2C2


Re: Variables in spreadsheet --> relative path?

Did it continue to work when copying the files to a new location?