Support Board
Date/Time: Tue, 04 Mar 2025 15:04:03 +0000
Spreadsheet programming question
View Count: 587
| [2021-12-17 21:23:21] |
| User183724 - Posts: 191 |
|
seeing something ive never seen before... i have a spread sheet study attached to a 5 min chart ive been using this sheet for some time now and havent changed any settings since i attached it i attempted to enter a formula in a column at row 3. it accepts the formula as usual however, it doesnt populate the colunm below row 3 when I select 'RECALUATE ALL FORMULAS', the formula i added to row 3 is cleared. I attempted to attach a picture...dont know if it sent. any assistance appreciated |
 Screenshot (6).png / V - Attached On 2021-12-17 21:21:58 UTC - Size: 35.8 KB - 157 views Attachment Deleted. |
| [2021-12-17 21:43:04] |
| Sawtooth - Posts: 4179 |
|
it accepts the formula as usual however, it doesn't populate the column below row 3
Either:- Sheet3 isn't the Formula Source Sheet Number for the spreadsheet study on Chart3. or - There is no spreadsheet study on Chart3, and this Sheet3 is a leftover after the study was removed. |
| [2021-12-17 22:25:59] |
| User183724 - Posts: 191 |
|
that doesnt appear to be my issue... I have other charts attached to the same spread sheet and they appear to work correctly...
|
| [2021-12-17 22:54:26] |
| John - SC Support - Posts: 38341 |
|
The first issue is that the column you are entering data into is not a "Formula Column", therefore it does not populate down like the columns K-Z (by default) will do. There is an Input for Number of Formula Columns. The second issue we can not reproduce. Our formula stays in the cell. If you are putting a formula into a cell in that column for a reason, then try moving to a column further away from the Study Subgraph data columns. See if that will resolve the deleting issue. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2021-12-18 00:00:25] |
| User183724 - Posts: 191 |
|
I have the spread sheet set to 60 columns in the study settings and it was working fine until today
|
| [2021-12-18 00:03:23] |
| User183724 - Posts: 191 |
|
pic
|
| Screenshot (7).png / V - Attached On 2021-12-18 00:03:13 UTC - Size: 234.56 KB - 154 views |
| [2021-12-18 00:05:00] |
| User183724 - Posts: 191 |
|
thanks anyways... deleting and starting over... again
|
To post a message in this thread, you need to log in with your Sierra Chart account: