Ask Your Question

Calc does not compute a formula, why?

asked 2015-05-31 21:25:44 +0200

maurice gravatar image

updated 2015-08-26 19:28:02 +0200

Alex Kemp gravatar image

I am working with Mac OS X Yosemite Version 10.10.3 and LibreOffice Version

In cell "test1.A3" of the following file, I have a simple formula which just sums up the content of cell "test1.A2" plus 1, but it get stuck to an arbitrary number instead.

I removed everything from the file that did not trigger a new computation and I end up with a very simple file which (for a reason that I would like to understand) still does not compute correctly. Here is the file: bug.ods

The content of test1.A2 is 1985 so logically I would expect 1986 (1985+1) to appear in test1.A3 but instead I have 1866, weird!

Do you know why?

edit retag flag offensive close merge delete


Please what it's your OS and your LibreOffice version?, shows the correct value for me with Win7x64 LibreOffice

m.a.riosv gravatar imagem.a.riosv ( 2015-05-31 23:43:45 +0200 )edit

Works for me Win 8.1x64 LO I do notice that Track Changes is on. May not mean anything though.

Rugslug gravatar imageRugslug ( 2015-06-01 00:32:35 +0200 )edit

works also with 4.4 on Linux... beside that -- may I ask you: whats the sense of this obfuscated formula in A1 ??

karolus gravatar imagekarolus ( 2015-06-01 11:17:21 +0200 )edit

@m.a.riosv: I am working with Mac OS X Yosemite Version 10.10.3 and LibreOffice Version

maurice gravatar imagemaurice ( 2015-06-01 19:52:57 +0200 )edit

@karolus: I don't remember, I did this formula for another person some time ago and this person came back saying the file was broken.

maurice gravatar imagemaurice ( 2015-06-01 20:04:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2015-06-02 20:22:45 +0200

pierre-yves samyn gravatar image

Hi - As this also works in my environment (windows 7 & a new question: is your spreadsheet set to automatic recalculation (menu Tools Cells Contents AutoCalculate)?

edit flag offensive delete link more


It is set to automatic recalculation indeed. And even if I perform a manual recalculation (menu ToolsCells ContentsRecalculate), it still does not compute correctly but keep this weird value.

maurice gravatar imagemaurice ( 2015-06-02 20:44:32 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-31 21:25:44 +0200

Seen: 656 times

Last updated: Jun 02 '15