[Libreoffice-bugs] [Bug 125365] New: XIRR function doesn't work with concatenated ranges (using ~)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 125365
           Summary: XIRR function doesn't work with concatenated ranges
                    (using ~)
           Product: LibreOffice
           Version: 6.2.1.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Formula Editor
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: abe at ualberta.net

Description:
XIRR function doesn't work with concatenated/unioned ranges (using the tilde
operator ~)

This works:
=XIRR(L2:L289,C2:C289)

This doesn't work, and gives an Err:504 instead:
=XIRR(L2:L288~L289, C2:C288~C289)

Using the tilde ~ operator works for other functions, such as SUM(). All of
these work and give the same result:
=SUM(L2:L289)
=SUM(L2:L288~L289)
=SUM(L2:L287~L288:L289)

Steps to Reproduce:
1. Create 2 columns, one with dates and one with numbers
2. Use the XIRR function, giving it those 2 columns as input and using a ~
concatenation for at least one of the 2 columns, concatenating two halves of
it.


Actual Results:
Err:504

Expected Results:
XIRR returns a correct result.


Reproducible: Always


User Profile Reset: No



Additional Info:
Others have noticed this bug too:

https://ask.libreoffice.org/en/question/81399/how-to-concatenate-two-ranges/
https://forum.openoffice.org/en/forum/viewtopic.php?p=122245

-- 
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/20190519/9564f5f5/attachment.html>