https://bugs.documentfoundation.org/show_bug.cgi?id=148223
--- Comment #2 from Jonny Grant <j...@jguk.org> --- Rainer Many thanks for your reply. Why is "36/04/2021" not rejected, as it is formatted as a Date? The format doesn't change to Text. Usually if I type something invalid, Calc shows "Err:511" etc Why can't it show a similar error, when someone mistypes a Date? It's one of the perennial problems in Calc, even SUM ignores boxes with text, without an error. (ie for whatever reason a number is entered in a cell that is formatted as Text - so then SUM ignores it - means accounts are wrong) Cheers -- You are receiving this mail because: You are the assignee for the bug.