Support Board
Date/Time: Wed, 27 Nov 2024 10:29:54 +0000
Post From: Help with New Spreadsheets for non-CLR (Iteration?)
| [2014-08-16 09:28:07] |
| User33803 - Posts: 40 |
|
When designing the spreadsheet, I had a problem that I solved with this circular/crossreference. With the Old Spreadsheets it worked just fine. What I needed was that cell AD122 sets to 1 just to force cell AD121 to return from 1 (blocked) to 0 (unblocked). Then, the cell AD122 should immediately return to 0. In other words, cell AD122 resets the blocked state (value=1) of cell AD121 and its value should be always 0 except for resetting (the value 1 for AD122 is a kind of "glitch"). The blocking of AD121 is governed by AD120 which contains different references to other cells in the spreadsheet. The reset (AD122) is governed by AD123 which contains different references to other cells in the spreadsheet. The release of the blocked state of AD121 can only be produced when AD120 (trigger condition to block AD121) is set to 0, the cell AD121 is blocked and the reset condition is met AD123=1. |