Support Board
Date/Time: Thu, 16 Jan 2025 09:00:18 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2017-10-07 16:04:08] |
| Sawtooth - Posts: 4153 |
|
We could support recalculation or resetting of a single cell. But we are afraid of doing the entire Sheet because it is going to get misused and cause problems.
Actually, a 'Recalculate All Formulas' will release any locked TRUE condition, so recalculating the sheet, or any portion of it, is not the solution.But we need to understand what exactly the function is expected to do in regards to operating on a single cell.
Use the attached Lock a condition TRUE test.scss to duplicate the issue:The blue cells (H3-H5) will reset the lock; the yellow cells (H7-H10) will not. Steps to lock then unlock H3 (this formula references only H5 for a reset): -enter 2 in H4. H3 will go TRUE -enter 1 in H4. H3 remains TRUE -enter 0 in H5. H3 will go FALSE -enter 1 in H5. H3 is reset/ready to be locked again. Steps to lock then unlock H7 (this formula references H9 or H10 for a reset): -enter 2 in H8. H7 will go TRUE -enter 1 in H8. H7 remains TRUE -enter 0 in H9. H7 remains TRUE -enter 1 in H9. H7 is still locked. |
 Lock a condition TRUE test.scss - Attached On 2017-10-07 16:03:44 UTC - Size: 30.4 KB - 490 views |