Issue 76773

Summary: Commands reversal in the Italian version: P.RATA - INTERESSI
Product: Calc Reporter: giuseppe_vittucci <ignatiusreilly75>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, pescetti, rainerbielefeld_ooo_qa
Version: OOo 2.2Keywords: needhelp, needmoreinfo, oooqa
Target Milestone: ---   
Hardware: HP (PA-RISC)   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Description Flags
Screenshot Italian
Screenshot Italian
Screenshot English none

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.