Search found 1 match

by Geert
Tue May 16, 2023 8:38 am
Forum: XLSReadWritwII 6
Topic: Data Range Validation
Replies: 1
Views: 486

Re: Data Range Validation

Mike,

I had exactly the same problem.
It occurs because XLSReadWrite adds an '=' in front of the Date values.
This is how I fixed it:

xlsValidation.Formula1 := 'DATEVALUE("01/01/1900")';
xlsValidation.Formula2 := 'DATEVALUE("31/12/2099")';


Kind Regards,

Geert