Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Mon, 06 May 2024 07:28:44 +0000
PC crashed, spreadsheet content is erased
View Count: 655
| [2016-06-28 07:41:01] |
| phaedonk - Posts: 350 |
|
How is this even possible? All formulas are gone, even though file's last saved date is ten days ago. All sheets are there (except a custom one for sizing), but have no formulas whatsoever. I kept the same scss file in a second instance Data folder. The 2nd instance was not even running. That spreadsheet is empty of formulas as well. How is THAT possible? I'm scratching my head to understand what happened here............. |
| [2016-06-28 08:28:33] |
| |
|
It is very hard for us to answer this question. If you attach this spreadsheet file we can have a look at it and see what it contains. Also the formulas could have been affected by the Formula Source Sheet Number setting causing them to be erased. This is explained here: https://www.sierrachart.com/index.php?page=doc/doc_SpreadsheetStudyInputs.html#FormulaSourceSheetNumber Also do not save that spreadsheet after opening it so you preserve how it was previously in case it is getting affected after opening it for some unknown reason. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-06-28 08:52:42] |
| phaedonk - Posts: 350 |
|
Have uploaded. Something strange definitely going on, as the file size is not that of a new empty file.
|
Attachment Deleted. Private File |
| [2016-06-28 09:30:20] |
| |
|
We opened up the spreadsheet file and see sheet 13 visible and we see a lot of formulas in that sheet. Tell us a specific Sheet and cell that we should look for a formula and then we will see if it is there. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-06-28 09:39:44] |
| phaedonk - Posts: 350 |
|
Sheet13, which is the source, appears empty in my SC, as all others.
|
| [2016-06-28 10:05:55] |
| |
|
The sheets are all full of formulas and values and color coding. No problem at all from what we can see. We will get back to you later today about this. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-06-28 10:06:24
|
| [2016-06-28 10:20:38] |
| |
|
If you open the Spreadsheet through File >> Open Spreadsheet do you see the formulas and data?
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-06-29 03:14:50] |
| |
|
We have not been able to come up with much about this problem so far. We need our question in #7 answered. What version of Sierra Chart are you running? Also check the Spreadsheet Color Settings: https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#ColorSettings https://www.sierrachart.com/index.php?page=doc/doc_Spreadsheets.html#CellFormatting To see if the problem relates to hidden text. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
| [2016-06-29 06:21:04] |
| phaedonk - Posts: 350 |
|
That's it, thank you! When opened through the file-open spreadsheet, it opened without problems. And also, when later used in the chartbook it stayed that way. Good. I believe you are suspecting what caused this strange behavior and my, almost, heart attack. |
| [2016-06-29 08:43:40] |
| |
|
If you can no longer reproduce the problem, then we cannot. We are actually still not sure why it happened. Without knowing what the Formula Source Sheet Number Input was set to when you had the problem we cannot know if that was the cause. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2016-06-29 09:30:04
|
| [2016-06-29 09:25:07] |
| phaedonk - Posts: 350 |
|
Not sure what you mean by how it was set to. It was set to sheet 13 from the creation of the spreadsheet.
|
| [2016-06-29 09:29:37] |
| |
|
OK this is all we needed to know. What we meant is, what it was set to.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: