Support Board
Date/Time: Thu, 30 Oct 2025 10:19:57 +0000
Spreadsheet "copy value"
View Count: 1341
| [2017-12-09 16:14:06] | 
| User170575 - Posts: 221 | 
| 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] | 
|  | 
| 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. 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 | 
| [2017-12-13 16:57:12] | 
| User170575 - Posts: 221 | 
| I very, very much appreciate your effort but there are issues still--I am on version 1663 | 
| [2017-12-13 18:55:45] | 
|  | 
| 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. 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 | 
| [2017-12-13 19:32:02] | 
| User170575 - Posts: 221 | 
| try a sort | 
| [2017-12-13 19:41:26] | 
|  | 
| 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. 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: 2017-12-13 19:41:46  | 
| [2017-12-13 19:59:14] | 
| User170575 - Posts: 221 | 
| 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] | 
|  | 
| 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. 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: 2017-12-13 20:37:30  | 
To post a message in this thread, you need to log in with your Sierra Chart account:
