Re: [libreoffice-users] Spreadsheets not keeping correct formulas and showing jewish?

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: users+unsubscribe@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