[Libreoffice-commits] core.git: 22 commits - include/svx sc/inc sc/sdi sc/source
Caolán McNamara
caolanm at redhat.com
Thu Feb 16 15:57:41 UTC 2017
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 <caolanm at redhat.com>
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 <caolanm at redhat.com>
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
More information about the Libreoffice-commits
mailing list