# Calc Cells not calculating at all? [closed]

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

David

edit retag reopen merge delete

### Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-11-02 04:18:11.488003

Sort by » oldest newest most voted

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

more

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

more

Is must be =3*4.

( 2013-05-28 15:33:08 +0200 )edit

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

more

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

more

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

( 2012-12-12 15:24:26 +0200 )edit

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

( 2012-12-12 15:28:22 +0200 )edit

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.

( 2012-12-12 17:34:52 +0200 )edit

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.

( 2012-12-12 17:34:52 +0200 )edit

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!

more

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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!