Bug 84641 - Standard Date Format cannot be permanently changed to dd.mm.yyyy or yyyy-mm.dd
Summary: Standard Date Format cannot be permanently changed to dd.mm.yyyy or yyyy-mm.dd
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Number-Format
  Show dependency treegraph
 
Reported: 2014-10-03 20:20 UTC by David
Modified: 2021-08-20 16:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David 2014-10-03 20:20:18 UTC
I have used many permutations of Open Office/Libre Office.  I still cannot change to default date format to dd.mm.yyyy or yyyy-mm-dd.

Microsoft Office can do this.  Why not Libre Office?

I write a lot of dates and am really annoyed that I always have to go back and manually reformat them.

This should be a no-brainer for the Libre progammers.  

I am currently using 

Libre Office

Version: 4.2.6.3
Build-ID: 420m0(Build:3)

using Ubuntu 14.04 LTS 64-bit on an AMD64 machine.

When can I expect that this issue will be remedied?
Comment 1 Adolfo Jayme Barrientos 2014-10-05 07:51:28 UTC
> This should be a no-brainer for the Libre progammers.  

If you’re not a programmer and have no knowledge of our codebase, you have absolutely no idea of the estimated complexity of a bug’s solution. Believe me, we have heard this “argument” many times, and almost always it turns out to be a deeper problem than it seems initially.

> When can I expect that this issue will be remedied?

When someone feels like working on it ;-)
Comment 2 Jean-Baptiste Faure 2014-10-05 07:58:39 UTC
Workarounds:
1/ use your own default template
2/ format the cell range where you have to type dates before typing these dates.
3/ use the standard date format of your locale.

Best regards. JBF
Comment 3 Robinson Tryon (qubit) 2014-12-29 21:57:27 UTC
(In reply to Adolfo Jayme (UX) from comment #1)
> > When can I expect that this issue will be remedied?
> 
> When someone feels like working on it ;-)

Sounds like this won't be an EasyHack, but it is a reasonable improvement.

Status -> NEW
Comment 4 Skipper 2016-03-21 19:49:11 UTC
Ohoh .... I've just read the last comments to this issue .... and they from 2014. There's nobody interested to work on it I guess. Sad sad situation ....
Comment 5 Vollbracht 2016-07-28 14:53:50 UTC
I'd like to see format string lists be stored in xml ressource files rather than in code or binary ressource files. Next step whould be adding personal format strings to list and having default format string from users choice override defauld language format string.
It should be o.k. if people that are familiar with coding formats with strings can do a litle more than others.