Hi Tom i forgot to add, the first time i saw the corruption was on OSX 10.6.8 running LO 3.X (cant remember), but that was only opening the file, not saving, so i decided not to use that one again...
do you save locally or Dropbox or somthing else? cheers Phil On 6 July 2014 13:44, Tom Cloyd <[email protected]> wrote: > 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 > * << [email protected] >> (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: [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
