Calc Cells not calculating at all?

Hi

Very straight forward question really that has I am sure a simple answer - none of my Calc spread sheets will do any calculations i.e. the highlighted cells result in =Sum (cells) and no result?? Tried it several times in different spreadsheets and it works fine in Gnumeric, but not Calc at all??

Any answers gratefully accepted

David

How does one use this site???

I must be dumb, but every damn question search results in “Closed for the following reasons — Alex Kemp” — where is his answer???

How does one see or find the answer, or are they the ones listed below?

@Deano – To narrow-down the problems you’re having, please enter the following into a new spreadsheet as a test:

   |      A      |
---+-------------+--
 1 |           1 |
 2 |           2 |
 3 |           3 |
 4 | =SUM(A1:A3) |

Cell A4 should display the value 6. What value do you see?

I am having the same problem. If I enter the information above the result is 6. If I save as .odt file then re-open it remains as 6. If I save as .sxc file then re-open result is ooow:=SUM([.A2:.A4]). I can save as .xls file with result 6.

I am having problems with existing .sxc files which I open, amend then save as these then have the formula displayed not the result.

(For reference: The .sxc format is the old StarOffice/OpenOffice.org XML file format)

@mikejd – Hmm… I wonder if that’s some kind of formula namespace/naming issue. Is there some reason you need to continue using the .sxc format?

qubit - I am using the .sxc format because the files are existing in that format from previous versions of OpenOffice. Also, for the record, I have looked at Tools>>Options>>LibreOfficeCalc>>View>>Display and Formula is unchecked.

Are you set up to display formulas?
Tools/Options/LibreOffice Calc/View

Hi

Many thanks for your swift answers to my plea for help. I looked at the answer noted above in terms of the tools menu and unchecked the Displays - formulas box and hey presto we have results for calculations!

Thanks again for your help

Deano

The formulas is checked, but calc does not calculate. Calc does display formula =(A30+B30) but does not calculate that,
Calc does also display 3*4 and does not calculate that either.

If formulas is unchecked the =(A30+B30) is displayed as 7 that is OK. But 3 asterix 4 is displayed as 3 asterix 4 and not as I do expect as 12

Is must be =3*4.

Same sxc problem here: With LibreOffice Calc from Debian Wheezy (I think it was the normal version, 3.5.4) I opened a file that I have been occasionally editing since several years. It’s still in SXC format, I didn’t see any need to change. Editing and saving worked; when I open it now, I only see “ooow:” formulas. The formulas are still there, in theory I could enter them all again, but that would be a pain.

The “Display Formulas” checkbox has no effect. Tried to open it with LibreOffice 4.0.3 from Wheezy-Backports and with Apache OpenOffice 3.4.1 - same result. I suppose that the problem might not be in reading that file, but that a problem occurred during the save. Unfortunately I cannot share the document here. But looking at its content.xml, the formulas do not look that bad:

<table:table-cell table:style-name="ce31" 
 table:formula="=SUM([.F4:.F13])" table:value-type="currency"
 table:currency="EUR" table:value="637.17948676521">
<text:p>637,18 €</text:p></table:table-cell>

The only time “ooow” is mentioned inside content.xml (and style.xml) :

xmlns:ooow="http://openoffice.org/2004/writer"

In the document the cell shows as :

ooow:=SUM([.F4:.F13])

I’ll read an old copy from backup and see whether I can find any differences. But that will take me some time.

EDIT: It worked! Thanks to KDiff3, I could identify the little attribute that was missing. I unzipped the SXC file into a directory, then edited content.xml. At the beginning of this file, there is a big <office:document-content> tag. This tag ends in the corrupted version with

office:version="1.2">

and I needed to add more one attribute :

office:version="1.2" office:class="spreadsheet">

Then rezipping all files into a SXC (if you’re using zip under GNU/Linux, don’t forget -r, which is implicit with tar), opening it with LibreOffice => formulas work!