[Libreoffice-bugs] [Bug 48073] New: Error 523 on TIR function

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48073

             Bug #: 48073
           Summary: Error 523 on TIR function
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.5.1 Release
          Platform: Other
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: critical
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lea_bergero at hotmail.com


I found a bug of TIR function on Calc

I have this cashflow


($54.970,00)
$602,00
$657,00
$657,00
$657,00
$657,00
$657,00
$657,00
$657,00
$776,00
$776,00
$776,00
$716,00
$716,00
$716,00
$716,00
$716,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$816,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$973,00
$803,00
$4.803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$803,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00
$758,00


when I calculate TIR =tir(values,..) the results its an error 523

The correct results should be TIR=0.631367307%

an observation, if I use values <(29000) on the first value of the cash flow,
the function work OK

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.