Hi Tim
I belive that this actually is the expected behavior.
Tim Lloyd skrev 2013-11-26 04:54:
If I enter 7/8 the cell shows 41493.
Well this is the numeric representation of the date 2013-08-07. So the
problem is that Calc is converting the value 7/8 into a date. If you go
to Tools -> Options -> Language Settings -> Languages, you can enter
what patterns that are to be recogniced as dates in the text box Date
acceptance patterns. If you remove D/M from the list of comma separated
patterns then you can enter 7/8 and it will no longer be converted.
Of course it would be nice if the cell format would have some sort of
precedence over these auto-conversion functionality but that is at best
a feature request.
/Niklas
_______________________________________________
List Name: Libreoffice-qa mailing list
Mail address: [email protected]
Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
