Issue

• There are requirements in users to use values in Spreadsheet based Decision Tables across multiple cells. Imagine a Spreadsheet that has a list of valid values against a field. If the caller sends a different value other than the accepted list, the rule has to error out. Spreading the values across multiple cells (users can use it as part of IN condition) does not look to be possible as Drools expect the values to be in single cell. Is there any workaround for spreading values across multiple cells? Looks like otherwise operation [1] could be an option to meet this requirement. Is it supported in Spreadsheets ?

[1] Otherwise Operations