The Origin Forum

File Exchange

Try Origin for Free

The Origin Forum

All Forums

Origin Forum for Programming

LabTalk Forum

table update broken after LT-script

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:

UserName:

Password:

Anti-Spam Code:

Format Mode:

Format:

Message:

* HTML is OFF
* Forum Code is ON

Smilies

[quote][i]Originally posted by Karsten8[/i]
[br]Origin Ver. and Service Release: 2022b 9.9.5.171
Operating System: Windows Server 2012

Dear Origin-team,

within a graph I use a table to show a number located inside a
workbook. If I write a number inside this workbook the table
updates and shows the number. But if I start my LT-script that
writes a new value inside the cell the update function is broken.
The table shows only "--". If I manually go into the cell delete 
and insert the same formula - press enter - then the update is
back again (without change of the formula).

In an earlier version I used the same table and formulas and after
the script the update of the table works fine. Now the table needs
an manual trigger to work again.

-The cell is formated for text and numbers - whereas I only write 
number inside. 
- using wks_update_link_table iw:=[Table23] does not help after running the LT script

Below is a screenshot of my formula and graph/table.

How can I activate the atomatic update function again?

Thanks for your help.

Best regards,
Karsten8.

[img]https://my.originlab.com/ftp/forum_and_kbase/Images/tableproblem2.png[/img]
[/quote]

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Karsten8	Posted - 03/10/2023 : 02:36:59 AM Origin Ver. and Service Release: 2022b 9.9.5.171 Operating System: Windows Server 2012 Dear Origin-team, within a graph I use a table to show a number located inside a workbook. If I write a number inside this workbook the table updates and shows the number. But if I start my LT-script that writes a new value inside the cell the update function is broken. The table shows only "--". If I manually go into the cell delete and insert the same formula - press enter - then the update is back again (without change of the formula). In an earlier version I used the same table and formulas and after the script the update of the table works fine. Now the table needs an manual trigger to work again. -The cell is formated for text and numbers - whereas I only write number inside. - using wks_update_link_table iw:=[Table23] does not help after running the LT script Below is a screenshot of my formula and graph/table. How can I activate the atomatic update function again? Thanks for your help. Best regards, Karsten8.
2 L A T E S T R E P L I E S (Newest First)
Karsten8	Posted - 03/14/2023 : 02:11:13 AM Dear James, thanks for your answer. Using the following procedure gives the desired result: - open table: win -a Table23; - fill/update cell: col(A)[1]$= "cell://[Book1]Sheet1!A[1]"; - close table: win -ca Table23; Best regards, Karsten8. quote: Originally posted by YimingChen How did you set the cell value? It worked for me with the script: col(A)[1]$= "cell://[Book1]Sheet1!A[1]"; James
YimingChen	Posted - 03/10/2023 : 09:19:08 AM How did you set the cell value? It worked for me with the script: col(A)[1]$= "cell://[Book1]Sheet1!A[1]"; James

The Origin Forum

Snitz Forums 2000