×
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

problem with data validation drop down list with spreadsheets

problem with data validation drop down list with spreadsheets

problem with data validation drop down list with spreadsheets

(OP)
I am having a problem using data validation with ug nx 8.03.4 and excel 2010. I have my expressions linked in the spreadsheets. I want to use the data validation feature in excel because I have an expression that can only have 2 values. RADIUS and CHMAFER which chooses if my model will have a radius or chamfer on a specific edge. I can update it fine in excel if I type in the value ="CHAMFER" then the model updates. when I use the data validation validation it doesn't work. I tried formatting the cells to text and general, but no luck.

RE: problem with data validation drop down list with spreadsheets

I would use an Attribte set to either "Chamfer" or "Radius" and then pass that value to the Expression system as a String Expression and control you model as before. Now when you create your Spreadsheet include the Attribute and NOT the string Expression. Give that a try.

John R. Baker, P.E.
Product 'Evangelist'
Product Engineering Software
Siemens PLM Software Inc.
Industry Sector
Cypress, CA
Siemens PLM:
UG/NX Museum:

To an Engineer, the glass is twice as big as it needs to be.

RE: problem with data validation drop down list with spreadsheets

(OP)
finally got around to testing it. Yeah it does work, but only if the attribute isn't in a category. Might be other things I haven't found yet too. For now I am thankful there is a way it can be done.

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