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