Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Hi :)
Is this set-up in somewhere weird like

Format - "Styles and Formatting"?

Maybe one of the early chapters in the Published Guides might be able to
help set it more permanently;
Ahh, chapter 3 of the "Getting Started Guide" is about styles.

Regards from
Tom :)

On 14 October 2014 21:50, Jim Byrnes <> wrote:

On 10/14/2014 03:20 PM, bunk3m wrote:

Libreoffice is driving me nuts.

I am in Canada. UI is set to English US; Locale settings to English
Canada and Default Currency is CAD.

I have my Mac set dates to (OSX 10.9.x)

For some reason Libreoffice ( will only accept dates in the
YYYY-MM-DD format.

I'm happy that I can format the date to look DD.MM.YYYY but entering in
the YYYY-MM-DD is totally unnatural for me.

Actually, I only usually type the DD.MM and expect the YYYY to show up
automatically in Excel.  I'd like the same behaviour in LO if possible.

The date acceptance patterns will not accept anything except what is
loaded by default ... which is

I don't want to have to type the YYYY each time for D.M.YYYY.

I've tried to add D.M to the acceptance pattern but the text turns red
and won't save.  The D.M is always gone after trying to save.

So if the date acceptance patterns are supposed to be customizable by
the user ...

what do I have to do to get this to work?

Thanks in advance.

PS I'm on digest mode.  Please CC me directly

Try this:

right click on a cell
select Format Cells
in category choose User Defined
in Format code enter:  00"."00".2014"

Then you can go to that cell and enter for example: 2512 and it should
display as 25.12.2014.

A couple of things to remember.  This looks like a date but I don't think
you could do date math with it.  I do this all the time but I just need it
to visually look like a date.  Also in 86 years you will need to rewrite it.

Regards,  Jim

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.