×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Draft File Property....link to Spreadsheet Cell? Possible?

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

RE: Draft File Property....link to Spreadsheet Cell? Possible?

(OP)
ST3 if it matters.

RE: Draft File Property....link to Spreadsheet Cell? Possible?

No, I don't think its 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?

(OP)
Beach, thanks for the reply.
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?

You dont need to use a sketch - you can just create the variable in the variable table, but make sure you check the 'expose' box.
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?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources