When the attached file is opened, the JOURNAL tab shows an error #VALUE! in all cells of the line 4. This happens with LibreOffice 4.4.7 that is bringed by Mageia 5 Linux, but also with LO 5.2.3 downloaded from LO site today. This bug does not happen with LibreOffice 4.3.2 downloaded from the URL below, so it seems to be a regression. http://downloadarchive.documentfoundation.org/libreoffice/old/4.3.2.2
Created attachment 129371 [details] The file that triggers the bug. You can see the value in AR4. When you change the value in AW12 to as example 5, all the line 4 values show !VALEUR! . This does not happen with LO 4.3.2
In balance.ak247 there is a text instead a number. You can change how text conversion it made, there is a new option on: Menu/Tools/Options/LibreOffice calc/Formula - Custom (conversion ...) - Details If text value is right on that cell, then change the option to Treat as zero, after that do a hard recalc [Ctrl+Shift+F9]
(In reply to m.a.riosv from comment #2) > In balance.ak247 there is a text instead a number. Thanks, I could not find where was the error. Is there a way to check for such errors?