[Spreadsheet] Links to Parts or Hyperlinks to a File#Part in the Spreadsheet

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help

Also, be nice to others! Read the FreeCAD code of conduct!
Post Reply
leoheck
Veteran
Posts: 1223
Joined: Tue Mar 13, 2018 5:56 pm
Location: Coffee shop

[Spreadsheet] Links to Parts or Hyperlinks to a File#Part in the Spreadsheet

Post by leoheck »

Is it possible to have links to open Parts (within the current document or also from external documents) from the Spreadsheet?

For instance, I have a bill of material generated automatically. There is one item that I don't remember what it is, I would like to improve this behavior of my BOM by having links where I can click them to open that file in Freecad.

Is it possible?
Last edited by leoheck on Mon Oct 03, 2022 7:19 pm, edited 1 time in total.
leoheck
Veteran
Posts: 1223
Joined: Tue Mar 13, 2018 5:56 pm
Location: Coffee shop

Re: Links to Parts in the Spreadsheet

Post by leoheck »

Does someone know if Spreadsheet support links to other FCStd files?
chrisb
Veteran
Posts: 53929
Joined: Tue Mar 17, 2015 9:14 am

Re: Links to Parts in the Spreadsheet

Post by chrisb »

leoheck wrote: Sat Oct 01, 2022 6:46 pm Does someone know if Spreadsheet support links to other FCStd files?
See in Expressions the section about cross document links.
A Sketcher Lecture with in-depth information is available in English, auf Deutsch, en français, en español.
leoheck
Veteran
Posts: 1223
Joined: Tue Mar 13, 2018 5:56 pm
Location: Coffee shop

Re: Links to Parts in the Spreadsheet

Post by leoheck »

Thanks Chrisb. I am thinking that this can help building a better bill of materials.
leoheck
Veteran
Posts: 1223
Joined: Tue Mar 13, 2018 5:56 pm
Location: Coffee shop

Re: Links to Parts in the Spreadsheet

Post by leoheck »

The wiki does not explicitly say I can have a cell with something like a hyperlink to a file or a part in another file.
PAS_Drafter
Posts: 338
Joined: Mon Aug 02, 2021 6:29 am
Location: California, USA

Re: Links to Parts in the Spreadsheet

Post by PAS_Drafter »

You can take a look at the files in this post.



https://forum.freecadweb.org/viewtopic.php?f=3&t=72186



I create a Master spreadsheet and link to it from various parts all the time. You can link from the part directly or link it to another spreadsheet. The only thing to be careful of is that you can't link to a spreadsheet and then link from that spreadsheet back to the original spreadsheet with a result or FreeCAD has an issue with it. The links need to be one way.

To link them, just have the file with the spreadsheet open in your tree, and in the expression builder, you can just start typing the part name, then the spreadsheet name, and then the cell or alias.
User avatar
Roy_043
Veteran
Posts: 8450
Joined: Thu Dec 27, 2018 12:28 pm

Re: Links to Parts in the Spreadsheet

Post by Roy_043 »

leoheck wrote: Mon Oct 03, 2022 1:29 am something like a hyperlink to a file or a part in another file
AFAIK this is not possible in FreeCAD spreadsheets.
leoheck
Veteran
Posts: 1223
Joined: Tue Mar 13, 2018 5:56 pm
Location: Coffee shop

Re: Links to Parts in the Spreadsheet

Post by leoheck »

Roy_043 wrote: Mon Oct 03, 2022 8:01 am
I am also thinking this is not possible, yet.
PAS_Drafter wrote: Mon Oct 03, 2022 3:07 am
Thanks, I am going to check the thread you are pointing me to check.

In summary, what I am to do is to have a link in the cell, that targets an Object in the current file, or in another file.

For instance:

I would like to have a Cell that says PartName with a Hyperlink the "@FileName#Partname", and then when I click on this link. If the file is the current file, it shows/highlights the Part, if it is ins another file, it opens the file (if not opened) and then shows/highlights the Part there.
PAS_Drafter
Posts: 338
Joined: Mon Aug 02, 2021 6:29 am
Location: California, USA

Re: [Spreadsheet] Links to Parts or Hyperlinks to a File#Part in the Spreadsheet

Post by PAS_Drafter »

I know you can link to another spreadsheet, but I am not aware of a way to add a hyperlink to add a selection from.

I do however see the value to that as I agree being able to create a BOM with prices would be very useful.
Post Reply