katp
Aerospace
- Nov 16, 2011
- 1
I'm hoping that someone can help me as I am stuck. I am putting together a spreadsheet driven model to allow an non-NX familiar person to generate a model and associated informational drawing. I would like my user to add into some of the spreadsheet cells a text comment referencing where specific data that is driving the model has come from. These references are likely to change over time. I wish to update a 'string' expression with this reference text so that I can automatically display it on a drawing sheet for other end users in a better, more informative form. I can get numbers to work - just not text strings.
I've tried creating a 'string' expression (mystring) in the expression editor and seen that it expects to receive something in the form of mystring="reftext". I can extract this to the spreadsheet as normal into a cell, say cell A1. If I use a formula so A1=reftext2 I get an error. I've tried setting A1=concatenate(char(34),reftext2,char(34)) so I'm giving it quotes but that doesn't work either.
Does anyone know if this is possible and can let me know how to achieve it? Many thanks, Kat.
I've tried creating a 'string' expression (mystring) in the expression editor and seen that it expects to receive something in the form of mystring="reftext". I can extract this to the spreadsheet as normal into a cell, say cell A1. If I use a formula so A1=reftext2 I get an error. I've tried setting A1=concatenate(char(34),reftext2,char(34)) so I'm giving it quotes but that doesn't work either.
Does anyone know if this is possible and can let me know how to achieve it? Many thanks, Kat.