bug: data validations and durations don't work well together

quadratichq / quadratic

Quadratic | Spreadsheet with Python, SQL, and AI

https://QuadraticHQ.com

Other

3.05k stars 157 forks source link

bug: data validations and durations don't work well together #1994

Open jimniels opened 1 month ago

jimniels commented 1 month ago

Creating and selecting enumerated data validations doesn't seem to work
Resizing a column doesn't move the error triangle

https://github.com/user-attachments/assets/90f920f2-893b-4dda-9add-8e04264d40a9

davidfig commented 1 month ago

This is not a data validations issue. The "6 months", etc. is being converted into a duration; the "6mo" is the display for that duration. We don't currently have a setting to format duration. It's something we have to add similar to the DateTime formatting dialog.

We'll also need to add duration to the validation menu.