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

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: 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