https://bugs.documentfoundation.org/show_bug.cgi?id=158062
--- Comment #2 from crptdng...@gmx.net --- Created attachment 190655 --> https://bugs.documentfoundation.org/attachment.cgi?id=190655&action=edit Example Sheet to reproduce error. I have attached an example sheet. How to reproduce error: (1) Open error.ods in CALC and browse to TAB "Einkaufszettel", (2) starting in line 4, drag mouse across area A:4 to C:10 and press CRTL+C to copy cell area to clipboard, (3) browse to TAB "Laufende Ausgaben", (4) do right mouse click in B:14 and select "Inhalte einfügen" -> "Unformatierter Text" -> OK (this is needed as selected and copied data contains formulae and we want only values here), (5) NOK: after data was pasted starting B:14, column "Jahr" shows "#WERT!" which is wrong as cell format in B:14 to B:20 was identified as "Datum" already. - NOK: Changing format of cells B:14 to B:20 to "Date" does not fix issue. - Workaround: Only manually entering same date string over again fixes issue. -- You are receiving this mail because: You are the assignee for the bug.