fdo#85818: translate ZZR to Nper

Change-Id: Ib118d92a026526483da87dfe04871de25caa8ac1
Reviewed-on: https://gerrit.libreoffice.org/13869
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>

9 files changed, 12 insertions, 12 deletions

diff --git a/sc/source/core/inc/interpre.hxx b/sc/source/core/inc/interpre.hxx
index 3ae3fb67c7d8..6c7cd097a0d8 100644
--- a/sc/source/core/inc/interpre.hxx
+++ b/sc/source/core/inc/interpre.hxx
@@ -680,7 +680,7 @@ void ScRRI();
 double ScGetZw(double fZins, double fZzr, double fRmz,
                       double fBw, double fF);
 void ScFV();
-void ScZZR();
+void ScNper();
 bool RateIteration(double fNper, double fPayment, double fPv,
                                 double fFv, double fPayType, double& fGuess);
 void ScRate();
diff --git a/sc/source/core/opencl/formulagroupcl.cxx b/sc/source/core/opencl/formulagroupcl.cxx
index 22a59863df1d..94b0b2804a61 100644
--- a/sc/source/core/opencl/formulagroupcl.cxx
+++ b/sc/source/core/opencl/formulagroupcl.cxx
@@ -2722,7 +2722,7 @@ DynamicKernelSoPArguments::DynamicKernelSoPArguments(
                 mvSubArguments.push_back(SoPHelper(ts,
                         ft->Children[i], new OpKurt, nResultSize));
                 break;
-                /*case ocZZR:
+                /*case ocNper:
                     mvSubArguments.push_back(SoPHelper(ts,
                             ft->Children[i], new OpNper));
                      break;*/
diff --git a/sc/source/core/tool/interpr2.cxx b/sc/source/core/tool/interpr2.cxx
index f7224ae8e237..1114444fabdc 100644
--- a/sc/source/core/tool/interpr2.cxx
+++ b/sc/source/core/tool/interpr2.cxx
@@ -1527,7 +1527,7 @@ void ScInterpreter::ScFV()
     PushDouble(ScGetZw(nInterest, nZzr, nRmz, nBw, nFlag));
 }
 
-void ScInterpreter::ScZZR()
+void ScInterpreter::ScNper()
 {
     double nInterest, nRmz, nBw, nZw = 0, nFlag = 0;
     sal_uInt8 nParamCount = GetByte();
diff --git a/sc/source/core/tool/interpr4.cxx b/sc/source/core/tool/interpr4.cxx
index 0cdc0519430f..d1620fee30de 100644
--- a/sc/source/core/tool/interpr4.cxx
+++ b/sc/source/core/tool/interpr4.cxx
@@ -4037,7 +4037,7 @@ StackVar ScInterpreter::Interpret()
                 case ocTable            : ScTable();                    break;
                 case ocRRI              : ScRRI();                      break;
                 case ocFV               : ScFV();                       break;
-                case ocZZR              : ScZZR();                      break;
+                case ocNper             : ScNper();                     break;
                 case ocRate             : ScRate();                     break;
                 case ocFilterXML        : ScFilterXML();                break;
                 case ocWebservice       : ScWebservice();               break;
diff --git a/sc/source/core/tool/token.cxx b/sc/source/core/tool/token.cxx
index 8b4925bccd5d..0aa1f474020a 100644
--- a/sc/source/core/tool/token.cxx
+++ b/sc/source/core/tool/token.cxx
@@ -1205,7 +1205,7 @@ void ScTokenArray::CheckToken( const FormulaToken& r )
             case ocFV:
             case ocVBD:
             case ocKurt:
-            case ocZZR:
+            case ocNper:
             case ocNormDist:
             case ocArcCos:
             case ocSqrt:
diff --git a/sc/source/filter/excel/xlformula.cxx b/sc/source/filter/excel/xlformula.cxx
index 9742a538311c..5869f96e48bb 100644
--- a/sc/source/filter/excel/xlformula.cxx
+++ b/sc/source/filter/excel/xlformula.cxx
@@ -136,7 +136,7 @@ static const XclFunctionInfo saFuncTable_2[] =
     { ocGrowth,             52,     1,  3,  A, { RA, RA, RA, C }, 0, 0 },
     { ocPV,                 56,     3,  5,  V, { VR }, 0, 0 },
     { ocFV,                 57,     3,  5,  V, { VR }, 0, 0 },
-    { ocZZR,                58,     3,  5,  V, { VR }, 0, 0 },
+    { ocNper,               58,     3,  5,  V, { VR }, 0, 0 },
     { ocPMT,                59,     3,  5,  V, { VR }, 0, 0 },
     { ocRate,               60,     3,  6,  V, { VR }, 0, 0 },
     { ocMIRR,               61,     3,  3,  V, { RA, VR }, 0, 0 },
diff --git a/sc/source/filter/lotus/lotform.cxx b/sc/source/filter/lotus/lotform.cxx
index cc7f2b23fe6b..5feee2615fb6 100644
--- a/sc/source/filter/lotus/lotform.cxx
+++ b/sc/source/filter/lotus/lotform.cxx
@@ -137,7 +137,7 @@ void LotusToSc::DoFunc( DefTokenId eOc, sal_uInt8 nAnz, const sal_Char* pExtStri
             eParam[ 2 ] = n0Token;      //    -> 2. as Default
         }
             break;
-        case ocZZR:
+        case ocNper:
         {
             OSL_ENSURE( nAnz == 3,
                 "*LotusToSc::DoFunc(): TERM() or CTERM() need 3 parameters!" );
@@ -2052,9 +2052,9 @@ static DefTokenId lcl_KnownAddIn( const OString& rTest )
     else if (rTest == "CRITBINOMIAL")
             eId=ocKritBinom;
     else if (rTest == "TERM")
-            eId=ocZZR;
+            eId=ocNper;
     else if (rTest == "CTERM")
-            eId=ocZZR;
+            eId=ocNper;
     else if (rTest == "SUMIF")
             eId=ocSumIf;
     else if (rTest == "COUNTIF")
diff --git a/sc/source/filter/qpro/qproform.cxx b/sc/source/filter/qpro/qproform.cxx
index 1aae32125cab..14bf6c117a53 100644
--- a/sc/source/filter/qpro/qproform.cxx
+++ b/sc/source/filter/qpro/qproform.cxx
@@ -501,7 +501,7 @@ static const struct
     { ocPV, FT_FuncFix3 },  // QPro Pval
     { ocPMT, FT_FuncFix5 }, // QPro Paymt
     { ocFV, FT_FuncFix3 },  // QPro Fval   // 0x80
-    { ocZZR, FT_FuncFix5 },
+    { ocNper, FT_FuncFix5 },
     { ocRate, FT_FuncFix5 },
     { ocIpmt, FT_FuncFix4 },
     { ocPpmt, FT_FuncFix6 },
diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src
index dad0a043b1fd..cda12ba26833 100644
--- a/sc/source/ui/src/scfuncs.src
+++ b/sc/source/ui/src/scfuncs.src
@@ -1276,8 +1276,8 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS1
             Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ;
         };
     };
-     // -=*# Resource for function ZZR #*=-
-    Resource SC_OPCODE_ZZR
+     // -=*# Resource for function NPER #*=-
+    Resource SC_OPCODE_NPER
     {
         String 1 // Description
         {