Hi :) If you want pointers to find out about settings and configs for other languages and/or countries then you might find the international translators mailing list quite useful [email protected]
Sounds like Brian has helped you fix it already though :) Congrats! :) Regards from Tom :) On 7 July 2014 10:22, Philip Ward <[email protected]> wrote: > Hi Brian > > Thanks for your help, our studies on other cultures at school was very > vague, and as of yet, never needed to understand another calendar.. > > It could possibly be a red herring like you say, i just put 2 and 2 > together, and came up with 5, maybe i should have used a spreadsheet :D > > Im running LO 3.4.4 on my works imac, and checking its a USA interface, UK > Locale & Currency setting... > > Just loaded up the document, and just checking the first sheet, the > formulas seem to have been saved, and work ok, ill just keep an eye on it, > and see what else happens. > > Thanks again, > > Phil > > On 07/07/2014 02:00, Brian Barker wrote: > >> At 00:05 07/07/2014 +0100, Philip Ward wrote: >> >>> On 06/07/2014 17:01, Brian Barker wrote: >>> >>>> 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 understand that the NNNDDD etc are not stored with in the format, but >>> just wondered where the jewish annotations came into effect? >>> >> >> If I understand you correctly, these are just appearing as possible >> formats in the Format Cells dialogue. If so, I don't think you should be >> too worried about them. I don't claim to understand all the aspects of >> locale settings, which exist separately for operating systems (including >> individual user settings) as well as for applications, such as LibreOffice. >> If Calc thinks you might be helped by these offerings but you don't need >> them, there is no problem I can see >> >> the top reference in the list of pre-set annotations mentioned above is >>> [~jewish]NNNND MMMM YYYY, and in the format box it is "Friday 22 Tevet >>> 5760" ... >>> >> >> That corresponds to Gregorian 31 December 1999, which is the date used >> for all format examples in the Format Cells dialogue. >> >> ... and in the preview box it is "Monday 9 Tammuz 5774", i don't even >>> know if that's correct? >>> >> >> That's Monday 7 July 2014 in the Gregorian calendar, i.e. today. >> >> ... or if the Jewish calendar works on a different format? >>> >> >> Well, yes: it has a different origin, of course - a point in 3761 BC by >> the Gregorian calendar - as well as different month names, which don't >> correspond with Gregorian months since they are generally shorter and need >> additional "intercalary" months every two or three years to keep the >> calendar in step with the solar year. >> >> I have also as a test just copied the cell into a new spreadsheet, and >>> it took over the jewish annotation? >>> >> >> By default, pasting carries over formats as well as values. You can >> suppress this using Paste Special... . >> >> I was just looking for insights as to whether anyone else has had the >>> problem? i just don't want to go much further, and lose the lot, ... >>> >> >> The question of available formats doesn't affect your use of the >> spreadsheet, does it? I suspect it is a red herring and may have no >> connection with the other corruption you mentioned (about which I have no >> comment). >> >> 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 > > -- 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
