62278 – Italian .xls import untranslated tir.x() should be xirr()

Issue 62278 - Italian .xls import untranslated tir.x() should be xirr()

Summary: Italian .xls import untranslated tir.x() should be xirr()

Status:	ACCEPTED

Alias:	None

Product:	Calc
Classification:	Application
Component:	open-import (show other issues)
Version:	OOo 2.0.2
Hardware:	All All

Importance:	P3 Trivial (vote)
Target Milestone:	---
Assignee:	AOO issues mailing list
QA Contact:

URL:	http://www.oooforum.org/forum/viewtop...
Keywords:

Depends on:
Blocks:

Reported:	2006-02-19 15:57 UTC by aziem
Modified:	2013-08-07 15:13 UTC (History)
CC List:	1 user (show)

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

Attachments
sanitized bugdoc: look at D24 (24.00 KB, application/vnd.ms-excel) 2006-02-19 15:58 UTC, aziem	no flags	Details
Add an attachment (proposed patch, testcase, etc.)

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