Re: [libreoffice-users] Libre Calc formulas not working correctly

The formulas feed off a couple of worksheets. I will try this when i see 
it again. This is an intermittent problem and there was a time i was 
using the xls format because I was sharing with someone who doesn't have 
LO. I have gone to only using the ods format but there could be left 
over formulas.

thanks,
Pat
On 11/05/2013 04:28 AM, Tom Davies wrote:
> Hi :)
> When converting a document from MS Office to LibreOffice i usually just use
> "Save As ..." and choose ODt, Ods or whatever.  However the document
> sometimes doesn't work properly.  In those cases i usually find copying the
> contents into a fresh new document created afresh in LibreOffice and
> pasting in as "unformatted text"
> Ctrl Shift v
> rather than normal paste of
> Ctrl v
> seems to be the only way to get rid of weird MS coding that has been
> stuffing-up the document.  I've not actually done this with spreadsheets
> and don't know if there is an equivalent.  I would try creating a new Ods
> file and then copy the contents of each tab at a time.  Moving the whole
> tab into the new file is likely to keep whatever weird coding is in the
> worksheet so i would click into the worksheet and do
> Ctrl a
> Ctrl c
> and then click into the new one and do
> Ctrl v
>
> Is it possible to test just a couple of worksheets that way or do the
> formulas feed off other worksheets?
>
> Regards from
> Tom :)
>
>
>
> On 1 November 2013 23:05, P. A. Grubel <pagrubel@tularosa.net> wrote:
>
> > I could not duplicate this with a smaller spreadsheet, but when I
> > attempted to make the smaller file it recalculated. So, to solve my
> > problem, I copied a sheet and deleted the copy...then everything
> > recalculated. Ugh this is not good. I would assume if atleast when I exit
> > the program and get back in it would calculate. I am using formulas such as
> > average,  stdev and harmonic means.  I hope someone can duplicate this and
> > find out what is happening.
> >
> > Pat
> >
> > On 11/01/2013 02:54 PM, P. A. Grubel wrote:
> >
> > > Okay this is happening again. This time I copied an entire file to enter
> > > different data. I entered that data but some of my formulas will not
> > > recaclulate. I made a copy of one of file and deleted some sheets to send
> > > it to you but the formulas recalculated in that one.
> > >
> > > Ugh~!
> > > On 10/30/2013 11:32 AM, Brian Barker wrote:
> > >
> > > > At 10:13 30/10/2013 -0600, Pat Grubel wrote:
> > > >
> > > > > I am using Version: 4.1.2.3 and all of a sudden my formulas are not
> > > > > working correctly. I'm using average, stdev and median.  At one point I
> > > > > copied these formulas and have seen that sometimes they don't update.
> > > > > Usually if I close the spreadsheet and reopen it they are okay but that
> > > > > isn't the case today.
> > > > At 10:33 30/10/2013 -0600, Pat Grubel wrote:
> > > >
> > > > > So i got the formulas to work by recopying them and hitting F9 but I'm
> > > > > really worried that other formulas are producing incorrect values and I
> > > > > have many and wouldn't always know when that happens. Should I change to a
> > > > > different version?
> > > > No.  Ensure that Tools | Cell Contents > | AutoCalculate is ticked.
> > > >
> > > > I trust this helps.
> > > >
> > > > 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


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