Support Board
Date/Time: Sun, 09 Feb 2025 03:05:22 +0000
Backups when the app crashes
View Count: 683
| [2020-07-21 13:06:00] |
| tmrtn - Posts: 4 |
|
Is there a way to recover changes to a spreadsheet when the app crashes? Three times in the last two days I've been doing extensive work on a spreadsheet, then go to replay backtest it and the app locks up (not responding). It's only using 200 rows when this happens and limited studies (previous backtests performed perfectly). My main question is whether it has a temp file of the spreadsheet saved somewhere that I can recover. Is that possible? |
| [2020-07-21 15:20:04] |
| ForgivingComputers.com - Posts: 999 |
|
Every time you save a spreadsheet a backup is also saved. Working with Spreadsheets: Accessing a Backup Spreadsheet File If you change any of the formulas in the spreadsheet you can save it before testing it by selecting the spreadsheet window and doing File>>Save. If Sierra crashes, your changes to the formulas and other cell values (e.g. Col. H) are saved. |
| [2020-07-22 14:25:12] |
| tmrtn - Posts: 4 |
|
Thanks Bradh. Per my original question, I'm wondering if there's a way to recover spreadsheets when one HASN'T yet saved and it crashes. I'm also quote curious as to why it saves a backup when you save, instead of saving a backup before you save which is how Office software and most business applications work these days to address the very problem I'm identifying. I wonder what the use case is for saving a backup of an already saved file that just gets overridden when it's saved again. |
| [2020-07-22 18:58:56] |
| ForgivingComputers.com - Posts: 999 |
|
I'm wondering if there's a way to recover spreadsheets when one HASN'T yet saved and it crashes.
I don't think Sierra supports backing up unsaved worksheets. MS Office didn't always do that, maybe we will see that one day with Sierra Chart.I wonder what the use case is for saving a backup of an already saved file that just gets overridden when it's saved again.
The backups do not get overwritten. They are numbered. |
| [2020-07-22 20:53:19] |
| tmrtn - Posts: 4 |
|
Thanks again. You're saying the backups are actually versions?
|
| [2020-08-03 12:31:29] |
| tmrtn - Posts: 4 |
|
I attempted to use the backup system today. Perhaps I'm doing it wrong. I opened a chartbook, went to Studies, then to the spreadsheet I needed to restore, then next to Spreadsheet Name I clicked Select and used the dialog box to find a backup of the spreadsheet in the Backups folder. When I reviewed the spreadsheet contents I found it to be empty: no formulae, no colors, no extra sheets. Is there a better way to restore the file or is the backup system meant to be used another way? |
| [2020-08-03 14:08:02] |
| ForgivingComputers.com - Posts: 999 |
|
I think the spreadsheet file was saved (and backed up) without formulas, if you are not seeing any. You can test saving a spreadsheet with a formula in column K, and then opening the backup from the backups folder. The formula should still be there in column K.
|
To post a message in this thread, you need to log in with your Sierra Chart account: