Home >> Support Board

Support Board

Date/Time: Wed, 24 Apr 2024 06:29:07 +0000

How to Post a Message for Support

Spreadsheet: How to Move/Sort Columns

View Count: 951

[2020-01-06 19:23:37] #1 [Go To First Post]
sourdubber - Posts: 52
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] #2 [Go To First Post]
sourdubber - Posts: 52
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] #3 [Go To First Post]
Sawtooth - Posts: 3976
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: Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study 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] #4 [Go To First Post]
Sawtooth - Posts: 3976
Updated post #3.

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