Edit a String in spreadsheet environment

[hadera]

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??

 

[JohnRBaker]

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.

 

[hadera]

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

 

[MickyV007]

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

 

[hadera]

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

 

[hadera]

Any other ideas???

 

[hadera]

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

 

[JohnRBaker]

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.