Tag: #ui
3 articles
-
Stop Bad Data at the Cell — Data Validation in a JavaScript Spreadsheet
Dropdown lists, numeric and date bounds, custom formula checks — reject invalid input the moment it's typed, with zero form-validation code. A full order-entry example using ReoGrid Web's Excel-style data validation, including input prompts, error alerts, and xlsx round-trip.
-
Traffic-Light Dashboards in a JavaScript Spreadsheet — Conditional Formatting by Example
Color-code a spreadsheet by its values — red stock warnings, green over-target sales, status-tinted rows — without writing a single styling loop. A full worked example using ReoGrid Web's three conditional-formatting rule types, with live re-evaluation as data changes.
-
Checkboxes, Dropdowns, and Progress Bars in Cells — Building a Live Attendance Sheet with Cell Types
Bring the interactive parts of an Excel business sheet — checkboxes, pick lists, progress bars — to the web without rebuilding them as HTML forms. A full worked example: a weekly attendance sheet using ReoGrid Web's 8 built-in cell types.