I had a very bad experience which led to huge impact while formatting the date column in csv file using LibreOffice Calc. The csv file has around 40000 recs with one of the column CREATE_DT having dates in the format MM/DD/YYYY. I used the format cell option (Right Click -> Format Cell -> Date) to change the format of the first cell in CREATE_DT column to English (AUS) YYYY-MM-DD. In order to apply this format change in the remaining 39999 dates below, I simply double-clicked the bottom right corner of the first cell. Dates changed to English AUS format, but all the values are wrong. Some of them whose dates were 2014 in actual, changed to 2089!! To make things worse, I deployed it in Production, and things went haywire!! Please take this issue as a serious problem, because, if changing format changes the data, only few would trust LibreOffice Calc for serious assignments. Appreciate your response.
We need a SIMPLE test file. Marking as NEEDINFO - please provide a test file, give enumerated reproducible steps, and mark as UNCONFIRMED. Thanks
(In reply to Joel Madero from comment #1) > We need a SIMPLE test file. Marking as NEEDINFO - please provide a test > file, give enumerated reproducible steps, and mark as UNCONFIRMED. Thanks Test file mailed to your gmail ID.
We need a simple test case attached to the bug report itself. Please don't provide a 4000 record file - strip it down and give us something manageable. Thanks
Created attachment 107575 [details] Formatting error sample Hi, I have attached a much smaller file. Although I'm not sure why I was accused of giving a "4000 record" file. The earlier file had just 150 recs approx. This file has 10 records. As I have mentioned the issue earlier, I hope I neednot re-iterate it again.
Oh please don't read too much into my comments ;) I wasn't accusing, I hadn't looked at the sample you emailed me - just saw that you original post say 4k records and was saying please don't attach that one :-D Thanks so much for adding it!
Hi, to apply the format to all cells below the first one, you have double clicked the bottom right corner of the first cell. Doing this, you have in fact filled a series that changes the values in the cells. See: https://help.libreoffice.org/Calc/Automatically_Calculating_Series To apply a format to a range of cells, select the range then choose the format and click ok in the dialog box. Your example works as expected for me using the right way to apply formatting. So I'm closing this bug as worksforme. Sophie