Skip to main content

OSPROV Dropdown and Date Picker Behavior

Spreadsheet Forms use OSPROV-specific dropdown and date picker controls. These controls are scoped to individual bound cells.

Why OSPROV Uses Custom Dropdowns​

Some spreadsheet grids support dropdown editors at the column/editor level, but OSPROV Spreadsheet Forms bind individual cells as fields. A column-level dropdown would incorrectly affect the whole column. OSPROV therefore injects a single-cell HTML dropdown for each bound Dropdown field.

Behavior:

  • Only the bound dropdown cell receives the dropdown control
  • The first option is a blank — select — option
  • Configured options are listed in the same order as the builder options
  • The selected option is stored into the hidden spreadsheet submission snapshot
  • Server-side validation rejects values not in the configured option list

Why OSPROV Uses a Custom Date Picker​

OSPROV uses a calendar overlay for date cells instead of relying on a whole-column spreadsheet calendar editor. This keeps date behavior scoped to the single bound cell.

Behavior:

  • Empty date cells show a small calendar marker
  • Double-clicking a date cell opens the calendar
  • Typing a normal character while a date cell is selected opens the calendar
  • The picker displays DD/MM/YYYY
  • The stored value is normalized to ISO YYYY-MM-DD
  • Read-only viewer mode does not allow date editing