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 |
notepad_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 |
SpreadsheetFormulaLine.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
|
explorer_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: