Support Board

Date/Time: Sun, 19 May 2024 04:36:50 +0000

Post From: Help with New Spreadsheets for non-CLR (Iteration?)

[2014-08-16 09:28:07] Link To Thread - Link To Post [Go To First Post]
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.