Text expression evaluated as numeric

[toml]

Lookout V5.1 build 53. I create an expression objet to log with the spreadsheet object. The expression is: process_name\recepe_name.recipe_member.txt. When this expression is logged or insterted as a display on a control panel it shows up as 0. If I display process_name\recepe_name.recipe_member.txt directly on a panel without the expression object it shows correctly. Any suggestions?

[jpss]

Toml:

Right-click over the expression and drag it to panel.
A menu will be displayed. Choose "Insert expression as TEXT"

Hope it helps.

JSS

[toml]

Thanks JSS, I didn't know about that. However my spreadsheet object still writes a 0 instead of text. Any ideas on this?

[jpss]

Toml,

I could help you if you send your process...or a sample of what you're trying to do...

JSS

[toml]

OK JSS, here goes. I didn't want to send you my processes because they are quite large. When trying to build an example, I noticed I could not duplicate the problem in a single process the sheet had to write from a recipe in another process. I have attached 3 files: Process1 has 2 objects a panel and a recipe. Process2 has 3 objects: a panel, a push button, and a spreadsheet that is written when the push button is pushed. The attached spread sheet is to load into the recipe object.

The spreadsheet object has 2 fields, one is a text value in the recipe that writes as a 0 as described in my initial post. The second field is the same text value from the recipe that I've force to write as text by using the tif function: tif
(true,text field,"dummy")

I hope this is clear, let me know if you have any questions. Thanks for looking at this. Tom

[jpss]

Toml,

I could not open the processes, Could you send the .lks files, please?

JSS

[toml]

Here are the lks files.

[jpss]

Tom,

After a couple of tests, my conclusion is to force the format. Whether by TIF or by using an expression like: Recipe1.Parameter1.txt&" ". |:(

JSS

[toml]

JSS, thanks for looking at this. Tom