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??
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
="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
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
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
RE: Edit a String in spreadsheet environment
RE: Edit a String in spreadsheet environment
can you help me with my problem? Still have no solution for my problem.
RE: Edit a String in spreadsheet environment
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.