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

UPDATE: So sorry. I stupidly forgot to include info. about my operating 
environment - it's Kubuntu Linux 14.04 and I'm running LO Version: 4.3.0.2
Build ID: 14ed55896fdfcb93ff437b85c4f3e1923d2b1409. We are, of course, 
talking about Calc.

t.

On 07/06/2014 06:12 AM, Philip Ward wrote:
> 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


--




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Tom Cloyd, MS MA (LMHC, WA State)
Cedar City / St. George, UT, U.S.A: (435) 272-3332
* << tc@tomcloyd.com >> (email) << TomCloyd.com >> (website)
* Sleight of Mind blog: Sleightmind.com (mental health issues)
* Founder: Google+ Trauma and Dissociation Education and Advocacy community
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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