Spreadsheet Conditions

Conditional logic

• FormulaBranchingModule evaluates boolean expressions using:
  • OpenXLS (now provided by com.valkyrlabs.gridheim.formula.OpenXLSFormulaEvaluator) OR
  • JEXL fallback for common logical expressions (AND/OR/NOT, IF).

Module data schema

{
  "expression": "IF(score > 80, true, false)",
  "onTrue": "CONDITIONAL",
  "onFalse": "DEFAULT",
  "nextTaskId": "<uuid>"
}

Notes

• Output map will include branch_taskId when CONDITIONAL and nextTaskId is provided, enabling explicit jumps.
• UI spreadsheet editor components can store formulas on Workbook/Sheet/Cell and pass values into the module’s inputMap.