Support Board
Date/Time: Tue, 22 Apr 2025 00:15:33 +0000
Post From: Inquiry About Discrepancy Between Formula Evaluation and Displayed Result in Spreadsheet
| [2025-02-22 07:32:17] |
| zenhunter - Posts: 2 |
|
Dear Sierra Chart Engineers, First of all, I would like to express my appreciation for the incredible work you've done with Sierra Chart. The platform is exceptionally powerful, reliable, and highly customizable, making it one of the most versatile tools available for traders. Thank you for your continuous efforts in improving it! I’m reaching out regarding an issue I encountered in the Sierra Chart Spreadsheet. I have an IF formula that evaluates correctly in the Formula Debugger (Details) (it returns 1 (True)), but the actual cell where the formula is applied displays a result of 0 (False). Based on the logic, all conditions seem to be met, yet the displayed value doesn’t match the evaluated one. My question is: Is there any known situation or specific setting in Sierra Chart Spreadsheet that could cause a discrepancy between the formula's evaluated result and the value shown in the cell? I have already checked the following: Cell formatting Formula recalculation Cell references involved in the formula. Despite these checks, the issue persists. Search on support board Please see attached a screenshot. Sierra Version: 2720 64-bit revision 51974 Any guidance or recommendations you could provide would be greatly appreciated. Thank you very much for your time and support! Adrian |
 Screenshot_345.png / V - Attached On 2025-02-22 07:19:56 UTC - Size: 159.93 KB - 32 views |