Support Board
Date/Time: Fri, 31 Oct 2025 12:36:33 +0000
Post From: SPREADSHEETS - 'Number of Rows' question
| [2015-08-14 15:06:56] |
| bekitz3 - Posts: 83 |
|
Looking at the documentation at the following link under the section Number of Rows: http://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html The line item Decreasing Number of Rows Input: states the following: If you decrease the value of the Number of Rows input, then the data that was previously outputted to a Sheet on a Spreadsheet for those rows will still remain.
Maybe I'm doing something wrong, but I haven't been able to produce this functionality. If I start with a 1000 rows then change to 2000 rows the spreadsheet populates accordingly. If I switch back to 1000, the spreadsheet adjusts back to 1000 rows.....but shouldn't the spreadsheet stay populated with 2000 rows??I understand why this functionality would be useful because you can populate your chart with historical plots far back in time by increasing the row setting, then switch to a lower value to reduce CPU burden, memory demands, etc when chart recalcs or new bars add to the sheet. Any support would be appreciated. |