We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

LiberOffice Calc error [closed]

asked 2018-09-03 14:19:49 +0200

Pankaj2006 gravatar image

updated 2020-08-20 15:27:01 +0200

Alex Kemp gravatar image


When I attempt to make a subtraction of two values in a cell using =D5-C5 it gives me the correct answer but for any reason, if I close that workbook having safely saved everything and reopen it after some time, it displays of:]=[.D5]-[.C5].

I have been using the Liber Office since last 6 years and never have I encountered this type of error. Can anyone throw some light on this?

I am using Liber Office Version: | Build ID: 1:5.1.6~rc2-0ubuntu1~xenial3 | CPU Threads: 2; OS Version: Linux 4.15; UI Render: default; OS: Ubuntu 16.04.3 LTS

Sample document: C:\fakepath\CALC ERROR REPORTING .ods

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-20 15:27:32.253890


Can you anonymize your file and upload it here? Which OS? Which LibreOffice-version?

ebot gravatar imageebot ( 2018-09-03 14:27:26 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2018-09-03 16:11:17 +0200

ebot gravatar image

I do not know what you are doing. It works for me. C:\fakepath\LibreOffice Calc Error.ods

edit flag offensive delete link more



I am not telling that formulae are not working, maybe I failed to frame my query properly. Let me reframe it.

When I attempt to enter a formula everything works fine and it shows proper results. But after I close the workbook having saved everything and reopen after some time, it shows what I have submitted to you.

I hope it makes some sense now.

Thank you.


Pankaj2006 gravatar imagePankaj2006 ( 2018-09-03 16:32:31 +0200 )edit

@ebot: how can that broken original file work for you?

erAck gravatar imageerAck ( 2018-09-03 16:42:07 +0200 )edit

I have executed the instruction of the questioner. "When I try to make a subtraction of two values in a cell using" = D5-C5 "..." etc.I did that. I use the DE-UI, where the values are separated with ",".

ebot gravatar imageebot ( 2018-09-03 16:55:53 +0200 )edit

So you tried to redo/rewrite the document with your working version, which does not exhibit the problem.

erAck gravatar imageerAck ( 2018-09-03 17:14:57 +0200 )edit

Only the formula. Then save and open.

ebot gravatar imageebot ( 2018-09-04 07:30:26 +0200 )edit

answered 2018-09-03 16:40:12 +0200

erAck gravatar image

The original file https://ask.libreoffice.org/upfiles/1... uploaded by the questioner indeed in the cell range H5:H8 contains text that looks like broken ODF formulas, but the cells are text cells and not formula cells.

<table:table-cell office:value-type="string" calcext:value-type="string">

A correct ODF formula cell would be

<table:table-cell table:formula="of:=[.D6]-[.C6]" office:value-type="float" office:value="8.05" calcext:value-type="float">

(note also the extra ] in of:]=... vs of:=...).

I assume that something not LibreOffice messed with your file, do you have other programs in use that may have accessed the file and written nonsense to it?

edit flag offensive delete link more


Maybe some backend process may have messed up my file. All I am using is Thunderbird mail client, Firefox, Knotes, and LiberOffice so I do not see anything problematic here. I will check it out once again tomorrow and see if this is repeated. If it is, I will get back here with more information on it.

Thanks a lot for your time.


Pankaj2006 gravatar imagePankaj2006 ( 2018-09-03 17:34:08 +0200 )edit

answered 2018-09-03 17:31:50 +0200

Lupp gravatar image

updated 2018-09-03 17:49:10 +0200

I cannot but suspect user profile corruption or a similar error in the range of shared files.
Try to run LibO in safe mode first (>Help > Restart in Safe Mode...) enter working formulae and do another safe/reopen cycle.
If you don't have the issue now, reset your user profile to get rid of the issue. (Be careful with your templates and scripts if any.)
Otherwise try a new install (or a repair install) of LibO.

{A correct descripion of the mentioned cell containing the example formula in the content.xml would read (e.g.):
<table:table-cell table:formula="of:=[.D5]-[.C5]" office:value-type="float" office:value="7.98" calcext:value-type="float"><text:p>7.98</text:p> </table:table-cell>}.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-09-03 14:19:49 +0200

Seen: 193 times

Last updated: Sep 28 '18