Support Board
Date/Time: Thu, 16 Jan 2025 08:59:35 +0000
Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0
| [2017-10-07 06:19:24] |
| User29926 - Posts: 92 |
|
If you go through the steps to lock and unlock, then you go to Spreadsheet >> Recalculate All Formulas, H3 will reset.
Hi tomgilb, Thanks for the reply. Yes, once H4 <1 and the reset procedure is done. Then manually going to Spreadsheet >> Recalculate All Formulas. H3 does reset. However, this lock and unlock cell feature will be used in an auto trader. There would be 5 different conditions that will cause the cell to reset itself. If I have to set and watch the multiple spreadsheet cells then manually recalculate the spreadsheet to reset the targeted cell. That defeats the purpose of having a cell that can reset itself without my interference or constant attention. Currently there is no way to have a cell recalculate itself or the entire spreadsheet. Sierra support has stated "No, this is not supported. It is not something that we would add." Spreadsheet recalulate I would think that added a built in function to reset a targeted cell or the entire spreadsheet. IE: targeted cell: Recal($H$3) or entire spreadsheet: Recal() . To their own spreadsheet design shouldn't be that difficult. Date Time Of Last Edit: 2017-10-07 06:23:13
|