[Libreoffice-bugs] [Bug 119766] New: [Versão: 6.1.0.3 (x64)] Function ARRED returns wrong number

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119766

            Bug ID: 119766
           Summary: [Versão: 6.1.0.3 (x64)] Function ARRED returns wrong
                    number
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: elo.f360 at gmail.com

Description:
Hi guys!

NOTE: I'm noob at this, so forgive me if this is NOT an ERROR and I did
something wrong

I had and Sheet and when updated to the version mentioned above stopped working
correctly. Ex:
Cell------Contains
M148     =
DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;1;2));0;1)+DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;3;2));0;1)+DESLOCAMENTO(bdProd;VALOR(EXT.TEXTO(L148;5;2));0;1)
N148      =ARRED(M148/100;1)
Results
N148 shows 420
N148 shows 0

Thank you very much!
Kind Regards,
elo

Actual Results:
(see Description)

Expected Results:
4


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180909/ef944925/attachment.html>