Data validation - Dates

[PhilipeRLeal]

Dear developers,

First of all, I would like to thank you for such an amazing package.

Recently, I have been investigating how to use SpreadCheetah to create some local Excel files. In my study, I noticed that SpreadCheetah does not implement boundary validation for DateOnly and/or DateTime objects; so far, I could only find solutions for numerical boundary problems.

Therefore, I would like to suggest a DateTime and a DateOnly Boundary validators to the available package options.

Sincerely,

[sveinungf]

Thanks for the feedback!

What kind of boundary validation are you looking for? Are you thinking about the case that dates must be greater than January 1, 1900?

[PhilipeRLeal]

Dear Sveinungf,

Precisely the case.

Excel files do support all kinds of boundary value types (decimal value, integer value, date-only, date-time, etc.), and boundary rules (greater than, greater or equal than, between, lower than, and lower or equal than) validations. Therefore, It would be most welcoming to have these functionalities available within SpreadCheetah.

Sincerely,

[sveinungf]

Ah yes, now I understand. So in practical terms it would be to extend the DataValidation class with e.g. DataValidation.DateGreaterThan and similar. That part is missing now but it sure could be a useful feature. Thanks for the suggestion!