problem with data validation drop down list with spreadsheets

[aluminum2]

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.

 

[JohnRBaker]

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.

 

[aluminum2]

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.