Support Board
Date/Time: Mon, 25 Nov 2024 09:17:35 +0000
Spread Sheet pop-up question
View Count: 1133
| [2014-01-22 08:54:13] |
| User72822 - Posts: 16 |
|
Hi, Since a few days, maybe weeks (?) every time when I want to change something anywhere in my Spreadsheets, I get a message pop-up like you can see in the attachment. I am not familiar with Excel, a friend of mine who have been made these spreadsheets is on holiday for a long time and he can't help me within a short period of time. Please, can you help me? For the record, I don't want this pop-up, in the past I din't see this pop-up. Thanks! Johan Date Time Of Last Edit: 2014-01-22 08:55:46
|
 Spreadsheet_question.png / V - Attached On 2014-01-22 08:53:21 UTC - Size: 34.86 KB - 383 views |
| [2014-01-22 09:04:54] |
| |
|
This is what you see when you select Spreadsheet >> Clear Selection. What exactly are the steps you are doing to change something on the sheet? 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 |
| [2014-01-22 09:10:52] |
| User72822 - Posts: 16 |
|
I want to change the value for time in cell J2. When I try I get the pop-up, in the past I didn't. See attachment.
|
| Spreadsheet2.png / V - Attached On 2014-01-22 09:10:33 UTC - Size: 168.11 KB - 391 views |
| [2014-01-23 05:44:09] |
| |
|
We really are not quite sure about this without some detailed analysis and we currently are developing all-new Spreadsheet functionality which should be ready in about another month or two. Our focus is on the new Spreadsheets. We are not spending further time on the old spreadsheet functionality. There may be some setting in the Spreadsheet >> Workbook Explorer which is causing this. We are not sure what. 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 |
| [2014-01-25 00:07:02] |
| Sawtooth - Posts: 4120 |
|
Try changing the cell format to Time, then use only 08:05:00 and 22:00:00 in cells J1 and J2 (don't use the TIMEVALUE function): -highlight cells J1 and J2 -right click in the highlighted cells >> Number Format >> Time >> h:mm:ss |
To post a message in this thread, you need to log in with your Sierra Chart account: