Re: [libreoffice-users] date acceptance patterns not sticking

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 , libreoffice-ml.mbourne@spamgourmet.com 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 dd.mm.yyyy. (OSX 10.9.x)
> > >
> > > For some reason Libreoffice (4.3.1.2) 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
> > > D.M.YYYY;DD-MM-YYYY;D-M
> > >
> > > 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.
>
> B.

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

Mark.


> > > 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.
> > > B.
> > >
> > > PS I'm on digest mode.  Please CC me directly

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted