Login Page - Create Account

Support Board


Date/Time: Wed, 29 Jun 2022 23:17:12 +0000



Spread Sheet pop-up question

View Count: 732

[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
imageSpreadsheet_question.png / V - Attached On 2014-01-22 08:53:21 UTC - Size: 34.86 KB - 274 views
[2014-01-22 09:04:54]
Sierra Chart Engineering - Posts: 103520
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.
imageSpreadsheet2.png / V - Attached On 2014-01-22 09:10:33 UTC - Size: 168.11 KB - 290 views
[2014-01-23 05:44:09]
Sierra Chart Engineering - Posts: 103520
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]
tomgilb - Posts: 3327
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:

Login

Login Page - Create Account