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

I save to my Dropbox. Don't think that's relevant, though. Can't figure how
it would be.

Tom




On Sun, Jul 6, 2014 at 6:49 AM, Philip Ward <skeggy78@gmail.com> wrote:

> 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 <tomcloydmsma@gmail.com> 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
> > * << 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

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