Issue 62278 - Italian .xls import untranslated tir.x() should be xirr()
Summary: Italian .xls import untranslated tir.x() should be xirr()
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-02-19 15:57 UTC by aziem
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sanitized bugdoc: look at D24 (24.00 KB, application/
2006-02-19 15:58 UTC, aziem
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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 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.

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.

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