Login Page - Create Account

Support Board


Date/Time: Mon, 23 Jul 2018 09:49:31 +0000



Spreadsheet "copy value"

Support Request:
[2017-12-09 16:14:06]
User170575 - Posts: 186
Hi--I would like to be able to just copy the values(without references/formulas)--then paste these values to sheet2 and do a sort---all of the commands are there---"copy value" and "sort" but the references are pasted making the sort obsolete.

Thoughts appreciated,

Cy
[2017-12-10 22:28:56]
Sierra Chart Engineering - Posts: 61964
This issue has already been solved. You just need to update Sierra Chart to the current version.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-13 16:57:12]
User170575 - Posts: 186
I very, very much appreciate your effort but there are issues still--I am on version 1663
[2017-12-13 18:55:45]
Sierra Chart Engineering - Posts: 61964
We do not see any problems when we select Spreadsheet >> Copy Value and paste the values aand other cells with Spreadsheet >> Paste. Only the values are pasted. This is clear.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
[2017-12-13 19:32:02]
User170575 - Posts: 186
try a sort
[2017-12-13 19:41:26]
Sierra Chart Engineering - Posts: 61964
Describe the exact step-by-step procedure you are following. Just make this as simple as possible involving 2 cells.

We do not see the relevancy of the sort. Just the values are copied and not the formulas.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-13 19:41:46
[2017-12-13 19:59:14]
User170575 - Posts: 186
I select the data---copy---paste to an added sheet---then I sort it---the data disappears or the sort does not start from the highest selected cell in the column--there are blank cells in my data just for the record
[2017-12-13 20:37:06]
Sierra Chart Engineering - Posts: 61964
Make sure you use Spreadsheet >> Copy Value to copy the values.

We have done a sort and we see no trouble with this whatsoever.

Try copying and sorting just a few values like 5. That is how we are doing the test. See if you have any trouble with that.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. If possible please keep your questions brief and to the point. Please be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

If your question/request has been answered and you do not have anything further, then it is easiest for us if you do not reply again to say thank you.
Date Time Of Last Edit: 2017-12-13 20:37:30

To post a message in this thread, you need to login with your Sierra Chart account:

Login


Login Page - Create Account