Support Board

Date/Time: Wed, 01 May 2024 22:17:58 +0000

Post From: SPREADSHEETS - 'Number of Rows' question

[2015-08-14 15:06:56] Link To Thread - Link To Post [Go To First Post]
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.