Draft File Property....link to Spreadsheet Cell? Possible?
Draft File Property....link to Spreadsheet Cell? Possible?
(OP)
Hello all,
I have a quick question.
Is it possible to link a spreadsheet cell to a propert within a draft file?
For example, I want the "Title" field link to a cell in a spredsheet that has a part number in it.
This would cause any callout referencing what is in the title field to show the part number.
I use callouts on my background draft sheet that reference title, subject, and category.
The generate a part number, tool number, and a description.
Thanks in advance,
Av8errr
I have a quick question.
Is it possible to link a spreadsheet cell to a propert within a draft file?
For example, I want the "Title" field link to a cell in a spredsheet that has a part number in it.
This would cause any callout referencing what is in the title field to show the part number.
I use callouts on my background draft sheet that reference title, subject, and category.
The generate a part number, tool number, and a description.
Thanks in advance,
Av8errr





RE: Draft File Property....link to Spreadsheet Cell? Possible?
RE: Draft File Property....link to Spreadsheet Cell? Possible?
You can link a numeric value in a spreadsheet cell to a variable in the model or draft file, and have that display in a callout, but not text strings. I suppose if the part number is entirely numeric, then it would work.
Put the part number in a property of the model or the draft.
I wouldn't use the 'Title' property either, I would use Document Number or create a custom property called PartNumber.
bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.
Where would we be without sat-nav?
RE: Draft File Property....link to Spreadsheet Cell? Possible?
The part number is entirely numeric.
In the background of my draft, resides my title block.
I have callouts referencing title, subject, and category fields from the draft file.
I can do a paste link to the draft "title" property from a part variable link.
This requires me to insert a variable within the part file, and to assign it a value equal to the part number.
For this I meerly used a sketch, and assigned a line a lenth equal to my part number.
However, this generates a part number with two decimal places after it, and it also adds the units of measure at the end.
I have tried to modify the dimension within the part file by way of styles, but to no avail.
Maybe this is not possible?
Thanks for your insight...
Av8errr
-av8errrST3
xw46003GB
RAM2Quad CPU
3.00GHz
RE: Draft File Property....link to Spreadsheet Cell? Possible?
Decimal places display is driven by the draft file settings but you can over-ride them in your property text - add /@0 after the variable name for no decimal places.
You should have something like %{V1234/@0}
You should be able to add another qualifier /@NU to get rid of the units, but I can't get that to work.
You would end up with %{V1234/@0/@NU}
Normally I would just turn them off in the draft file, but that might affect other things for you.
By the way, these work for any property text, so if you have a mass property text that comes from the first draft view you might use
%{Mass/@0/@NU|R1}
Hope this helps, but I still don't think its the right thing to do.
bc.
2.4GHz Core2 Quad, 4GB RAM,
Quadro FX4600.
Where would we be without sat-nav?