Issue 62278

Summary: Italian .xls import untranslated tir.x() should be xirr()
Product: Calc Reporter: aziem <ahz001>
Component: open-importAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.0.2   
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://www.oooforum.org/forum/viewtopic.phtml?t=31960&highlight=
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
sanitized bugdoc: look at D24 none

Description aziem 2006-02-19 15:57:20 UTC 
I was given an .xls which allegedly came from the Italian Excel where a function
tir.x() should be xirr().  

Test information:
In OpenOffice.org 2.0.2rc1, cell D24 shows #ADDIN?, but changing tir.x() to
xirr() produces the correct value 6.51%.  In Excel, the cell D24 shows the
correct value 6.51%.  However, recalculating the cell causes an error in Excel.

Suggestion:
Translate tir.x() to xirr() on import or alias tir.x() to xirr().
Comment 1 aziem 2006-02-19 15:58:48 UTC 
Created attachment 34287 [details]
sanitized bugdoc: look at D24
Comment 2 frank 2006-02-21 13:48:02 UTC 
Hi Daniel,

seems to be yours.

Frank
Comment 3 daniel.rentz 2006-02-21 13:53:52 UTC 
Started.