Issue 118154 - IRR and XIRR returns error 504 when parameters contains ~
Summary: IRR and XIRR returns error 504 when parameters contains ~
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.3
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2011-06-09 20:44 UTC by vitezslav
Modified: 2013-01-29 21:45 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description vitezslav 2011-06-09 20:44:28 UTC

IRR and XIRR returns error 504 when first parameter contains range concatenation ~, example

1    10
2    20
3   -35
4   12,13%     <- =IRR(A1:A3)     -  OK
5   Error:504  <- =IRR(A1:A2~A3)  -  KO

The same is for XIRR.

I would like to have the last value in the different column therefore I would need ~, however this is not currently supported.

Comment 1 vitezslav 2011-06-09 20:55:15 UTC
I tested in 3.2 & 3.3 with the same results.
Comment 2 Oliver-Rainer Wittmann 2012-06-13 12:24:05 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.
Comment 3 vitezslav 2012-06-13 13:58:50 UTC
Changed to enhancement
Comment 4 Regina Henschel 2012-06-13 15:18:28 UTC
This touches the conversion rules in ODF1.2 part2. Currently the parameter in IRR has to be a NumberSequence. But A1:A2~A3 generates a ReferenceList and this is converted to a NumberSequenceList. The latter is not allowed for IRR and so it returns an error.

Changing this would require a change in ODF1.2 standard.

The enhancement request is described clear enough, so I confirm it.