Ask Your Question
1

Calc Cells not calculating at all? [closed]

asked 2012-12-12 10:51:01 +0100

this post is marked as community wiki

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

Any answers gratefully accepted

David

edit retag flag offensive 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

6 Answers

Sort by » oldest newest most voted
0

answered 2012-12-12 16:13:50 +0100

this post is marked as community wiki

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

edit flag offensive delete link more
0

answered 2013-05-28 14:35:43 +0100

this post is marked as community wiki

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

edit flag offensive delete link more

Comments

Is must be =3*4.

moggi gravatar imagemoggi ( 2013-05-28 15:33:08 +0100 )edit
0

answered 2012-12-12 11:17:41 +0100

qubit gravatar image

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

edit flag offensive delete link more
0

answered 2012-12-12 13:36:29 +0100

this post is marked as community wiki

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.

edit flag offensive delete link more

Comments

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

qubit gravatar imagequbit ( 2012-12-12 15:24:26 +0100 )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?

qubit gravatar imagequbit ( 2012-12-12 15:28:22 +0100 )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.

mikejd gravatar imagemikejd ( 2012-12-12 17:34:52 +0100 )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.

mikejd gravatar imagemikejd ( 2012-12-12 17:34:52 +0100 )edit
0

answered 2013-06-09 01:18:24 +0100

Viktor gravatar image

updated 2013-06-09 22:57:34 +0100

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!

edit flag offensive delete link more
0

answered 2012-12-12 16:55:26 +0100

this post is marked as community wiki

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!

Thanks again for your help

Deano

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-12-12 10:51:01 +0100

Seen: 22,309 times

Last updated: Jun 09 '13