Support Board
Date/Time: Thu, 28 Nov 2024 00:40:35 +0000
New Spreasheets
View Count: 954
| [2014-10-28 19:23:27] |
| User14209 - Posts: 6 |
|
I am having difficulties moving from old spreadsheets to new spreadsheets. In the new spreadsheets, on sheet1 there is a reference to sheet5 in one cell. When Sierra is running the formula works. When I close Sierra and open it again, in sheet1 I loose the reference in the formula for sheet5. What I am doing wrong ? PS In one cell of sheet1 the formula reads :=if(row($a3)=3,sheet5!$c$3-Sheet5!$d$3,0) When I close and open Sierra Ithe cell reads : =if(row($a3)=3,#ref!!$c$3-#ref!!$d$3,0) |
| [2014-10-28 21:23:07] |
| |
|
We tested this and could not duplicate this. We need to get your Spreadsheet file. It has a scss File extension. Attach it here following these instructions: https://www.sierrachart.com/index.php?page=PostingInformation.php#AttachFile It can be privately attached. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2014-10-28 21:55:45] |
| User14209 - Posts: 6 |
|
OK here goes. In Sheet1 formula is : =if(row($a3)=3;Sheet5!$c$3-Sheet5$d$3,0) Result is 12.25 When I close ATCharts completely and reopen ATCharts with the chartbook, result is #REF! If you only close the chartbook and reopen it, result is 12.25, but when I completely shutdown ATCharts application and reload the chartbook, result is #REF |
 For Sierra.scss - Attached On 2014-10-28 21:55:11 UTC - Size: 88.51 KB - 399 views For Sierra.cht - Attached On 2014-10-28 21:55:19 UTC - Size: 59.37 KB - 447 views |
| [2014-10-29 03:53:55] |
| |
|
This will be corrected in the next release.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: