Created attachment 119233 [details] screenshot of a completely unformatted spreadheet with locale settings or do it right. See attached screen shot.
You’re not describing what’s the issue you’re having.
The screeshot demonstrates clearly that I've set up a date acceptance pattern which includes D/Y, opened a blank, new, unformatted document and entered a valid date expression 6/7 which was not accepted. Instead I get the text 6/7. The only way to enter a date
Created attachment 119390 [details] Spreadsheet demonstrating dysfunctional date input Never mind. For the records only.