Support Board

Date/Time: Fri, 03 May 2024 21:18:46 +0000

Post From: V1382 Exits when $J$8=0 even though formula AND Condition is $J$8>0

[2017-10-07 06:19:24] Link To Thread - Link To Post [Go To First Post]
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