Ask Your Question
0

LiberOffice Calc error

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

Pankaj2006 gravatar image

updated 2018-09-28 15:07:55 +0200

David gravatar image

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: C:\fakepath\CALC ERROR REPORTING .ods

edit retag flag offensive close merge delete

Comments

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
0

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

Comments

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

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
0

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

edit flag offensive delete link more

Comments

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

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

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 89 times

Last updated: Sep 28 '18