Issue 118154

Summary:	IRR and XIRR returns error 504 when parameters contains ~
Product:	Calc	Reporter:	vitezslav
Component:	editing	Assignee:	AOO issues mailing list <issues>
Status:	CONFIRMED ---	QA Contact:
Severity:	Normal
Priority:	P3	CC:	issues, rb.henschel
Version:	OOo 3.3
Target Milestone:	---
Hardware:	PC
OS:	Windows XP
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description vitezslav 2011-06-09 20:44:28 UTC

Hi

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

      A
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.

Regards
Vitek

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.