Support Board
Date/Time: Sun, 12 Apr 2026 05:05:38 +0000
Problem with Spreadsheet Study (OTHER SHEETS BEHAVE DIFFERENTLY!)
View Count: 20
| [2026-04-11 20:30:37] |
| TopGunTrader - Posts: 292 |
|
Hi, I really enjoy using Spreadsheet study I create statistics and have been posting them into spreadsheet to then display for example 1m statistical highs/lows, 5m, 15, 30 etc. When I paste DATA into say Row K3 it pastes all the other columns and well AND this is key that same data is below in next row and next and next all the way down! But when I paste data into another sheet which I plan to use in my main sheet to display on chart it DOES NOT COPY THAT DATA TO ALL ROWS BELOW! I just assumed all sheets would behave like ORIGINAL one. I feel I wasted entire Saturday recreating my stat spreadsheet as I assumed and WANT my data to be on multiple rows. You can see the problem on ScreenB pic I take the OPEN data in this spreadsheet and subtract the daily stat value in DATA sheet and its correct but FOR ONLY ONE ROW since that data isn't on the row down in DATA the next value is WRONG as its subtracting 0 there's nothing in the DATA sheet one row down. HOW CAN I PASTE DATA IN another sheet and have THE SAME BEHAVIOR as the main sheet ie when pasting in values it duplicates those values in EVERY ROW BELOW! Please let me know how to fix this I need to paste in stat data into another sheet and use that for main sheet to calculate and display levels on my chart but its broken now. All sheets should behave the same way. |
 ScreenA.png / V - Attached On 2026-04-11 20:26:20 UTC - Size: 24.8 KB - 2 views ScreenB.png / V - Attached On 2026-04-11 20:27:27 UTC - Size: 56.39 KB - 2 views |
| [2026-04-11 20:34:40] |
| TopGunTrader - Posts: 292 |
|
To recap the behavior on main sheet and OTHER sheets is different. In main sheet I take a row of values from excel copy and paste and it DUPLICATES this row into all of them 50 rows down has same values. On other sheets when I do this it ONLY PASTES ROW DATA INTO ONE ROW. I want to paste the data into EVERY ROW same exact behavior as main sheet! |
| [2026-04-11 20:56:52] |
| TopGunTrader - Posts: 292 |
|
It occurred to me I can create a macro to paste the data into say 100 rows but I don't think I should have to other sheets should have same behavior.
|
| [2026-04-11 21:28:37] |
| Sierra_Chart Engineering - Posts: 23486 |
|
Refer to: Working with Spreadsheets: Filling Cells with Value or Formula 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, use 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: