×
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

Edit a String in spreadsheet environment

Edit a String in spreadsheet environment

Edit a String in spreadsheet environment

(OP)
hello,
I am working with the spreadsheet environment to calculate and edit a whole machine. (NX 8)
With the spreadsheet I calculate the needed thread size for various bolt connections in my 3D part. This thread size I need to transfer back to the expression list as a sting (e.g. "M10 x 1.5") where the Threaded Hole Feature is automaticly setting all other needed Parameters (eg. Minor Diamter, Major Diameter, Pitch, ...)

Unfortunately this is not working with Strings (I have absolutely no problems with Numbers and other Dimensions)
Does anyone know how to transfer this text (M10 x 1.5) from spreadsheet to the expression list??

RE: Edit a String in spreadsheet environment

The value of the spreadsheet cell has to read as follows:

="M10 x 1.5"

Note the '=' sign as well as the lowercase 'x' and that the 'string' is enclosed in double-quotes.

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: Edit a String in spreadsheet environment

(OP)
Thank you for your answer.
This is working when I type directly the ="M8 x 1.25" in the Expression Row in the spreadsheet (instead of the automaticly generated =EXPRVAL("p98")
My problem is that i calculate the needed size of the the thread with excel and then need to transfer this calculated value to my parameter list (see attached picture).
Instead of ="M8 x 1.25" I need a link (here cell =D8), but then I get an error when updating NX part...
Can you tell me what I need to type in my cell B8

RE: Edit a String in spreadsheet environment

I think according to John's explanation you need to link it to E8 instead of D8, because of the format.

Best regards,

Michaël.

NX7.5.4.4 + TC Unified 8.3
Win 7 64 bit (Intel(R) Xeon(R) CPU X5650 @2.67GHz)
24.0 GB
NVIDIA Quadro 4000 + NVIDIA Tesla C2050

RE: Edit a String in spreadsheet environment

(OP)
E8 is the funktion of D8. Excel just displays it without the '=' and the double-quotes. Thats why I wrote it additionally in E8 to see what's written actually inside of cell D8

RE: Edit a String in spreadsheet environment

(OP)
Any other ideas???

RE: Edit a String in spreadsheet environment

(OP)
Hello JohnRBaker,
can you help me with my problem? Still have no solution for my problem.

RE: Edit a String in spreadsheet environment

Sorry, but I've provided all the advice I can give on this topic.

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.

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