Login Page - Create Account

Support Board


Date/Time: Fri, 28 Feb 2020 15:18:10 +0000



Spreadsheet: How to Move/Sort Columns

[2020-01-06 19:23:37]
sourdubber - Posts: 47 | Ending Date: 2019-11-06 [Expired]
I would like to arrange the columns so they're easier to follow. First, for some reason, when I create a study, there's a blank column created between two studies. How would I MOVE the second study to the blank column? Second, the spreadsheet is spread out too wide and I would constantly need to scroll horizontally to see the Date Time for a particular cell way to the right (left, right, left, right....). I tried to copy/paste A2 (date time column) but it filled the whole column with only the most recent time. Is it possible to paste the time into a designated column of choice? And, finally, can we make the text "italic" or "bold"?
[2020-01-10 23:41:09]
sourdubber - Posts: 47 | Ending Date: 2019-11-06 [Expired]
Can we please be able to sort the columns by A-Z and 1-9? Also it would be nice to be able to filter as well.
[2020-01-11 20:14:23]
tomgilb - Posts: 2388 | Ending Date: 2020-02-29
How would I MOVE the second study to the blank column?
This is not supported.
The blank column is to visually separate studies, however you can remove blank columns between study outputs by setting 'Blank Columns After Each Study' to 0.

I would constantly need to scroll horizontally to see the Date Time for a particular cell
Highlight column A and go to Spreadsheet >> Fix Column
(I also highlight rows 1 and 2 and Fix Row.)

can we make the text "italic" or "bold
This is not supported, but you can color the text or the background.

be able to sort the columns by A-Z and 1-9? Also it would be nice to be able to filter as well.
This is not supported.
You can insert/delete Formula Columns to put them in the order you want, but you must use this referencing format:
https://www.sierrachart.com/index.php?page=doc/WorkingWithSpreadsheets.php#ReferencesStudySubgraphColumnsSpreadsheetStudy
This may also require you to copy/paste formulas to the new columns.
Also, be sure the Number of Formula Columns is large enough to allow for inserted columns so that columns are not overwritten but study outputs.
Using this referencing format also allows you to add/remove/rearrange studies in the Studies to Graph list without affecting formulas.
Date Time Of Last Edit: 2020-01-17 21:33:41
[2020-01-17 21:32:17]
tomgilb - Posts: 2388 | Ending Date: 2020-02-29
Updated post #3.

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

Login

Login Page - Create Account