include/svx/dialogs.hrc | 1 sc/inc/mid.hrc | 30 sc/inc/sc.hrc | 573 sc/inc/scabstdlg.hxx | 2 sc/inc/scfuncs.hrc | 2 sc/inc/scres.hrc | 553 sc/sdi/scslots.hrc | 1 sc/source/core/data/attrib.cxx | 1 sc/source/core/data/documen8.cxx | 2 sc/source/core/data/dpoutput.cxx | 2 sc/source/core/data/funcdesc.cxx | 111 sc/source/core/data/global.cxx | 2 sc/source/filter/html/htmlexp.cxx | 4 sc/source/ui/Accessibility/AccessibleCellBase.cxx | 2 sc/source/ui/Accessibility/AccessibleCsvControl.cxx | 2 sc/source/ui/Accessibility/AccessibleDocument.cxx | 2 sc/source/ui/Accessibility/AccessibleDocumentPagePreview.cxx | 2 sc/source/ui/Accessibility/AccessiblePageHeader.cxx | 2 sc/source/ui/Accessibility/AccessiblePageHeaderArea.cxx | 2 sc/source/ui/Accessibility/AccessiblePreviewHeaderCell.cxx | 2 sc/source/ui/Accessibility/AccessiblePreviewTable.cxx | 2 sc/source/ui/Accessibility/AccessibleSpreadsheet.cxx | 2 sc/source/ui/Accessibility/AccessibleTableBase.cxx | 2 sc/source/ui/StatisticsDialogs/StatisticsDialogs.src | 2 sc/source/ui/app/inputwin.cxx | 2 sc/source/ui/app/scmod.cxx | 94 sc/source/ui/app/typemap.cxx | 1 sc/source/ui/attrdlg/scdlgfact.cxx | 22 sc/source/ui/cctrl/checklistmenu.cxx | 2 sc/source/ui/cctrl/checklistmenu.src | 2 sc/source/ui/condformat/condformatdlgentry.cxx | 2 sc/source/ui/dbgui/asciiopt.hrc | 2 sc/source/ui/dbgui/consdlg.cxx | 2 sc/source/ui/dbgui/outline.src | 2 sc/source/ui/dbgui/pfiltdlg.cxx | 2 sc/source/ui/dbgui/pvfundlg.cxx | 2 sc/source/ui/dbgui/pvfundlg.src | 2 sc/source/ui/dbgui/scuiimoptdlg.cxx | 2 sc/source/ui/dbgui/tpsort.cxx | 2 sc/source/ui/dbgui/tpsubt.cxx | 2 sc/source/ui/dbgui/validate.cxx | 2 sc/source/ui/dialogs/searchresults.cxx | 2 sc/source/ui/docshell/docfunc.cxx | 2 sc/source/ui/docshell/docsh.cxx | 4 sc/source/ui/docshell/docsh4.cxx | 2 sc/source/ui/docshell/documentlinkmgr.cxx | 2 sc/source/ui/drawfunc/drawsh.cxx | 2 sc/source/ui/drawfunc/fuins1.cxx | 2 sc/source/ui/drawfunc/graphsh.cxx | 2 sc/source/ui/drawfunc/mediash.cxx | 2 sc/source/ui/inc/acredlin.hrc | 2 sc/source/ui/inc/condformatmgr.hxx | 2 sc/source/ui/inc/hfedtdlg.hxx | 2 sc/source/ui/inc/miscdlgs.hrc | 24 sc/source/ui/inc/reffact.hxx | 2 sc/source/ui/miscdlgs/autofmt.cxx | 4 sc/source/ui/miscdlgs/conflictsdlg.cxx | 2 sc/source/ui/miscdlgs/conflictsdlg.src | 2 sc/source/ui/miscdlgs/crdlg.cxx | 2 sc/source/ui/miscdlgs/delcldlg.cxx | 2 sc/source/ui/miscdlgs/delcodlg.cxx | 2 sc/source/ui/miscdlgs/filldlg.cxx | 2 sc/source/ui/miscdlgs/inscldlg.cxx | 2 sc/source/ui/miscdlgs/inscodlg.cxx | 2 sc/source/ui/miscdlgs/lbseldlg.cxx | 2 sc/source/ui/miscdlgs/mtrindlg.cxx | 2 sc/source/ui/miscdlgs/mvtabdlg.cxx | 2 sc/source/ui/miscdlgs/retypepassdlg.cxx | 2 sc/source/ui/miscdlgs/retypepassdlg.src | 2 sc/source/ui/miscdlgs/scuiautofmt.cxx | 4 sc/source/ui/miscdlgs/shtabdlg.cxx | 2 sc/source/ui/miscdlgs/tabbgcolordlg.cxx | 2 sc/source/ui/miscdlgs/warnbox.cxx | 2 sc/source/ui/namedlg/namepast.cxx | 2 sc/source/ui/navipi/content.cxx | 2 sc/source/ui/navipi/navipi.cxx | 2 sc/source/ui/navipi/navipi.src | 2 sc/source/ui/navipi/scenwnd.cxx | 2 sc/source/ui/optdlg/tpformula.cxx | 2 sc/source/ui/optdlg/tpview.cxx | 2 sc/source/ui/pagedlg/pagedlg.hrc | 2 sc/source/ui/sidebar/CellAppearancePropertyPanel.cxx | 2 sc/source/ui/sidebar/CellAppearancePropertyPanel.src | 2 sc/source/ui/src/globstr.src | 2 sc/source/ui/src/scfuncs.src |26116 +++++------ sc/source/ui/src/scstring.src | 2 sc/source/ui/src/toolbox.src | 2 sc/source/ui/styleui/scstyles.src | 2 sc/source/ui/styleui/styledlg.cxx | 2 sc/source/ui/undo/undotab.cxx | 2 sc/source/ui/unoobj/docuno.cxx | 2 sc/source/ui/unoobj/targuno.cxx | 2 sc/source/ui/view/drawvie3.cxx | 2 sc/source/ui/view/olinewin.cxx | 2 sc/source/ui/view/prevwsh.cxx | 2 sc/source/ui/view/tabvwsh4.cxx | 2 sc/source/ui/view/viewfunc.cxx | 2 97 files changed, 13821 insertions(+), 13884 deletions(-)
New commits: commit e0ecfb5055568424a1b65212983406a3aa6668d2 Author: Caolán McNamara <[email protected]> Date: Thu Feb 16 15:17:54 2017 +0000 nSuppressed is 0 in all existing patterns Change-Id: If1a85e157840753b48f830ba4cddf5708189575b diff --git a/sc/source/core/data/funcdesc.cxx b/sc/source/core/data/funcdesc.cxx index 8e8f31b..9c50709 100644 --- a/sc/source/core/data/funcdesc.cxx +++ b/sc/source/core/data/funcdesc.cxx @@ -779,7 +779,6 @@ sal_Unicode ScFunctionMgr::getSingleToken(const formula::IFunctionManager::EToke } // class ScFuncRes: - ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) : Resource(aRes) { @@ -816,42 +815,7 @@ ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) // Need to read the value from the resource even if nArgs==0 to advance the // resource position pointer, so this can't be in the if(nArgs) block above. sal_uInt16 nSuppressed = GetNum(); - if (nSuppressed) - { - if (nSuppressed > nArgs) - { - SAL_WARN("sc.core", "ScFuncRes: suppressed parameters count mismatch on OpCode " << - nOpCode << ": suppressed " << nSuppressed << " > params " << nArgs); - nSuppressed = nArgs; // sanitize - } - for (sal_uInt16 i = 0; i < nSuppressed; ++i) - { - sal_uInt16 nParam = GetNum(); - if (nParam < nArgs) - { - if (pDesc->nArgCount >= PAIRED_VAR_ARGS && nParam >= nArgs-2) - { - SAL_WARN("sc.core", "ScFuncRes: PAIRED_VAR_ARGS parameters can't be suppressed, on OpCode " << - nOpCode << ": param " << nParam << " >= arg " << nArgs << "-2"); - } - else if (pDesc->nArgCount >= VAR_ARGS && nParam == nArgs-1) - { - SAL_WARN("sc.core", "ScFuncRes: VAR_ARGS parameters can't be suppressed, on OpCode " << - nOpCode << ": param " << nParam << " == arg " << nArgs << "-1"); - } - else - { - pDesc->pDefArgFlags[nParam].bSuppress = true; - pDesc->bHasSuppressedArgs = true; - } - } - else - { - SAL_WARN("sc.core", "ScFuncRes: suppressed parameter exceeds count on OpCode " << - nOpCode << ": param " << nParam << " >= args " << nArgs); - } - } - } + assert(!nSuppressed); (void)nSuppressed; pDesc->pFuncName = new OUString(ScCompiler::GetNativeSymbol(static_cast<OpCode>(nOpCode))); pDesc->pFuncDesc = new OUString( SC_RESSTR(1) ); commit d698f823c31583cd36dad594d585849dbccbbb4a Author: Caolán McNamara <[email protected]> Date: Thu Feb 16 14:09:00 2017 +0000 unwind one level of RID_SC_FUNCTION_DESCRIPTIONS[1|2] Change-Id: I9f812da7191246e236c1a83f0bf3d8ea3307b580 diff --git a/sc/inc/sc.hrc b/sc/inc/sc.hrc index 83a13ba..65ce618 100644 --- a/sc/inc/sc.hrc +++ b/sc/inc/sc.hrc @@ -694,8 +694,6 @@ #define WID_SIMPLE_REF (SC_RESOURCE_START+20) #define RID_ERRHDLSC (SC_RESOURCE_START+23) #define RID_OBJECTBAR_TOOLS (SC_RESOURCE_START+35) -#define RID_SC_FUNCTION_DESCRIPTIONS1 (SC_RESOURCE_START+43) -#define RID_SC_FUNCTION_DESCRIPTIONS2 (SC_RESOURCE_START+44) #define RID_DRAW_OBJECTBAR (SC_RESOURCE_START+53) #define RID_GRAPHIC_OBJECTBAR (SC_RESOURCE_START+54) #define RID_MEDIA_OBJECTBAR (SC_RESOURCE_START+60) diff --git a/sc/inc/scres.hrc b/sc/inc/scres.hrc index 199ee3f..51fd648 100644 --- a/sc/inc/scres.hrc +++ b/sc/inc/scres.hrc @@ -21,6 +21,7 @@ #define SC_SCRES_HRC #include "sc.hrc" +#include "formula/compiler.hrc" #define STR_START (SC_RESOURCE_START+100) #define STR_ROWHEIGHT (STR_START) @@ -538,9 +539,14 @@ #define WID_CONDFRMT_REF (SC_DIALOGS_START + 163) +//put new things here and adjust SC_DIALOGS_END to match + #define SC_DIALOGS_END (WID_CONDFRMT_REF + 1) -#define RID_GLOBSTR_OFFSET SC_DIALOGS_END +#define RID_SC_FUNC_DESCRIPTIONS_START SC_DIALOGS_END +#define RID_SC_FUNC_DESCRIPTIONS_END (RID_SC_FUNC_DESCRIPTIONS_START + SC_OPCODE_LAST_OPCODE_ID + 1) + +#define RID_GLOBSTR_OFFSET (RID_SC_FUNC_DESCRIPTIONS_END + 1) #endif diff --git a/sc/source/core/data/funcdesc.cxx b/sc/source/core/data/funcdesc.cxx index b0c2671..8e8f31b 100644 --- a/sc/source/core/data/funcdesc.cxx +++ b/sc/source/core/data/funcdesc.cxx @@ -46,18 +46,7 @@ private: sal_uInt16 GetNum(); }; -class ScResourcePublisher : public Resource -{ -private: - using Resource::FreeResource; -public: - explicit ScResourcePublisher( const ScResId& rId ) : Resource( rId ) {} - ~ScResourcePublisher() { FreeResource(); } - using Resource::IsAvailableRes; -}; - // class ScFuncDesc: - ScFuncDesc::ScFuncDesc() : pFuncName (nullptr), pFuncDesc (nullptr), @@ -391,49 +380,40 @@ bool ScFuncDesc::compareByName(const ScFuncDesc* a, const ScFuncDesc* b) // class ScFunctionList: -ScFunctionList::ScFunctionList() : - nMaxFuncNameLen ( 0 ) +ScFunctionList::ScFunctionList() + : nMaxFuncNameLen(0) { ScFuncDesc* pDesc = nullptr; sal_Int32 nStrLen = 0; ::std::list<ScFuncDesc*> tmpFuncList; - sal_uInt16 nDescBlock[] = - { - RID_SC_FUNCTION_DESCRIPTIONS1, - RID_SC_FUNCTION_DESCRIPTIONS2 - }; - for (sal_uInt16 k : nDescBlock) + // Browse for all possible OpCodes. This is not the fastest method, but + // otherwise the sub resources within the resource blocks and the + // resource blocks themselves would had to be ordered according to + // OpCodes, which is utopian... + for (sal_uInt16 i = 0; i <= SC_OPCODE_LAST_OPCODE_ID; ++i) { - std::unique_ptr<ScResourcePublisher> pBlock( new ScResourcePublisher( ScResId( k ) ) ); - // Browse for all possible OpCodes. This is not the fastest method, but - // otherwise the sub resources within the resource blocks and the - // resource blocks themselves would had to be ordered according to - // OpCodes, which is utopian... - for (sal_uInt16 i = 0; i <= SC_OPCODE_LAST_OPCODE_ID; ++i) + ScResId aRes(RID_SC_FUNC_DESCRIPTIONS_START + i); + aRes.SetRT(RSC_RESOURCE); + // Sub resource of OpCode available? + if (SC_MOD()->GetResMgr()->IsAvailable(aRes)) { - ScResId aRes(i); - aRes.SetRT(RSC_RESOURCE); - // Sub resource of OpCode available? - if (pBlock->IsAvailableRes(aRes)) + pDesc = new ScFuncDesc; + bool bSuppressed = false; + ScFuncRes aSubRes( aRes, pDesc, bSuppressed); + // Instead of dealing with this exceptional case at 1001 places + // we simply don't add an entirely suppressed function to the + // list and delete it. + if (bSuppressed) + delete pDesc; + else { - pDesc = new ScFuncDesc; - bool bSuppressed = false; - ScFuncRes aSubRes( aRes, pDesc, bSuppressed); - // Instead of dealing with this exceptional case at 1001 places - // we simply don't add an entirely suppressed function to the - // list and delete it. - if (bSuppressed) - delete pDesc; - else - { - pDesc->nFIndex = i; - tmpFuncList.push_back(pDesc); + pDesc->nFIndex = i; + tmpFuncList.push_back(pDesc); - nStrLen = (*(pDesc->pFuncName)).getLength(); - if (nStrLen > nMaxFuncNameLen) - nMaxFuncNameLen = nStrLen; - } + nStrLen = (*(pDesc->pFuncName)).getLength(); + if (nStrLen > nMaxFuncNameLen) + nMaxFuncNameLen = nStrLen; } } } @@ -803,6 +783,7 @@ sal_Unicode ScFunctionMgr::getSingleToken(const formula::IFunctionManager::EToke ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) : Resource(aRes) { + const sal_uInt16 nOpCode = aRes.GetId() - RID_SC_FUNC_DESCRIPTIONS_START; sal_uInt16 nFunctionFlags = GetNum(); // Bit 1: entirely suppressed // Bit 2: hidden unless used @@ -840,7 +821,7 @@ ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) if (nSuppressed > nArgs) { SAL_WARN("sc.core", "ScFuncRes: suppressed parameters count mismatch on OpCode " << - aRes.GetId() << ": suppressed " << nSuppressed << " > params " << nArgs); + nOpCode << ": suppressed " << nSuppressed << " > params " << nArgs); nSuppressed = nArgs; // sanitize } for (sal_uInt16 i = 0; i < nSuppressed; ++i) @@ -851,12 +832,12 @@ ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) if (pDesc->nArgCount >= PAIRED_VAR_ARGS && nParam >= nArgs-2) { SAL_WARN("sc.core", "ScFuncRes: PAIRED_VAR_ARGS parameters can't be suppressed, on OpCode " << - aRes.GetId() << ": param " << nParam << " >= arg " << nArgs << "-2"); + nOpCode << ": param " << nParam << " >= arg " << nArgs << "-2"); } else if (pDesc->nArgCount >= VAR_ARGS && nParam == nArgs-1) { SAL_WARN("sc.core", "ScFuncRes: VAR_ARGS parameters can't be suppressed, on OpCode " << - aRes.GetId() << ": param " << nParam << " == arg " << nArgs << "-1"); + nOpCode << ": param " << nParam << " == arg " << nArgs << "-1"); } else { @@ -867,12 +848,12 @@ ScFuncRes::ScFuncRes( ResId &aRes, ScFuncDesc* pDesc, bool & rbSuppressed ) else { SAL_WARN("sc.core", "ScFuncRes: suppressed parameter exceeds count on OpCode " << - aRes.GetId() << ": param " << nParam << " >= args " << nArgs); + nOpCode << ": param " << nParam << " >= args " << nArgs); } } } - pDesc->pFuncName = new OUString( ScCompiler::GetNativeSymbol( static_cast<OpCode>( aRes.GetId()))); + pDesc->pFuncName = new OUString(ScCompiler::GetNativeSymbol(static_cast<OpCode>(nOpCode))); pDesc->pFuncDesc = new OUString( SC_RESSTR(1) ); if (nArgs) diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src index 85e98ee..01d1dae7 100644 --- a/sc/source/ui/src/scfuncs.src +++ b/sc/source/ui/src/scfuncs.src @@ -19,10 +19,6 @@ /* Resource file for the function wizard / autopilot. * - * All descriptions of functions are collected within the resources - * RID_SC_FUNCTION_DESCRIPTIONS1 respectively RID_SC_FUNCTION_DESCRIPTIONS2, - * two blocks because otherwise we had a 64kb overflow. - * * For every function there is a sub resource with the number of the OpCode of * the function. * @@ -74,13085 +70,13079 @@ #include "scfuncs.hrc" #include "formula/compiler.hrc" -Resource RID_SC_FUNCTION_DESCRIPTIONS1 -{ - // -=*# Resource for function DCOUNT #*=- - Resource SC_OPCODE_DB_COUNT - { - String 1 // Description - { - Text [ en-US ] = "Counts the cells of a data range whose contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBANZAHL; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DCOUNTA #*=- - Resource SC_OPCODE_DB_COUNT_2 - { - String 1 // Description - { - Text [ en-US ] = "Counts all non-blank cells of a data range where the content corresponds to the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBANZAHL2; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DAVERAGE #*=- - Resource SC_OPCODE_DB_AVERAGE - { - String 1 // Description - { - Text [ en-US ] = "Returns the average value of all the cells of a data range whose contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBMITTELWERT; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DGET #*=- - Resource SC_OPCODE_DB_GET - { - String 1 // Description - { - Text [ en-US ] = "Defines the contents of the cell of a data range which matches the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBAUSZUG; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DMAX #*=- - Resource SC_OPCODE_DB_MAX - { - String 1 // Description - { - Text [ en-US ] = "Returns the maximum value from all of the cells of a data range which correspond to the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBMAX; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DMIN #*=- - Resource SC_OPCODE_DB_MIN - { - String 1 // Description - { - Text [ en-US ] = "Returns the minimum of all cells of a data range where the contents correspond to the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBMIN; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DPRODUCT #*=- - Resource SC_OPCODE_DB_PRODUCT - { - String 1 // Description - { - Text [ en-US ] = "Multiplies all cells of a data range where the contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBPRODUKT; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DSTDEV #*=- - Resource SC_OPCODE_DB_STD_DEV - { - String 1 // Description - { - Text [ en-US ] = "Calculates the standard deviation of all cells in a data range whose contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBSTDABW; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DSTDEVP #*=- - Resource SC_OPCODE_DB_STD_DEV_P - { - String 1 // Description - { - Text [ en-US ] = "Returns the standard deviation with regards to the population of all cells of a data range matching the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBSTDABWN; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DSUM #*=- - Resource SC_OPCODE_DB_SUM - { - String 1 // Description - { - Text [ en-US ] = "Adds all the cells of a data range where the contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBSUMME; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DVAR #*=- - Resource SC_OPCODE_DB_VAR - { - String 1 // Description - { - Text [ en-US ] = "Determines the variance of all the cells in a data range where the contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBVARIANZ; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DVARP #*=- - Resource SC_OPCODE_DB_VAR_P - { - String 1 // Description - { - Text [ en-US ] = "Determines variance of a population based on all cells in a data range where contents match the search criteria." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATABASE; - HID_FUNC_DBVARIANZEN; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Database" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The range of cells containing data." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Database field" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates which database field (column) is to be used for the search criteria." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Search criteria" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Defines the cell range containing the search criteria." ; - }; - }; - // -=*# Resource for function DATE #*=- - Resource SC_OPCODE_GET_DATE - { - String 1 // Description - { - Text [ en-US ] = "Provides an internal number for the date given." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_DATUM; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "year" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "An integer between 1583 and 9956 or 0 and 99 (19xx or 20xx depending on the defined option)." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "month" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "An integer between 1 and 12 representing the month." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "day" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "An integer between 1 and 31 representing the day of the month." ; - }; - }; - // -=*# Resource for function DATE_VALUE #*=- - Resource SC_OPCODE_GET_DATE_VALUE - { - String 1 // Description - { - Text [ en-US ] = "Returns an internal number for a text having a possible date format." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_DATWERT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "text" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "A text enclosed in quotation marks which returns a date in a %PRODUCTNAME date format." ; - }; - }; - // -=*# Resource for function DAY #*=- - Resource SC_OPCODE_GET_DAY - { - String 1 // Description - { - Text [ en-US ] = "Returns the sequential date of the month as an integer (1-31) in relation to the date value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_TAG; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number for the date." ; - }; - }; - // -=*# Resource for function DAYS360 #*=- - Resource SC_OPCODE_GET_DIFF_DATE_360 - { - String 1 // Description - { - Text [ en-US ] = "Calculates the number of days between two dates based on a 360-day year." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_TAGE360; - 3; 0; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Date_1" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The start date for calculating the difference in days." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Date_2" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The end date for calculating the difference in days." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Type" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Method used to form differences: Type = 0 denotes US method (NASD), Type = 1 denotes the European method." ; - }; - }; - // -=*# Resource for function NETWORKDAYS #*=- - Resource SC_OPCODE_NETWORKDAYS - { - String 1 // Description - { - Text [ en-US ] = "Returns the number of workdays between two dates using arguments to indicate weekenddays and holidays." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_NETWORKDAYS; - 4; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Start Date" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Start date for calculation." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "End Date" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "End date for calculation." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "list of dates" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Optional set of one or more dates to be considered as holiday." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "array" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Optional list of numbers to indicate working (0) and weekend (non-zero) days. When omitted, weekend is Saturday and Sunday." ; - }; - }; - // -=*# Resource for function NETWORKDAYS.INTL #*=- - Resource SC_OPCODE_NETWORKDAYS_MS - { - String 1 // Description - { - Text [ en-US ] = "Returns the number of workdays between two dates using arguments to indicate weekend days and holidays." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_NETWORKDAYS_MS; - 4; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Start Date" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Start date for calculation." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "End Date" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "End date for calculation." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "number or string" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "array" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Optional set of one or more dates to be considered as holiday." ; - }; - }; - // -=*# Resource for function WORKDAY.INTL #*=- - Resource SC_OPCODE_WORKDAY_MS - { - String 1 // Description - { - Text [ en-US ] = "Returns the serial number of the date before or after a number of workdays using arguments to indicate weekend days and holidays." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_WORKDAY_MS; - 4; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Start Date" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Start date for calculation." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Days" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The number of workdays before or after start date." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "number or string" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Optional number or string to indicate when weekends occur. When omitted, weekend is Saturday and Sunday." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "array" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Optional set of one or more dates to be considered as holiday." ; - }; - }; - // -=*# Resource for function HOUR #*=- - Resource SC_OPCODE_GET_HOUR - { - String 1 // Description - { - Text [ en-US ] = "Determines the sequential number of the hour of the day (0-23) for the time value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_STUNDE; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Internal time value" ; - }; - }; - // -=*# Resource for function MINUTE #*=- - Resource SC_OPCODE_GET_MIN - { - String 1 // Description - { - Text [ en-US ] = "Determines the sequential number for the minute of the hour (0-59) for the time value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_MINUTE; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Internal time value." ; - }; - }; - // -=*# Resource for function MONTH #*=- - Resource SC_OPCODE_GET_MONTH - { - String 1 // Description - { - Text [ en-US ] = "Determines the sequential number of a month of the year (1-12) for the date value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_MONAT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number of the date." ; - }; - }; - // -=*# Resource for function NOW #*=- - Resource SC_OPCODE_GET_ACT_TIME - { - String 1 // Description - { - Text [ en-US ] = "Determines the current time of the computer." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_JETZT; - 0; - 0; - }; - }; - // -=*# Resource for function SECOND #*=- - Resource SC_OPCODE_GET_SEC - { - String 1 // Description - { - Text [ en-US ] = "Determines the sequential number of the second of a minute (0-59) for the time value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_SEKUNDE; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal time value." ; - }; - }; - // -=*# Resource for function TIME #*=- - Resource SC_OPCODE_GET_TIME - { - String 1 // Description - { - Text [ en-US ] = "Determines a time value from the details for hour, minute and second." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_ZEIT; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "hour" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The integer for the hour." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "minute" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The integer for the minute." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "second" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The integer for the second." ; - }; - }; - // -=*# Resource for function TIMEVALUE #*=- - Resource SC_OPCODE_GET_TIME_VALUE - { - String 1 // Description - { - Text [ en-US ] = "Returns a sequential number for a text shown in a possible time entry format." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_ZEITWERT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "text" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "A text enclosed in quotation marks which returns a time in a %PRODUCTNAME time format." ; - }; - }; - // -=*# Resource for function TODAY #*=- - Resource SC_OPCODE_GET_ACT_DATE - { - String 1 // Description - { - Text [ en-US ] = "Determines the current date of the computer." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_HEUTE; - 0; - 0; - }; - }; - // -=*# Resource for function WEEKDAY #*=- - Resource SC_OPCODE_GET_DAY_OF_WEEK - { - String 1 // Description - { - Text [ en-US ] = "Returns the day of the week for the date value as an integer." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_WOCHENTAG; - 2; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number for the date." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Type" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Fixes the beginning of the week and the type of calculation to be used." ; - }; - }; - // -=*# Resource for function YEAR #*=- - Resource SC_OPCODE_GET_YEAR - { - String 1 // Description - { - Text [ en-US ] = "Returns the year of a date value as an integer." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_JAHR; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Internal number of the date." ; - }; - }; - // -=*# Resource for function DAYS #*=- - Resource SC_OPCODE_GET_DIFF_DATE - { - String 1 // Description - { - Text [ en-US ] = "Calculates the number of days between two dates." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_TAGE; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Date_2" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The end date for calculating the difference in days." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Date_1" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The start date for calculating the difference in days." ; - }; - }; - // -=*# Resource for function DATEDIF #*=- - Resource SC_OPCODE_GET_DATEDIF - { - String 1 // description - { - Text [ en-US ] = "Returns the number of whole days, months or years between 'start date' and 'end date'."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_DATEDIF; - 3; 0; 0; 0; - 0; - }; - - String 2 // name of parameter 1 DateDif - { - Text [ en-US ] = "Start date"; - }; - - String 3 // description of parameter 1 DateDif - { - Text [ en-US ] = "The start date."; - }; - - String 4 // name of parameter 2 DateDif - { - Text [ en-US ] = "End date"; - }; - - String 5 // description of parameter 2 DateDif - { - Text [ en-US ] = "The end date."; - }; - - String 6 // name of parameter 3 DateDif - { - Text [ en-US ] = "Interval"; - }; - - String 7 // description of parameter 3 DateDif - { - Text [ en-US ] = "Interval to be calculated. Can be \"d\", \"m\", \"y\", \"ym\", \"md\" or \"yd\"."; - }; - }; - // -=*# Resource for function WEEKNUM #*=- - Resource SC_OPCODE_WEEK - { - String 1 // Description - { - Text [ en-US ] = "Calculates the calendar week corresponding to the given date." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_KALENDERWOCHE; - 2; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number of the date." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "mode" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates the first day of the week and when week 1 starts." ; - }; - }; - // -=*# Resource for function ISOWEEKNUM #*=- - Resource SC_OPCODE_ISOWEEKNUM - { - String 1 // Description - { - Text [ en-US ] = "Calculates the ISO 8601 calendar week for the given date." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_ISOWEEKNUM; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number of the date." ; - }; - }; - Resource SC_OPCODE_WEEKNUM_OOO - { - String 1 // Description - { - Text [ en-US ] = "Calculates the calendar week corresponding to the given date.\nThis function only provides interoperability with %PRODUCTNAME 5.0 and earlier and OpenOffice.org." ; - }; - ExtraData = - { - 2; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_WEEKNUM_OOO; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Number" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The internal number of the date." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "mode" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Indicates the first day of the week (1 = Sunday, other values = Monday)." ; - }; - }; - // -=*# Resource for function EASTERSUNDAY #*=- - Resource SC_OPCODE_EASTERSUNDAY - { - String 1 // Description - { - Text [ en-US ] = "Calculates the date of Easter Sunday in a given year."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_DATETIME; - HID_FUNC_OSTERSONNTAG; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "year"; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "An integer between 1583 and 9956, or 0 and 99 (19xx or 20xx depending on the option set)."; - }; - }; - // -=*# Resource for function PV #*=- - Resource SC_OPCODE_PV - { - String 1 // Description - { - Text [ en-US ] = "Present value. Calculates the present value of an investment." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_BW; - 5; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest for the period given." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "NPER" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The payment period. The total number of periods in which the annuity is paid." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PMT" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Regular payments. The constant amount of annuity that is paid in each period." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "FV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Future value. The value (final value) to be attained after the last payment." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Type" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function FV #*=- - Resource SC_OPCODE_FV - { - String 1 // Description - { - Text [ en-US ] = "Future value. Returns the future value of an investment based on regular payments and a constant interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ZW; - 5; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "NPER" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PMT" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "PV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Present value. The current value of a series of payments" ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Type" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function NPER #*=- - Resource SC_OPCODE_NPER - { - String 1 // Description - { - Text [ en-US ] = "Payment period. Calculates the number of payment periods for an investment based on regular payments and a constant interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ZZR; - 5; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "PMT" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Present value. The current value of a series of payments" ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "FV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Type" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function PMT #*=- - Resource SC_OPCODE_PMT - { - String 1 // Description - { - Text [ en-US ] = "Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_RMZ; - 5; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "NPER" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Present value. The current value of a series of payments" ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "FV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Type" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function RATE #*=- - Resource SC_OPCODE_RATE - { - String 1 // Description - { - Text [ en-US ] = "Calculates the constant interest rate of an investment with regular payments." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ZINS; - 6; 0; 0; 0; 1; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "NPER" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "PMT" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Regular payments. The constant annuity to be paid in each period." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Present value. The current value of a series of payments" ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "FV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Type" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Guess" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Guess. The estimate of the interest rate for the iterative calculating method." ; - }; - }; - // -=*# Resource for function IPMT #*=- - Resource SC_OPCODE_IPMT - { - String 1 // Description - { - Text [ en-US ] = "Compounded interest. Calculates the interest payment on the principal for an investment with regular payments and a constant interest rate for a given period." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ZINSZ; - 6; 0; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Period" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Periods. The periods for which the compounded interest is to be calculated. P = 1 denotes for the first period, P = NPER for the last one." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "NPER" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "pv" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Present value. The current value of a series of payments" ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "FV" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Future value. The value (end value) to be attained after the final payment." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Type" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function PPMT #*=- - Resource SC_OPCODE_PPMT - { - String 1 // Description - { - Text [ en-US ] = "Repayment. Calculates the repayment amount for a period for an investment whereby the payments are at regular intervals and the interest rate constant." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_KAPZ; - 6; 0; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The interest rate per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Period" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Period. The period for which the repayments are to be calculated. Per = 1 denotes for the first period, P = NPER for the last" ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "NPER" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "PV" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "FV" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Future value. The value (end value) attained after the last payment has been made." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Type" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function CUMPRINC #*=- - Resource SC_OPCODE_CUM_PRINC - { - String 1 // Description - { - Text [ en-US ] = "Cumulative Capital. Calculates the total amount of the repayment share in a period for an investment with constant interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_KUMKAPITAL; - 6; 0; 0; 0; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "NPER" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "PV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "S" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "The start period. The first period to be taken into account. S = 1 denotes the very first period." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "E" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "End period. The last period to be taken into account." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Type" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function CUMIPMT #*=- - Resource SC_OPCODE_CUM_IPMT - { - String 1 // Description - { - Text [ en-US ] = "Cumulative compounded interest. Calculates the total amount of the interest share in a period for an investment with a constant interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_KUMZINSZ; - 6; 0; 0; 0; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of interest per period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "NPER" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Payment period. The total number of periods in which the annuity (pension) is paid." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "pv" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The present value. The present value or the amount the annuity is currently worth." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "S" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "The start period. The first period to be taken into account. S = 1 denotes the very first period." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "E" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "The end period. The last period to be taken into account." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Type" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Type = 1 denotes due at the beginning of the period, = 0 at the end." ; - }; - }; - // -=*# Resource for function SYD #*=- - Resource SC_OPCODE_SYD - { - String 1 // Description - { - Text [ en-US ] = "Calculates the arithmetically declining value of an asset (depreciation) for a specified period." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_DIA; - 4; 0; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Cost" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Acquisition costs. The initial cost of the asset." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Salvage" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Life" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "Period" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Period. The depreciation period which must have the same time unit as average useful life." ; - }; - }; - // -=*# Resource for function SLN #*=- - Resource SC_OPCODE_SLN - { - String 1 // Description - { - Text [ en-US ] = "Calculates the linear depreciation per period." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_LIA; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Cost" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Acquisition cost. The initial cost of an asset." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Salvage" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Life" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ; - }; - }; - // -=*# Resource for function DDB #*=- - Resource SC_OPCODE_DDB - { - String 1 // Description - { - Text [ en-US ] = "Calculates the depreciation of an asset for a specific period using the double-declining balance method or declining balance factor." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_GDA; - 5; 0; 0; 0; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Cost" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Acquisition costs. The initial cost of the asset." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Salvage" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Life" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "Period" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Period. The depreciation period in the same time unit as the average useful life entry." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "Factor" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Factor. The factor for balance decline. F = 2 means a double declining balance factor" ; - }; - }; - // -=*# Resource for function DB #*=- - Resource SC_OPCODE_DB - { - String 1 // Description - { - Text [ en-US ] = "Returns the real depreciation of an asset for a specified period using the fixed-declining balance method." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_GDA2; - 5; 0; 0; 0; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Cost" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Acquisition costs: The initial cost of the asset." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Salvage" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Salvage: The remaining value of the asset at the end of its life." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Life" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "Period" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Periods: The period for which the depreciation is calculated. The time unit used for period must be the same as that for the useful life." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "month" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "Months: The number of months in the first year of depreciation." ; - }; - }; - // -=*# Resource for function VDB #*=- - Resource SC_OPCODE_VBD - { - String 1 // Description - { - Text [ en-US ] = "Variable declining balance. Returns the declining balance depreciation for a particular period." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_VDB; - 7; 0; 0; 0; 0; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Cost" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Cost. The initial cost of the asset." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Salvage" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Salvage. The salvage value of an asset at the end of its useful life." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Life" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Useful life. The number of periods in the useful life of the asset." ; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "S" ; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Start. The first period for depreciation in the same time unit as the useful life." ; - }; - String 10 // Name of Parameter 5 - { - Text [ en-US ] = "end" ; - }; - String 11 // Description of Parameter 5 - { - Text [ en-US ] = "End. The last period of the depreciation using the same time unit as for the useful life." ; - }; - String 12 // Name of Parameter 6 - { - Text [ en-US ] = "Factor" ; - }; - String 13 // Description of Parameter 6 - { - Text [ en-US ] = "Factor. The factor for the reduction of the depreciation. F = 2 denotes double rate depreciation." ; - }; - String 14 // Name of Parameter 7 - { - Text [ en-US ] = "Type" ; - }; - String 15 // Description of Parameter 7 - { - Text [ en-US ] = "Do not alter. Type = 1 denotes switch to linear depreciation, type = 0 do not switch." ; - }; - }; - // -=*# Resource for function EFFECT #*=- - Resource SC_OPCODE_EFFECT - { - String 1 // Description - { - Text [ en-US ] = "Calculates the annual net interest rate for a nominal interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_EFFEKTIV; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "NOM" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Nominal Interest" ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "P" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Periods. The number of interest payments per year." ; - }; - }; - // -=*# Resource for function NOMINAL #*=- - Resource SC_OPCODE_NOMINAL - { - String 1 // Description - { - Text [ en-US ] = "Calculates the yearly nominal interest rate as an effective interest rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_NOMINAL; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "effect_rate" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The effective interest rate" ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "npery" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Periods. The number of interest payment per year." ; - }; - }; - // -=*# Resource for function NPV #*=- - Resource SC_OPCODE_NPV - { - String 1 // Description - { - Text [ en-US ] = "Net present value. Calculates the net present value of an investment based on a series of periodic payments and a discount rate." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_NBW; - VAR_ARGS+1; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "RATE" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The rate of discount for one period." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "value " ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Value 1, value 2,... are 1 to 30 arguments representing payments and income." ; - }; - }; - // -=*# Resource for function IRR #*=- - Resource SC_OPCODE_IRR - { - String 1 // Description - { - Text [ en-US ] = "Returns the actuarial rate of interest of an investment excluding costs or profits." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_IKV; - 2; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Values" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "An array or reference to cells whose contents correspond to the payments. " ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Guess" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Guess. An estimated value of the rate of return to be used for the iteration calculation." ; - }; - }; - // -=*# Resource for function MIRR #*=- - Resource SC_OPCODE_MIRR - { - String 1 // Description - { - Text [ en-US ] = "Returns the modified internal rate of return for a series of investments."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_QIKV; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Values"; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "An array or reference to cells whose contents correspond to the payments."; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "investment"; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Interest rate for investments (the negative values in the array)."; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "reinvest_rate"; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "interest rate for reinvestments (the positive values in the array)."; - }; - }; - // -=*# Resource for function ISPMT #*=- - Resource SC_OPCODE_ISPMT - { - String 1 // Description - { - Text [ en-US ] = "Returns the amount of interest for constant amortization rates."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ISPMT; - 4; 0; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "rate"; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Interest rate for a single amortization rate."; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Period"; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Number of amortization periods for the calculation of the interest."; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "total_periods"; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "Sum total of amortization periods."; - }; - String 8 // Name of Parameter 4 - { - Text [ en-US ] = "invest"; - }; - String 9 // Description of Parameter 4 - { - Text [ en-US ] = "Amount of the investment."; - }; - }; - // -=*# Resource for function PDURATION #*=- - Resource SC_OPCODE_PDURATION - { - String 1 // Description - { - Text [ en-US ] = "Duration. Calculates the number of periods required by an investment to attain the desired value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_LAUFZEIT; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "RATE" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The constant rate of interest." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "pv" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The present value. The current value of the investment." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "FV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The future value of the investment." ; - }; - }; - // -=*# Resource for function RRI #*=- - Resource SC_OPCODE_RRI - { - String 1 // Description - { - Text [ en-US ] = "Interest. Calculates the interest rate which represents the rate of return from an investment." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_FINANZ; - HID_FUNC_ZGZ; - 3; 0; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "P" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The number of periods used in the calculation." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "pv" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "Present value. The current value of the investment." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "FV" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The future value of the investment." ; - }; - }; - // -=*# Resource for function ISREF #*=- - Resource SC_OPCODE_IS_REF - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if value is a reference." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTBEZUG; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISERR #*=- - Resource SC_OPCODE_IS_ERR - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if the value is an error value not equal to #N/A." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTFEHL; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISERROR #*=- - Resource SC_OPCODE_IS_ERROR - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if the value is an error value." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTFEHLER; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISBLANK #*=- - Resource SC_OPCODE_IS_EMPTY - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if value refers to an empty cell." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTLEER; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISLOGICAL #*=- - Resource SC_OPCODE_IS_LOGICAL - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if the value carries a logical number format." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTLOG; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISNA #*=- - Resource SC_OPCODE_IS_NV - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if value equals #N/A." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTNV; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISNONTEXT #*=- - Resource SC_OPCODE_IS_NON_STRING - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if the value is not text." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTKTEXT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISTEXT #*=- - Resource SC_OPCODE_IS_STRING - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if value is text." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTTEXT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISNUMBER #*=- - Resource SC_OPCODE_IS_VALUE - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if value is a number." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTZAHL; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be tested." ; - }; - }; - // -=*# Resource for function ISFORMULA #*=- - Resource SC_OPCODE_IS_FORMULA - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if the cell is a formula cell." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ISTFORMEL; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "reference" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The cell to be checked." ; - }; - }; - // -=*# Resource for function FORMULA #*=- - Resource SC_OPCODE_FORMULA - { - String 1 // Description - { - Text [ en-US ] = "Returns the formula of a formula cell."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_FORMEL; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Reference"; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The formula cell."; - }; - }; - // -=*# Resource for function N #*=- - Resource SC_OPCODE_N - { - String 1 // Description - { - Text [ en-US ] = "Converts a value to a number." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_N; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be interpreted as a number." ; - }; - }; - // -=*# Resource for function NA #*=- - Resource SC_OPCODE_NO_VALUE - { - String 1 // Description - { - Text [ en-US ] = "Not available. Returns the error value #N/A." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_NV; - 0; - 0; - }; - }; - // -=*# Resource for function TYPE #*=- - Resource SC_OPCODE_TYPE - { - String 1 // Description - { - Text [ en-US ] = "Returns the data type of a value (1 = number, 2 = text, 4 = Boolean value, 8 = formula, 16 = error value, 64 = array)." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_TYP; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value for which the data type is to be determined." ; - }; - }; - // -=*# Resource for function CELL #*=- - Resource SC_OPCODE_CELL - { - String 1 // Description - { - Text [ en-US ] = "Determines information about address, formatting or contents of a cell."; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_ZELLE; - 2; 0; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "info_type"; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "String that specifies the type of information."; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Reference"; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The position of the cell you want to examine."; - }; - }; - // -=*# Resource for function CURRENT #*=- - Resource SC_OPCODE_CURRENT - { - String 1 // Description - { - Text [ en-US ] = "Calculates the current value of the formula at the present location. " ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_INFO; - HID_FUNC_AKTUELL; - 0; - 0; - }; - }; - // -=*# Resource for function FALSE #*=- - Resource SC_OPCODE_FALSE - { - String 1 // Description - { - Text [ en-US ] = "Defines the logical value as FALSE." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_FALSCH; - 0; - 0; - }; - }; - // -=*# Resource for function NOT #*=- - Resource SC_OPCODE_NOT - { - String 1 // Description - { - Text [ en-US ] = "Reverses the value of the argument." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_NICHT; - 1; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Logical value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "An expression that can be either TRUE or FALSE." ; - }; - }; - // -=*# Resource for function TRUE #*=- - Resource SC_OPCODE_TRUE - { - String 1 // Description - { - Text [ en-US ] = "Returns the logical value TRUE." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_WAHR; - 0; - 0; - }; - }; - // -=*# Resource for function IF #*=- - Resource SC_OPCODE_IF - { - String 1 // Description - { - Text [ en-US ] = "Specifies a logical test to be performed." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_WENN; - 3; 0; 1; 1; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Test" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Any value or expression which can be either TRUE or FALSE." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "Then_value" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The result of the function if the logical test returns a TRUE." ; - }; - String 6 // Name of Parameter 3 - { - Text [ en-US ] = "Otherwise_value" ; - }; - String 7 // Description of Parameter 3 - { - Text [ en-US ] = "The result of the function if the logical test returns FALSE." ; - }; - }; - // -=*# Resource for function IFERROR #*=- - Resource SC_OPCODE_IF_ERROR - { - String 1 // Description - { - Text [ en-US ] = "Returns value if not an error value, else alternative." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_IFERROR; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be calculated." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "alternative value" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The alternative to be returned, should value be an error value." ; - }; - }; - // -=*# Resource for function IFNA #*=- - Resource SC_OPCODE_IF_NA - { - String 1 // Description - { - Text [ en-US ] = "Returns value if not a #N/A error, else alternative." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_IFNA; - 2; 0; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "value" ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "The value to be calculated." ; - }; - String 4 // Name of Parameter 2 - { - Text [ en-US ] = "alternative value" ; - }; - String 5 // Description of Parameter 2 - { - Text [ en-US ] = "The alternative to be returned, should value be a #N/A error." ; - }; - }; - // -=*# Resource for function OR #*=- - Resource SC_OPCODE_OR - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if an argument is TRUE." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_ODER; - VAR_ARGS; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Logical value " ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Logical value 1, logical value 2,... are 1 to 30 conditions to be tested and which return either TRUE or FALSE." ; - }; - }; - // -=*# Resource for function XOR #*=- - Resource SC_OPCODE_XOR - { - String 1 // Description - { - Text [ en-US ] = "Returns TRUE if an odd number of arguments evaluates to TRUE." ; - }; - ExtraData = - { - 0; - ID_FUNCTION_GRP_LOGIC; - HID_FUNC_XOR; - VAR_ARGS; 0; - 0; - }; - String 2 // Name of Parameter 1 - { - Text [ en-US ] = "Logical value " ; - }; - String 3 // Description of Parameter 1 - { - Text [ en-US ] = "Logical value 1, logical value 2, ... are 1 to 30 conditions to be tested and which return either TRUE or FALSE." ; - }; - }; - // -=*# Resource for function AND #*=- - Resource SC_OPCODE_AND - { ... etc. - the rest is truncated
_______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
