Support Board
Date/Time: Tue, 04 Mar 2025 21:39:42 +0000
Spreadsheet CELL not updating as expected + steps to reproduce.
View Count: 695
| [2021-12-23 14:12:53] |
| User346098 - Posts: 47 |
|
Using Spreadsheet system for trading study, CELL not updating as expected steps to reproduce: works properly: example A 1) put formula on cell DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on cell BS30 =IF(DM18 = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes CHEESE 4) clear formula from cell DM18 5) watch cell BS30 PROPERLY UPDATE and become "BANANAS" Broken: example B 1) put formula on DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4) clear cell DM18 , cell BS30 WRONGLY STAYS "CHEESE" and does not switch to BANANAS like with example A) I assume because VLOOKUP returns #N/A an error BUT example C below works Works properly: example C 1) put text string on DM18 "DEAD" 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4 clear cell DM18, cell BS30 BECOMES "BANANAS" ! so the question is how to make example B also work. and why does is not work ? |
| [2021-12-23 14:32:47] |
| |
|
We will check on this and see what the issue is.
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: 2021-12-23 14:49:57
|
| [2021-12-23 18:59:34] |
| Jeffrey - Posts: 2220 |
|
Broken:
example B 1) put formula on DM18 =IF(TRUE,"DEAD",FALSE) 2) put formula on BS30 =IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEESE","BANANAS") 3) cell BS30 becomes "CHEESE" 4) clear cell DM18 , cell BS30 WRONGLY STAYS "CHEESE" and does not switch to BANANAS like with example A) I assume because VLOOKUP returns #N/A an error BUT example C below works I tried repeating this on a chart and spreadsheet with nothing else going on, but when I tested it, cell BS30 correctly updates to BANANAS after clearing cell DM18. There must be some other factor involved. Try using the Details button (in the upper-right corner of the spreadsheet window) with cell BS30 selected to see if any part of the formula evaluation appears incorrect there. |
| [2021-12-24 01:27:47] |
| User346098 - Posts: 47 |
|
IT seems to be working now, I don't understand why, I didn't do any different, only difference market is closed now that I can think of... [ IF ] IF(VLOOKUP("DEAD", DM3:DM600,1) = "DEAD", "CHEE... = "BANANAS" (text) [ = ] VLOOKUP("DEAD", DM3:DM600,1) = "DEAD" = 0 (number, integer) [ VLOOKUP ] VLOOKUP("DEAD", DM3:DM600,1) = #N/A (error) [ "DEAD" ] "DEAD" = "DEAD" (text) [ DM3:DM600 ] DM3:DM600 = DM3:DM600 (range) [ 1 ] 1 = 1 (number, integer) [ "DEAD" ] "DEAD" = "DEAD" (text) [ "CHEESE" ] "CHEESE" = (not evaluated) [ "BANANAS" ] "BANANAS" = "BANANAS" (text) spreadsheet system trading study on chart but the sheet in this spreadsheet I am testing isn't associated with any chart if it matters... |
To post a message in this thread, you need to log in with your Sierra Chart account: