Support Board
Date/Time: Tue, 28 Oct 2025 17:00:13 +0000
Spreadsheet question
View Count: 1679
| [2013-09-10 00:29:21] |
| enemyspy - Posts: 306 |
|
Hi I am having an issue where I enter a formula into column p in my spreadsheet and it autocopies it down 10 rows. Being fairly new to spreadsheets I have no idea what I have pressed or done to create this super annoying problem, and have been trying to figure it out for like 2 hours...Does anyone know what I did and or how I can fix it?...Any spreadsheet I use it does this.
|
| [2013-09-10 00:52:34] |
| Sawtooth - Posts: 4280 |
|
All user formula columns K-Z...BR of spreadsheet studies do this by design. There is nothing to fix. In fact, if you Recalculate the spreadsheet, all rows will auto-populate. Like in columns A-G, and columns AA...BT and higher, all rows correspond individually to chart bars. If you need a standalone spreadsheet, go to File >> New Spreadsheet. |
| [2013-09-10 01:08:16] |
| enemyspy - Posts: 306 |
|
Wow I did a lot of stuff without even realizing this...I guess I had never tried to program a single celled formula in a non stanalone sheet before. Thank you for answering yet another stupid question:)
|
| [2013-09-10 01:46:56] |
| Sawtooth - Posts: 4280 |
|
Column H of the spreadsheet study's spreadsheet does not auto-populate and is available for static calculations/values.
|
To post a message in this thread, you need to log in with your Sierra Chart account: