https://bugs.documentfoundation.org/show_bug.cgi?id=161552
--- Comment #5 from Bogaboga Man <[email protected]> --- (In reply to Robert from comment #2) > Libra Calc added the comment quote when I set the format to date. THAT is > the bug. > > This is east to test. > Save these three lines as test.csv > > 05/20/2024, first line > 20/05/2024, Eur date > 06/13/2024, US date > > Open test.csv with Calc > > Format the first column as date > > Look at how Libra Calc change the data from a date to a comment, Except the > Eur date style I reported this months ago. It was deemed "not a bug"...Every other software I have come across handled this matter the way you have described. What I could not understand is why LO would add the `'' at the beginning. I didn't see it till I pasted the cell contents into notepad and enlarged the font. I am sure I am not alone. -- You are receiving this mail because: You are the assignee for the bug.
