At 13:12 06/07/2014 +0100, Philip Ward wrote:
... and now i went in to alter the format of the cell ie Date
details "NNNND MMMM YYYY" giving me "Monday 6 October 2014" but now
want to shorten the date down to "mon 6 oct 2014", but its now
telling me options for jewish?? ie " [~jewish]NNNND MMMM YYYY" i
know i can alter the details, but does anyone have any ideas as to
why my cells change from what they should be? or why i now have
jewish in there as well?
Yes and no. There are a few things worth knowing.
o The definition of ODF says that the format code is "a sequence of
characters with an implementation-defined meaning", so clearly it can
be different in different standards-respecting applications. So
formats such as "NNNND MMMM YYYY" are not saved as such in ODF
document files. Instead, it seems that three things are saved: the
date in ISO standard form (2014-10-06), the actual text as displayed
(Monday 6 October 2014), and a description in different terms of your
chosen format - such things as:
<number:day-of-week number:style="long" />
<number:text />
<number:day />
<number:text />
<number:month number:style="long" number:textual="true" />
<number:text />
<number:year number:style="long" />
When you reopen a document, the necessary formats must be
reconstituted from this information in the file.
o Dates in particular are reconstituted with reference to the current
locale. If, for example, I enter today's date (6 July) in my UK
locale, it is displayed naturally as 06/07/14. If I save that in a
document and reopen it in a US locale, the format is automatically
reconstituted differently, with the same cell being displayed instead
as 07/06/14.
o It seems that some formats that have been used or appeared
automatically but perhaps are no longer needed are nevertheless saved
in the document.
So I think some of this could be explained by this document having
been opened and resaved on a system with locale set to Hebrew.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
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
