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

bunk3m wrote:
Thanks so much for taking time to answer my question.

I never thought about the 12.6 issue messing up the decimal number
format as it never happened in Excel.  As I've moved over to using LO,
I've learned some Excel behaviours really don't translate very well.

A bit more below.

On 15.10.2014 15:23 , wrote:
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.

Works for me with LibreOffice 4.3.0 on Windows Vista; perhaps it's
changed since then, or maybe it's different on Mac anyway. The problem
with doing it, though, is that the date acceptance patterns affect
what's interpreted as a date even for cells not formatted as date.
That may be the reason for a change between 4.3.0 and 4.3.1.

With "D.M" added to the date acceptance patterns, entering "12.6" in a
cell formatted as General becomes "12/06/14" - which may not be
desirable if you actually wanted to enter a number between 12 and 13.

Even more bizarrely, explicitly formatting a cell as number (0.00) and
then entering "12.6", it becomes "41802.00" (probably the numeric
value for the 12th June 2014) But "43.6" becomes "43.60" as expected,
presumably because it can't be interpreted as a valid date anyway.
Damn, never even considered this.  This could have gotten really messy.

Would using "/" or "-" as a separator be an acceptable alternative? So
you could enter "12-6" or "12/6" to get the date 12th June 2014.

No it wouldn't be a problem.  I had a brain cramp and couldn't get past
my old learned behaviour.

Thanks again for your help.


Great. Thanks for letting us know this works for you. Hopefully it won't take too long to adjust ;o)


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

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.