XIRR function doesn't work with concatenated/unioned ranges (using the tilde operator ~)
This doesn't work, and gives an Err:504 instead:
Using the tilde ~ operator works for other functions, such as SUM(). All of these work and give the same result:
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.
XIRR returns a correct result.
User Profile Reset: No
Others have noticed this bug too:
Confirm with Version: 22.214.171.124.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