[libreoffice-users] Re: Dot separated date in YYYY.MM.DD format
You are free to enter any text value you want. As far as the arithmetic calculators named "Calc", "Excel", "Gnumeric" etc. are concermed, the number format is completely unimportant as long as the actual _value_ of a cell is correct. All the following formatted numbers represent the exact same value: > 01/02/15 > 02/01/15 > 2015.01.02 > Freitag, 2. Januar 2015 > 2015年1月2日 星期五 -- They all sort according to their true numeric value regardless of number format which affects only the appearance. .. All calculations with any of the above values yield the exact same results. -- Using cell styles, a few clicks format all dates within the same document to your liking and these formats are persistent. -- 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: Dot separated date in YYYY.MM.DD format
Am 19.12.2014 um 16:57 schrieb T. R. Valentine: > > I suspect you would have more success using the ISO format of > -MM-DD instead of a non-standard format. > Why? Load a Calc document and apply English .MM.DD or German .MM.TT, Spanish .MM.DD or anything like that. Checking this out takes not more than a minute. -- 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: Dot separated date in YYYY.MM.DD format
Add the input format to your Date acceptance pattern? Tools -> Language Settings -> Languages: Language Of... Date acceptance patterns -=from en-US help=- Date acceptance patterns Specifies the date acceptance patterns for the current locale. Calc spreadsheet and Writer table cell input needs to match locale dependent date acceptance patterns before it is recognized as a valid date. Default locale dependent date acceptance patterns are generated build time, but it is possible to add more or modify them in this edit box. Additionally to the date acceptance patterns defined here, every locale accepts input in an ISO 8601 Y-M-D pattern, and since LibreOfficeDev 3.5 that also leads to the -MM-DD format being applied. Syntax: Y means year, M means month, and D means day, regardless of localizaton. -- View this message in context: http://nabble.documentfoundation.org/Dot-separated-date-in--MM-DD-format-tp4133212p4133233.html Sent from the Users mailing list archive at Nabble.com. -- 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