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

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;
https://wiki.documentfoundation.org/Documentation/Publications
Ahh, chapter 3 of the "Getting Started Guide" is about styles.

Regards from
Tom :)



On 14 October 2014 21:50, Jim Byrnes <jf_byrnes@comcast.net> 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 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.
> >
> > 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
> 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: 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

-- 
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