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