LiberOffice Calc error

English
, ,
#1

Hi,

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: 5.1.6.2 | 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: CALC ERROR REPORTING .ods

#2

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

#3

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

#4

Hi,

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.

Pankaj

#5

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

#6

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 “,”.

#7

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

#8

Only the formula. Then save and open.

#9

The original file https://ask.libreoffice.org/upfiles/15359809594673599.ods 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">
  <text:p>of:]=[.D6]-[.C6]</text:p>
</table:table-cell>

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">
  <text:p>8.05</text:p>
</table:table-cell>

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

#10

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.

Pankaj

#11

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

#12

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.