Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 31 May 2015 21:25:44 +0200Calc does not compute a formula, why?https://ask.libreoffice.org/en/question/51396/calc-does-not-compute-a-formula-why/I am working with Mac OS X Yosemite Version 10.10.3 and LibreOffice Version 4.3.7.2.
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](/upfiles/14331000347778593.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?mauriceSun, 31 May 2015 21:25:44 +0200https://ask.libreoffice.org/en/question/51396/