Summary: | XIRR function doesn't work with concatenated ranges (using ~) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | abe |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WONTFIX | ||
Severity: | normal | CC: | erack, raal, rb.henschel, xiscofauli |
Priority: | medium | ||
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bz.apache.org/ooo/show_bug.cgi?id=118154 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 |
Description
abe
2019-05-19 05:23:10 UTC
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 |