Issue 76773 - Commands reversal in the Italian version: P.RATA - INTERESSI
Summary: Commands reversal in the Italian version: P.RATA - INTERESSI
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.2
Hardware: HP (PA-RISC) Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, needmoreinfo, oooqa
Depends on:
Reported: 2007-04-27 21:37 UTC by giuseppe_vittucci
Modified: 2014-06-21 09:25 UTC (History)
3 users (show)

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

Screenshot Italian (105.63 KB, text/plain)
2008-07-07 20:03 UTC, giuseppe_vittucci
no flags Details
Screenshot Italian (105.63 KB, image/png)
2008-07-07 20:04 UTC, giuseppe_vittucci
no flags Details
Screenshot English (105.08 KB, image/png)
2008-07-07 20:06 UTC, giuseppe_vittucci
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description giuseppe_vittucci 2007-04-27 21:37:25 UTC
In the Italian version of OpenOffice.Calc there is an error in the names of the
commands INTERESSI and P.RATA. They are in fact inverted. Indeed, as in MS
Excel, the latter should correspond to the English command PPMT and work out the
principal repayments on loans, assuming it takes the form of an annuity. In OOo
this command actually calculates the interest charged (as done by the English
command IPMT), while the principal component repayment is instead worked out by
INTERESSI, which should instead give the interest component.
Comment 1 Rainer Bielefeld 2007-07-09 19:25:07 UTC
Please attach a small sample document with some hints "expected:... / actual: ..."
Comment 2 frank 2007-08-09 16:11:19 UTC
Please have a look at this one
Comment 3 petr.dudacek 2008-07-07 16:26:34 UTC
Any update regarding a sample document illustrating this issue (if the problem
still exists in OOo 3.0 Beta)?
Comment 4 giuseppe_vittucci 2008-07-07 20:03:48 UTC
Created attachment 54989 [details]
Screenshot Italian
Comment 5 giuseppe_vittucci 2008-07-07 20:04:09 UTC
Created attachment 54990 [details]
Screenshot Italian
Comment 6 giuseppe_vittucci 2008-07-07 20:06:50 UTC
Created attachment 54991 [details]
Screenshot English
Comment 7 giuseppe_vittucci 2008-07-07 20:11:16 UTC
The bug is still present in version 2.4.1.
I have attached two screenshots. The first one (screenshot italian) shows the
italian command (INTERESSI) needed to have the same result of the english
version (PPMT), although the right command in italian should be instead P.RATA.
Comment 8 Rob Weir 2013-02-02 02:56:18 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the
Comment 9 Andrea Pescetti 2014-06-21 09:25:56 UTC
Giuseppe, does the problem still exist with the latest version of OpenOffice (4.1.0, download from )? We can fix it in version 4.1.1 if needed.