Login Page - Create Account

Support Board


Date/Time: Fri, 04 Oct 2024 15:48:00 +0000



spreadsheets. any method to see formulas

View Count: 76

[2024-09-17 14:55:30]
User335019 - Posts: 9
Hello there

The only way i know to reach and see a formula is..
1. Go to the cell
2. double click the cell
3. see the formula
4. generally press ">>" and use mouse to enlargen the area to see formula in full.

afterwards go to another cell.
do the same.. but already forgot the previous cell formula :)

a)is there a way to see formula of a cell easily... like pointing mouse on it only

b) Or some way to export "all row 3 formulas as text" to pdf etc
PLEASE NOTE
(save as .txt option is not really readable. either by word or wordpad or notepad
please see attached picture)


İ have all 60 - full formula spreadsheets, many cells reference a cell which reference another cell and even one more deep referencing.
It is insanley hard to follow formula link by going to each cell, double clicking, enlarging and trying to memorize formula and continue to the next cell


Is there a way for easy seeing the formulas that i am unaware of.


(ps i tried copying selected range as formulas or value/formulas options and pasting in excel, but did not work)

Thank you
imagenotepad_S2dPJnrZmu.jpg / V - Attached On 2024-09-17 14:55:25 UTC - Size: 524.24 KB - 17 views
[2024-09-17 15:01:17]
John - SC Support - Posts: 34921
Like in Excel, when you select a Cell the formula is displayed in the bar above the cells. Refer to the attached image.

You can select and copy and paste from that bar as well.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
imageSpreadsheetFormulaLine.png / V - Attached On 2024-09-17 15:01:06 UTC - Size: 130.6 KB - 21 views
[2024-09-17 16:22:13]
User335019 - Posts: 9
Thank you John for the answer.

Reaching through "mouse selct" and "only one cell formula at a time" is what iam trying to evade.

The output of "save as text" option for spreadsheet is not readable. (I put the image on first message)

How can get a readable output ?
To see all row 3 formulas (say 60 of them) together at a glance . (not switching to each "one by one" clicking cells 60 times".

Thank you


*********
ADDITIONAL NOTE
(i (somehow lately :) )understood and applying your solution. and it helps a lot)
Date Time Of Last Edit: 2024-09-17 18:12:22
[2024-09-17 17:37:15]
John - SC Support - Posts: 34921
You can select the particular range of cells and then select "Spreadsheet >> Copy Formula" and then paste that into some other program that you want (such as Notepad) to be able to view the full formulas.
For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2024-09-17 18:14:33]
User335019 - Posts: 9
Yes your last advise worked very well.
Visual output is very clear to read.

Thank you for both answers
Date Time Of Last Edit: 2024-09-17 18:35:28
imageexplorer_y2B6PTjwru.jpg / V - Attached On 2024-09-17 18:35:22 UTC - Size: 77.7 KB - 16 views

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

Login

Login Page - Create Account