Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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.

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


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.

On 10/30/2013 11:32 AM, Brian Barker wrote:

At 10:13 30/10/2013 -0600, Pat Grubel wrote:

I am using Version: 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.