Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 22:22:21 +0000



Recalculate spreadsheet

View Count: 939

[2014-08-11 11:14:08]
Outlander - Posts: 91
If I click ok in a cell the spreadsheet (NON-CLR) recalculates all formulas in the sheet. Is it possible to do that by auto on bar close or after a certain time? It would be a great help if possible.

Regards Outlander
[2014-08-11 11:17:24]
Sierra Chart Engineering - Posts: 104368
Tell us what cell you modified.
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-08-11 11:51:34]
Outlander - Posts: 91
Cell 3, I do not need to modify the formula in the cell only click ok and the whole sheet recalculate. It works on all formula columns cell 3.
Regards Outlander
[2014-08-12 00:38:05]
Sierra Chart Engineering - Posts: 104368
We are checking on this.
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-08-12 10:22:30]
Outlander - Posts: 91
Would this work sc.FlagFullRecalculate to recalculate the columns in the spreadshet?

Is it indicator?

Regards Outlander

[2014-08-12 10:53:17]
Sierra Chart Engineering - Posts: 104368
This is not an indicator and is not related to Spreadsheets.
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
[2017-01-21 18:55:39]
opci - Posts: 90
if you can save this thread.ne were dead ends SCSS formula cell K3 and m3 is always lost when restart sierra.how to solve,, thanks.
I tried file save as SCSS but sfter restart sierra formula disappear,, always
[2017-01-21 19:04:42]
opci - Posts: 90
File attached

all I tried
Date Time Of Last Edit: 2017-01-21 19:06:27
imageSCSS @@@.png / V - Attached On 2017-01-21 19:04:28 UTC - Size: 80.2 KB - 249 views
[2017-01-22 08:52:17]
Sierra Chart Engineering - Posts: 104368
The problem may be because of the Formula Source Sheet Number setting is not set correctly. This is documented here:
Spreadsheet Study Inputs: Formula Source Sheet Number
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
[2017-01-23 17:48:16]
opci - Posts: 90
sheet is ok ... or whether it is normal for me at all CHT appears scss..ali doing everything ok normal ... so be a nightmare?
[2017-01-23 18:20:02]
Sierra Chart Engineering - Posts: 104368
We do not understand this:
or whether it is normal for me at all CHT appears scss..ali doing everything ok normal ..

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
[2017-01-23 19:01:32]
opci - Posts: 90
all have made sheet and save SCSS not save time or all but only save SCSS?

when to do it appears to me SCSS on each Chartbook
[2017-01-23 21:16:11]
Sierra Chart Engineering - Posts: 104368
We are not understanding this.
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:

Login

Login Page - Create Account