I can t make a series of dates in UK format

asked 2018-05-20 12:16:26 +0100

edblack gravatar image

Hi, I am trying to create a schedule for work. I have a date column but even when I make the format correct for UK date formats, when I use the fill function it defaults to something else. In the format setting for dates UK is set as my default.

edit retag flag offensive close merge delete


This isn't the answer you wanted. Dates are a problem for many people and with many computer programs. So I highly recommend using the ISO 8601 format for dates, yyyy-mm-dd, instead of any local format.
See https://www.w3.org/QA/Tips/iso-date

and https://en.wikipedia.org/wiki/ISO_8601

You will probably have to adjust LibreOffice accordingly, but your computer problem will be solved and you will then only have to educate your uses.

ve3oat gravatar imageve3oat ( 2018-05-20 20:36:20 +0100 )edit

I can't reproduce that here. If I enter a date in a cell, format that cell and fill down, then the formatting of the original cell is preserved. Sounds like a bug. What version of LibreOffice are you using?

hjek gravatar imagehjek ( 2018-06-07 20:36:07 +0100 )edit