Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 01 May 2021 00:25:27 +0200Using VALUE function to compare two numbers yields incorrect resultshttps://ask.libreoffice.org/en/question/307104/using-value-function-to-compare-two-numbers-yields-incorrect-results/Added example file on 2021-0502: JQ
[C:\fakepath\value_test.ods](/upfiles/1619991998797776.ods)
-------------------------------------
Hello:
Currently, I am running Libreoffice CALC Version: 5.1.6.2 - Build ID: 1:5.1.6~rc2-0ubuntu1~xenial10.
The issue is this: I have two columns of numbers, which are text fields, not numerical fields. I use the following formula to compare the values of each: **=IF(VALUE(E1)=VALUE(G1),"Okay","Error")**. In most ALL case, the result returns "Error", which is incorrect. In some cases, the result returns "Okay", which IS correct.
Here's a paste of several rows of actual data:
[ Col E Col F Col G ]
$235.68 Okay $235.68
$225.73 Okay $225.73
$215.94 Okay $215.94
$212.94 Okay $212.94
$195.64 Error $195.64
$187.84 Error $187.84
$170.26 Error $170.26
$168.27 Error $168.27
I've seen this problem over the past few releases of LIBRECALC for the past five years. It appears to be a bug that has yet to be reported (I've searched for the past few years) nor fixed.
What is the solution, if any?
Thanks in advance for any constructive input.
Peace and blessings.johnnyquestSat, 01 May 2021 00:25:27 +0200https://ask.libreoffice.org/en/question/307104/