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

Hi Guys,

Running 4.1.3.2 Libreoffice, on Win 7 64Bit, and having a few annoyances??

i have a multi sheet document, page one has some dates on it, and these
dates are then grabbed by the following sheets to make the dates work on
them etc??

sometimes i load up the document, and the formula's all go to pot

I put the start date of the year that the user wants, and then just select
another cell and say   "= B4 + 7 "

but it keeps coming up with

=SUM('View Kitchen'.KY16)

which is sheet that should be getting the information from this area..

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

cheers for any help.

Phil

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