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

2014-11-01 Thread Andreas Säger 
Am 14.10.2014 um 22:20 schrieb bunk3m:
 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.. (OSX 10.9.x)
 
 For some reason Libreoffice (4.3.1.2) will only accept dates in the
 -MM-DD format.
 
 I'm happy that I can format the date to look DD.MM. but entering in
 the -MM-DD is totally unnatural for me.
 

Modify your default template for spreadsheets if you have any.
Add a German cell style for the dates.
Apply number format code TT.MM. which means 2-digit Tag(day),
2-digit month and 4_digit Jahr (year)
Use that style for all cells where you want to use this input method:
25. = 25.11.2014 (this month's 25th day)
25.12 = 25.12.2014 (this year's 25th of December).
This can not work with any English locale because the point conflicts
with the decimal point.

Save this as your default template for your new spreadsheets:
FileTemplatesSave... [some name]
FIleTemplatesOrganize... pick your new spreadheet and choose Set
Default from the command button on the right.

Additionally you may define a custom shortcut to apply this style
(ToolsCustomizeKeyboard, category Styles.


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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

2014-10-14 Thread Jim Byrnes 

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.. (OSX 10.9.x)

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

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

Actually, I only usually type the DD.MM and expect the  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.;DD-MM-;D-M

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

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+unsubscr...@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