Support Board

Date/Time: Mon, 29 Apr 2024 13:36:30 +0000

Post From: New SpreadSheets Subgraph Referencing user defined values on other sheet.

[2017-02-26 07:16:47] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
Hi, There seems to be a Problem with the spreadsheet subgraphs updating values sourced from cells on a seperate sheet that are manually inputted/ changed via typing Value into the referenced cell: Using 2 spreadsheets - Sheet1 with subgraph outputs, the other is a blank sheet were user defined values are entered. It is Meant To be a Parameter array for an ACSIL study like sc.Input. The subgraph sheet has an addressing formula To Order The user defined values on the blank sheet correctly: =Indirect(Address(P3+8R3+R3,Q3,1,1,"SigExitParams")) - In the photo(if it is needed) I included an additional column with indirect() removed so you can see that the cell references are correct and ordered Properly. When I Change A user Defined Value on the blank Sheet "SigExitParams", and Recalculate the Chart - It is not always updating the Spread Sheet Subgraph with the new values. Date Time Of Last Edit: 2017-02-26 07:41:35*


Spread Sheet Views.PNG / V - Attached On 2017-02-26 07:15:25 UTC - Size: 88.55 KB - 248 views