Login Page - Create Account

Support Board


Date/Time: Sun, 22 Dec 2024 16:06:35 +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.