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

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