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
Confirm with Version: 6.3.0.0.alpha0+ Build ID: 630db80d17616d635cf2e5f1d5a0852428b794a3 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: x11; Looks like inherited from OOo:https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_XIRR_function
Nobody said it would. Union ranges work only with a few functions. AFAIR Excel doesn't support union ranges in XIRR() either, or does it?
Tried in Excel 2010, also doesn't support it. What other info is needed? Let's change to an enhancement request then if it isn't considered a bug?
[Automated Action] NeedInfo-To-Unconfirmed
Correct component is Calc
I don't see much of a use case, it would just introduce yet another interoperability hurdle. I'd rather close this as wontfix/notabug.
(In reply to Eike Rathke from comment #6) > I don't see much of a use case, it would just introduce yet another > interoperability hurdle. I'd rather close this as wontfix/notabug. Let's do it then