diff options
Diffstat (limited to 'scaddins')
27 files changed, 1576 insertions, 2845 deletions
diff --git a/scaddins/AllLangMoTarget_sca.mk b/scaddins/AllLangMoTarget_sca.mk new file mode 100644 index 000000000000..830e2b4f1a62 --- /dev/null +++ b/scaddins/AllLangMoTarget_sca.mk @@ -0,0 +1,13 @@ +# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- +# +# This file is part of the LibreOffice project. +# +# This Source Code Form is subject to the terms of the Mozilla Public +# License, v. 2.0. If a copy of the MPL was not distributed with this +# file, You can obtain one at http://mozilla.org/MPL/2.0/. + +$(eval $(call gb_AllLangMoTarget_AllLangMoTarget,sca)) + +$(eval $(call gb_AllLangMoTarget_set_polocation,sca,scaddins)) + +# vim: set noet sw=4 ts=4: diff --git a/scaddins/AllLangResTarget_analysis.mk b/scaddins/AllLangResTarget_analysis.mk deleted file mode 100644 index 874e96fdad7a..000000000000 --- a/scaddins/AllLangResTarget_analysis.mk +++ /dev/null @@ -1,38 +0,0 @@ -# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- -# -# This file is part of the LibreOffice project. -# -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# This file incorporates work covered by the following license notice: -# -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed -# with this work for additional information regarding copyright -# ownership. The ASF licenses this file to you under the Apache -# License, Version 2.0 (the "License"); you may not use this file -# except in compliance with the License. You may obtain a copy of -# the License at http://www.apache.org/licenses/LICENSE-2.0 . -# - -$(eval $(call gb_AllLangResTarget_AllLangResTarget,analysis)) - -$(eval $(call gb_AllLangResTarget_add_srs,analysis,\ - scaddins/analysis \ -)) - -$(eval $(call gb_SrsTarget_SrsTarget,scaddins/analysis)) - -$(eval $(call gb_SrsTarget_set_include,scaddins/analysis,\ - $$(INCLUDE) \ - -I$(SRCDIR)/scaddins/source/analysis \ -)) - -$(eval $(call gb_SrsTarget_add_files,scaddins/analysis,\ - scaddins/source/analysis/analysis.src \ - scaddins/source/analysis/analysis_funcnames.src \ -)) - -# vim: set noet sw=4 ts=4: diff --git a/scaddins/AllLangResTarget_date.mk b/scaddins/AllLangResTarget_date.mk deleted file mode 100644 index 6b9377866d5b..000000000000 --- a/scaddins/AllLangResTarget_date.mk +++ /dev/null @@ -1,37 +0,0 @@ -# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- -# -# This file is part of the LibreOffice project. -# -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# This file incorporates work covered by the following license notice: -# -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed -# with this work for additional information regarding copyright -# ownership. The ASF licenses this file to you under the Apache -# License, Version 2.0 (the "License"); you may not use this file -# except in compliance with the License. You may obtain a copy of -# the License at http://www.apache.org/licenses/LICENSE-2.0 . -# - -$(eval $(call gb_AllLangResTarget_AllLangResTarget,date)) - -$(eval $(call gb_AllLangResTarget_add_srs,date,\ - scaddins/date \ -)) - -$(eval $(call gb_SrsTarget_SrsTarget,scaddins/date)) - -$(eval $(call gb_SrsTarget_set_include,scaddins/date,\ - $$(INCLUDE) \ - -I$(SRCDIR)/scaddins/source/datefunc \ -)) - -$(eval $(call gb_SrsTarget_add_files,scaddins/date,\ - scaddins/source/datefunc/datefunc.src \ -)) - -# vim: set noet sw=4 ts=4: diff --git a/scaddins/AllLangResTarget_pricing.mk b/scaddins/AllLangResTarget_pricing.mk deleted file mode 100644 index e4f6eb26069d..000000000000 --- a/scaddins/AllLangResTarget_pricing.mk +++ /dev/null @@ -1,37 +0,0 @@ -# -*- Mode: makefile-gmake; tab-width: 4; indent-tabs-mode: t -*- -# -# This file is part of the LibreOffice project. -# -# This Source Code Form is subject to the terms of the Mozilla Public -# License, v. 2.0. If a copy of the MPL was not distributed with this -# file, You can obtain one at http://mozilla.org/MPL/2.0/. -# -# This file incorporates work covered by the following license notice: -# -# Licensed to the Apache Software Foundation (ASF) under one or more -# contributor license agreements. See the NOTICE file distributed -# with this work for additional information regarding copyright -# ownership. The ASF licenses this file to you under the Apache -# License, Version 2.0 (the "License"); you may not use this file -# except in compliance with the License. You may obtain a copy of -# the License at http://www.apache.org/licenses/LICENSE-2.0 . -# - -$(eval $(call gb_AllLangResTarget_AllLangResTarget,pricing)) - -$(eval $(call gb_AllLangResTarget_add_srs,pricing,\ - scaddins/pricing \ -)) - -$(eval $(call gb_SrsTarget_SrsTarget,scaddins/pricing)) - -$(eval $(call gb_SrsTarget_set_include,scaddins/pricing,\ - $$(INCLUDE) \ - -I$(SRCDIR)/scaddins/source/pricing \ -)) - -$(eval $(call gb_SrsTarget_add_files,scaddins/pricing,\ - scaddins/source/pricing/pricing.src \ -)) - -# vim: set noet sw=4 ts=4: diff --git a/scaddins/Library_analysis.mk b/scaddins/Library_analysis.mk index 1185c4dd3683..2c56e9daa9ee 100644 --- a/scaddins/Library_analysis.mk +++ b/scaddins/Library_analysis.mk @@ -21,6 +21,11 @@ $(eval $(call gb_Library_Library,analysis)) $(eval $(call gb_Library_set_componentfile,analysis,scaddins/source/analysis/analysis)) +$(eval $(call gb_Library_set_include,analysis,\ + $$(INCLUDE) \ + -I$(SRCDIR)/scaddins/inc \ +)) + $(eval $(call gb_Library_use_external,analysis,boost_headers)) $(eval $(call gb_Library_use_internal_comprehensive_api,analysis,\ @@ -45,7 +50,4 @@ $(eval $(call gb_Library_add_exception_objects,analysis,\ scaddins/source/analysis/financial \ )) -# Runtime dependency for unit-tests -$(eval $(call gb_Library_use_restarget,analysis,analysis)) - # vim: set noet sw=4 ts=4: diff --git a/scaddins/Library_date.mk b/scaddins/Library_date.mk index dbc76688bc9d..71c3db9ccb5d 100644 --- a/scaddins/Library_date.mk +++ b/scaddins/Library_date.mk @@ -21,6 +21,11 @@ $(eval $(call gb_Library_Library,date)) $(eval $(call gb_Library_set_componentfile,date,scaddins/source/datefunc/date)) +$(eval $(call gb_Library_set_include,date,\ + $$(INCLUDE) \ + -I$(SRCDIR)/scaddins/inc \ +)) + $(eval $(call gb_Library_use_external,date,boost_headers)) $(eval $(call gb_Library_use_internal_comprehensive_api,date,\ @@ -41,7 +46,4 @@ $(eval $(call gb_Library_add_exception_objects,date,\ scaddins/source/datefunc/datefunc \ )) -# Runtime dependency for unit-tests -$(eval $(call gb_Library_use_restarget,date,date)) - # vim: set noet sw=4 ts=4: diff --git a/scaddins/Library_pricing.mk b/scaddins/Library_pricing.mk index ea12d2fdb7b6..2f221c9964fd 100644 --- a/scaddins/Library_pricing.mk +++ b/scaddins/Library_pricing.mk @@ -21,6 +21,11 @@ $(eval $(call gb_Library_Library,pricing)) $(eval $(call gb_Library_set_componentfile,pricing,scaddins/source/pricing/pricing)) +$(eval $(call gb_Library_set_include,pricing,\ + $$(INCLUDE) \ + -I$(SRCDIR)/scaddins/inc \ +)) + $(eval $(call gb_Library_use_external,pricing,boost_headers)) $(eval $(call gb_Library_use_internal_comprehensive_api,pricing,\ @@ -42,7 +47,4 @@ $(eval $(call gb_Library_add_exception_objects,pricing,\ scaddins/source/pricing/black_scholes \ )) -# Runtime dependency for unit-tests -$(eval $(call gb_Library_use_restarget,pricing,pricing)) - # vim: set noet sw=4 ts=4: diff --git a/scaddins/Module_scaddins.mk b/scaddins/Module_scaddins.mk index 3c89952f323b..a927385b276c 100644 --- a/scaddins/Module_scaddins.mk +++ b/scaddins/Module_scaddins.mk @@ -27,9 +27,7 @@ $(eval $(call gb_Module_add_targets,scaddins,\ )) $(eval $(call gb_Module_add_l10n_targets,scaddins,\ - AllLangResTarget_analysis \ - AllLangResTarget_date \ - AllLangResTarget_pricing \ + AllLangMoTarget_sca \ )) # vim: set noet sw=4 ts=4: diff --git a/scaddins/inc/analysis.hrc b/scaddins/inc/analysis.hrc new file mode 100644 index 000000000000..07878a7954f9 --- /dev/null +++ b/scaddins/inc/analysis.hrc @@ -0,0 +1,1106 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#ifndef INCLUDED_SCADDINS_INC_ANALYSIS_HRC +#define INCLUDED_SCADDINS_INC_ANALYSIS_HRC + +#define NC_(Context, String) (Context "\004" u8##String) + +const char* ANALYSIS_Workday[] = +{ + NC_("ANALYSIS_Workday", "Returns the serial number of the date before or after a specified number of workdays"), + NC_("ANALYSIS_Workday", "Start date"), + NC_("ANALYSIS_Workday", "The start date"), + NC_("ANALYSIS_Workday", "Days"), + NC_("ANALYSIS_Workday", "The number of workdays before or after the start date"), + NC_("ANALYSIS_Workday", "Holidays"), + NC_("ANALYSIS_Workday", "List of date values of days off (vacation, holidays, etc.)") +}; + +const char* ANALYSIS_Yearfrac[] = +{ + NC_("ANALYSIS_Yearfrac", "Returns the number of years (including fractional part) between two dates"), + NC_("ANALYSIS_Yearfrac", "Start date"), + NC_("ANALYSIS_Yearfrac", "The start date"), + NC_("ANALYSIS_Yearfrac", "End date"), + NC_("ANALYSIS_Yearfrac", "The end date"), + NC_("ANALYSIS_Yearfrac", "Basis"), + NC_("ANALYSIS_Yearfrac", "Basis indicates the day-count convention to use in the calculation") +}; + +const char* ANALYSIS_Edate[] = +{ + NC_("ANALYSIS_Edate", "Returns the serial number of the date that is a specified number of months before or after the start date"), + NC_("ANALYSIS_Edate", "Start date"), + NC_("ANALYSIS_Edate", "The start date"), + NC_("ANALYSIS_Edate", "Months"), + NC_("ANALYSIS_Edate", "Number of months before or after the start date") +}; + +const char* ANALYSIS_Weeknum[] = +{ + NC_("ANALYSIS_Weeknum", "Returns the number of the calendar week in which the specified date occurs.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead."), + NC_("ANALYSIS_Weeknum", "Date"), + NC_("ANALYSIS_Weeknum", "The date or date serial number"), + NC_("ANALYSIS_Weeknum", "Return type"), + NC_("ANALYSIS_Weeknum", "Indicates the first day of the week (1 = Sunday, 2 = Monday)") +}; + +const char* ANALYSIS_Eomonth[] = +{ + NC_("ANALYSIS_Eomonth", "Returns the serial number of the last day of the month that comes a certain number of months before or after the start date"), + NC_("ANALYSIS_Eomonth", "Start date"), + NC_("ANALYSIS_Eomonth", "The start date"), + NC_("ANALYSIS_Eomonth", "Months"), + NC_("ANALYSIS_Eomonth", "Number of months before or after the start date") +}; + +const char* ANALYSIS_Networkdays[] = +{ + NC_("ANALYSIS_Networkdays", "Returns the number of workdays between two dates.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead."), + NC_("ANALYSIS_Networkdays", "Start date"), + NC_("ANALYSIS_Networkdays", "The start date"), + NC_("ANALYSIS_Networkdays", "End date"), + NC_("ANALYSIS_Networkdays", "The end date"), + NC_("ANALYSIS_Networkdays", "Holidays"), + NC_("ANALYSIS_Networkdays", "List of date values representing days off (vacation, holidays, etc.)") +}; + +const char* ANALYSIS_Iseven[] = +{ + NC_("ANALYSIS_Iseven", "Returns the value 'true' if the number is even"), + NC_("ANALYSIS_Iseven", "Number"), + NC_("ANALYSIS_Iseven", "The number") +}; + +const char* ANALYSIS_Isodd[] = +{ + NC_("ANALYSIS_Isodd", "Returns the value 'true' if the number is odd"), + NC_("ANALYSIS_Isodd", "Number"), + NC_("ANALYSIS_Isodd", "The number") +}; + +const char* ANALYSIS_Multinomial[] = +{ + NC_("ANALYSIS_Multinomial", "Returns the multinomial coefficient of a set of numbers"), + NC_("ANALYSIS_Multinomial", "Number"), + NC_("ANALYSIS_Multinomial", "Number or list of numbers for which you want the multinomial coefficient") +}; + +const char* ANALYSIS_Seriessum[] = +{ + NC_("ANALYSIS_Seriessum", "Returns the sum of a power series"), + NC_("ANALYSIS_Seriessum", "X"), + NC_("ANALYSIS_Seriessum", "The independent variable of the power series"), + NC_("ANALYSIS_Seriessum", "N"), + NC_("ANALYSIS_Seriessum", "The initial power to which x is to be raised"), + NC_("ANALYSIS_Seriessum", "M"), + NC_("ANALYSIS_Seriessum", "The increment by which to increase n for each term in the series"), + NC_("ANALYSIS_Seriessum", "Coefficients"), + NC_("ANALYSIS_Seriessum", "Set of coefficients by which each successive power of the variable x is multiplied") +}; + +const char* ANALYSIS_Quotient[] = +{ + NC_("ANALYSIS_Quotient", "Returns the integer portion of a division"), + NC_("ANALYSIS_Quotient", "Numerator"), + NC_("ANALYSIS_Quotient", "The dividend"), + NC_("ANALYSIS_Quotient", "Denominator"), + NC_("ANALYSIS_Quotient", "The divisor") +}; + +const char* ANALYSIS_Mround[] = +{ + NC_("ANALYSIS_Mround", "Returns a number rounded to a specified multiple"), + NC_("ANALYSIS_Mround", "Number"), + NC_("ANALYSIS_Mround", "The number to round off"), + NC_("ANALYSIS_Mround", "Multiple"), + NC_("ANALYSIS_Mround", "The multiple to which you want to round number") +}; + +const char* ANALYSIS_Sqrtpi[] = +{ + NC_("ANALYSIS_Sqrtpi", "Returns the square root of a number which has been multiplied by pi"), + NC_("ANALYSIS_Sqrtpi", "Number"), + NC_("ANALYSIS_Sqrtpi", "The number by which pi is multiplied") +}; + +const char* ANALYSIS_Randbetween[] = +{ + NC_("ANALYSIS_Randbetween", "Returns a random integer between the numbers you specify"), + NC_("ANALYSIS_Randbetween", "Bottom"), + NC_("ANALYSIS_Randbetween", "The smallest integer returned"), + NC_("ANALYSIS_Randbetween", "Top"), + NC_("ANALYSIS_Randbetween", "The largest integer returned") +}; + +const char* ANALYSIS_Gcd[] = +{ + NC_("ANALYSIS_Gcd", "Returns the greatest common divisor.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use GCD instead."), + NC_("ANALYSIS_Gcd", "Number"), + NC_("ANALYSIS_Gcd", "Number or list of numbers") +}; + +const char* ANALYSIS_Lcm[] = +{ + NC_("ANALYSIS_Lcm", "Returns the least common multiple.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use LCM instead."), + NC_("ANALYSIS_Lcm", "Number"), + NC_("ANALYSIS_Lcm", "Number or list of numbers") +}; + +const char* ANALYSIS_Besseli[] = +{ + NC_("ANALYSIS_Besseli", "Returns the modified Bessel function In(x)"), + NC_("ANALYSIS_Besseli", "X"), + NC_("ANALYSIS_Besseli", "The value at which the function is to be evaluated"), + NC_("ANALYSIS_Besseli", "N"), + NC_("ANALYSIS_Besseli", "The order of the Bessel function") +}; + +const char* ANALYSIS_Besselj[] = +{ + NC_("ANALYSIS_Besselj", "Returns the Bessel function Jn(x)"), + NC_("ANALYSIS_Besselj", "X"), + NC_("ANALYSIS_Besselj", "The value at which the function is to be evaluated"), + NC_("ANALYSIS_Besselj", "N"), + NC_("ANALYSIS_Besselj", "The order of the Bessel function") +}; + +const char* ANALYSIS_Besselk[] = +{ + NC_("ANALYSIS_Besselk", "Returns the Bessel function Kn(x)"), + NC_("ANALYSIS_Besselk", "X"), + NC_("ANALYSIS_Besselk", "The value at which the function is to be evaluated"), + NC_("ANALYSIS_Besselk", "N"), + NC_("ANALYSIS_Besselk", "The order of the Bessel function") +}; + +const char* ANALYSIS_Bessely[] = +{ + NC_("ANALYSIS_Bessely", "Returns the Bessel function Yn(x)"), + NC_("ANALYSIS_Bessely", "X"), + NC_("ANALYSIS_Bessely", "The value at which the function is to be evaluated"), + NC_("ANALYSIS_Bessely", "N"), + NC_("ANALYSIS_Bessely", "The order of the Bessel function") +}; + +const char* ANALYSIS_Bin2Oct[] = +{ + NC_("ANALYSIS_Bin2Oct", "Converts a binary number to an octal number"), + NC_("ANALYSIS_Bin2Oct", "Number"), + NC_("ANALYSIS_Bin2Oct", "The binary number to be converted (as text)"), + NC_("ANALYSIS_Bin2Oct", "Places"), + NC_("ANALYSIS_Bin2Oct", "Number of places used") +}; + +const char* ANALYSIS_Bin2Dec[] = +{ + NC_("ANALYSIS_Bin2Dec", "Converts a binary number to a decimal number"), + NC_("ANALYSIS_Bin2Dec", "Number"), + NC_("ANALYSIS_Bin2Dec", "The binary number to be converted (as text)") +}; + +const char* ANALYSIS_Bin2Hex[] = +{ + NC_("ANALYSIS_Bin2Hex", "Converts a binary number to a hexadecimal number"), + NC_("ANALYSIS_Bin2Hex", "Number"), + NC_("ANALYSIS_Bin2Hex", "The binary number to be converted (as text)"), + NC_("ANALYSIS_Bin2Hex", "Places"), + NC_("ANALYSIS_Bin2Hex", "Number of places used.") +}; + +const char* ANALYSIS_Oct2Bin[] = +{ + NC_("ANALYSIS_Oct2Bin", "Converts an octal number to a binary number"), + NC_("ANALYSIS_Oct2Bin", "Number"), + NC_("ANALYSIS_Oct2Bin", "The octal number to be converted (as text)"), + NC_("ANALYSIS_Oct2Bin", "Places"), + NC_("ANALYSIS_Oct2Bin", "Number of places used") +}; + +const char* ANALYSIS_Oct2Dec[] = +{ + NC_("ANALYSIS_Oct2Dec", "Converts an octal number to a decimal number"), + NC_("ANALYSIS_Oct2Dec", "Number"), + NC_("ANALYSIS_Oct2Dec", "The octal number to be converted (as text)") +}; + +const char* ANALYSIS_Oct2Hex[] = +{ + NC_("ANALYSIS_Oct2Hex", "Converts an octal number to a hexadecimal number"), + NC_("ANALYSIS_Oct2Hex", "Number"), + NC_("ANALYSIS_Oct2Hex", "The octal number to be converted (as text)"), + NC_("ANALYSIS_Oct2Hex", "Places"), + NC_("ANALYSIS_Oct2Hex", "Number of places used") +}; + +const char* ANALYSIS_Dec2Bin[] = +{ + NC_("ANALYSIS_Dec2Bin", "Converts a decimal number to a binary number"), + NC_("ANALYSIS_Dec2Bin", "Number"), + NC_("ANALYSIS_Dec2Bin", "The decimal integer to be converted"), + NC_("ANALYSIS_Dec2Bin", "Places"), + NC_("ANALYSIS_Dec2Bin", "Number of places used") +}; + +const char* ANALYSIS_Dec2Hex[] = +{ + NC_("ANALYSIS_Dec2Hex", "Converts a decimal number to a hexadecimal number"), + NC_("ANALYSIS_Dec2Hex", "Number"), + NC_("ANALYSIS_Dec2Hex", "The decimal integer to be converted"), + NC_("ANALYSIS_Dec2Hex", "Places"), + NC_("ANALYSIS_Dec2Hex", "Number of places used") +}; + +const char* ANALYSIS_Dec2Oct[] = +{ + NC_("ANALYSIS_Dec2Oct", "Converts a decimal number into an octal number"), + NC_("ANALYSIS_Dec2Oct", "Number"), + NC_("ANALYSIS_Dec2Oct", "The decimal number"), + NC_("ANALYSIS_Dec2Oct", "Places"), + NC_("ANALYSIS_Dec2Oct", "Number of places used") +}; + +const char* ANALYSIS_Hex2Bin[] = +{ + NC_("ANALYSIS_Hex2Bin", "Converts a hexadecimal number to a binary number"), + NC_("ANALYSIS_Hex2Bin", "Number"), + NC_("ANALYSIS_Hex2Bin", "The hexadecimal number to be converted (as text)"), + NC_("ANALYSIS_Hex2Bin", "Places"), + NC_("ANALYSIS_Hex2Bin", "Number of places used") +}; + +const char* ANALYSIS_Hex2Dec[] = +{ + NC_("ANALYSIS_Hex2Dec", "Converts a hexadecimal number to a decimal number"), + NC_("ANALYSIS_Hex2Dec", "Number"), + NC_("ANALYSIS_Hex2Dec", "The hexadecimal number to be converted (as text)") +}; + +const char* ANALYSIS_Hex2Oct[] = +{ + NC_("ANALYSIS_Hex2Oct", "Converts a hexadecimal number to an octal number"), + NC_("ANALYSIS_Hex2Oct", "Number"), + NC_("ANALYSIS_Hex2Oct", "The hexadecimal number to be converted (as text)"), + NC_("ANALYSIS_Hex2Oct", "Places"), + NC_("ANALYSIS_Hex2Oct", "Number of places used") +}; + +const char* ANALYSIS_Delta[] = +{ + NC_("ANALYSIS_Delta", "Tests whether two values are equal"), + NC_("ANALYSIS_Delta", "Number 1"), + NC_("ANALYSIS_Delta", "The first number"), + NC_("ANALYSIS_Delta", "Number 2"), + NC_("ANALYSIS_Delta", "The second number") +}; + +const char* ANALYSIS_Erf[] = +{ + NC_("ANALYSIS_Erf", "Returns the error function"), + NC_("ANALYSIS_Erf", "Lower limit"), + NC_("ANALYSIS_Erf", "The lower limit for integration"), + NC_("ANALYSIS_Erf", "Upper limit"), + NC_("ANALYSIS_Erf", "The upper limit for integration") +}; + +const char* ANALYSIS_Erfc[] = +{ + NC_("ANALYSIS_Erfc", "Returns the complementary error function"), + NC_("ANALYSIS_Erfc", "Lower limit"), + NC_("ANALYSIS_Erfc", "The lower limit for integration") +}; + +const char* ANALYSIS_Gestep[] = +{ + NC_("ANALYSIS_Gestep", "Tests whether a number is greater than a threshold value"), + NC_("ANALYSIS_Gestep", "Number"), + NC_("ANALYSIS_Gestep", "The value to test against step"), + NC_("ANALYSIS_Gestep", "Step"), + NC_("ANALYSIS_Gestep", "The threshold value") +}; + +const char* ANALYSIS_Factdouble[] = +{ + NC_("ANALYSIS_Factdouble", "Returns the double factorial of Number"), + NC_("ANALYSIS_Factdouble", "Number"), + NC_("ANALYSIS_Factdouble", "The number") +}; + +const char* ANALYSIS_Imabs[] = +{ + NC_("ANALYSIS_Imabs", "Returns the absolute value (modulus) of a complex number"), + NC_("ANALYSIS_Imabs", "Complex number"), + NC_("ANALYSIS_Imabs", "The complex number") +}; + +const char* ANALYSIS_Imaginary[] = +{ + NC_("ANALYSIS_Imaginary", "Returns the imaginary coefficient of a complex number"), + NC_("ANALYSIS_Imaginary", "Complex number"), + NC_("ANALYSIS_Imaginary", "The complex number") +}; + +const char* ANALYSIS_Impower[] = +{ + NC_("ANALYSIS_Impower", "Returns a complex number raised to a real power"), + NC_("ANALYSIS_Impower", "Complex number"), + NC_("ANALYSIS_Impower", "The complex number"), + NC_("ANALYSIS_Impower", "Number"), + NC_("ANALYSIS_Impower", "Power to which the complex number is raised") +}; + +const char* ANALYSIS_Imargument[] = +{ + NC_("ANALYSIS_Imargument", "Returns the argument theta, an angle expressed in radians"), + NC_("ANALYSIS_Imargument", "Complex number"), + NC_("ANALYSIS_Imargument", "A complex number") +}; + +const char* ANALYSIS_Imcos[] = +{ + NC_("ANALYSIS_Imcos", "Returns the cosine of a complex number"), + NC_("ANALYSIS_Imcos", "Complex number"), + NC_("ANALYSIS_Imcos", "A complex number") +}; + +const char* ANALYSIS_Imdiv[] = +{ + NC_("ANALYSIS_Imdiv", "Returns the quotient of two complex numbers"), + NC_("ANALYSIS_Imdiv", "Numerator"), + NC_("ANALYSIS_Imdiv", "The dividend"), + NC_("ANALYSIS_Imdiv", "Denominator"), + NC_("ANALYSIS_Imdiv", "The divisor") +}; + +const char* ANALYSIS_Imexp[] = +{ + NC_("ANALYSIS_Imexp", "Returns the algebraic form of the exponential of a complex number"), + NC_("ANALYSIS_Imexp", "Complex number"), + NC_("ANALYSIS_Imexp", "The complex number") +}; + +const char* ANALYSIS_Imconjugate[] = +{ + NC_("ANALYSIS_Imconjugate", "Returns the complex conjugate of a complex number"), + NC_("ANALYSIS_Imconjugate", "Complex number"), + NC_("ANALYSIS_Imconjugate", "The complex number") +}; + +const char* ANALYSIS_Imln[] = +{ + NC_("ANALYSIS_Imln", "Returns the natural logarithm of a complex number"), + NC_("ANALYSIS_Imln", "Complex number"), + NC_("ANALYSIS_Imln", "The complex number") +}; + +const char* ANALYSIS_Imlog10[] = +{ + NC_("ANALYSIS_Imlog10", "Returns the base-10 logarithm of a complex number"), + NC_("ANALYSIS_Imlog10", "Complex number"), + NC_("ANALYSIS_Imlog10", "The complex number") +}; + +const char* ANALYSIS_Imlog2[] = +{ + NC_("ANALYSIS_Imlog2", "Returns the base-2 logarithm of a complex number"), + NC_("ANALYSIS_Imlog2", "Complex number"), + NC_("ANALYSIS_Imlog2", "The complex number") +}; + +const char* ANALYSIS_Improduct[] = +{ + NC_("ANALYSIS_Improduct", "Returns the product of several complex numbers"), + NC_("ANALYSIS_Improduct", "Complex number"), + NC_("ANALYSIS_Improduct", "The first complex number"), + NC_("ANALYSIS_Improduct", "Complex number"), + NC_("ANALYSIS_Improduct", "Another complex number") +}; + +const char* ANALYSIS_Imreal[] = +{ + NC_("ANALYSIS_Imreal", "Returns the real coefficient of a complex number"), + NC_("ANALYSIS_Imreal", "Complex number"), + NC_("ANALYSIS_Imreal", "The complex number") +}; + +const char* ANALYSIS_Imsin[] = +{ + NC_("ANALYSIS_Imsin", "Returns the sine of a complex number"), + NC_("ANALYSIS_Imsin", "Complex number"), + NC_("ANALYSIS_Imsin", "The complex number") +}; + +const char* ANALYSIS_Imsub[] = +{ + NC_("ANALYSIS_Imsub", "Returns the difference of two complex numbers"), + NC_("ANALYSIS_Imsub", "Complex number 1"), + NC_("ANALYSIS_Imsub", "Complex number 1"), + NC_("ANALYSIS_Imsub", "Complex number 2"), + NC_("ANALYSIS_Imsub", "Complex number 2") +}; + +const char* ANALYSIS_Imsqrt[] = +{ + NC_("ANALYSIS_Imsqrt", "Returns the square root of a complex number"), + NC_("ANALYSIS_Imsqrt", "Complex number"), + NC_("ANALYSIS_Imsqrt", "The complex number") +}; + +const char* ANALYSIS_Imsum[] = +{ + NC_("ANALYSIS_Imsum", "Returns the sum of complex numbers"), + NC_("ANALYSIS_Imsum", "Complex number"), + NC_("ANALYSIS_Imsum", "The complex number") +}; + +const char* ANALYSIS_Imtan[] = +{ + NC_("ANALYSIS_Imtan", "Returns the tangent of a complex number"), + NC_("ANALYSIS_Imtan", "Complex number"), + NC_("ANALYSIS_Imtan", "A complex number") +}; + +const char* ANALYSIS_Imsec[] = +{ + NC_("ANALYSIS_Imsec", "Returns the secant of a complex number"), + NC_("ANALYSIS_Imsec", "Complex number"), + NC_("ANALYSIS_Imsec", "A complex number") +}; + +const char* ANALYSIS_Imcsc[] = +{ + NC_("ANALYSIS_Imcsc", "Returns the cosecant of a complex number"), + NC_("ANALYSIS_Imcsc", "Complex number"), + NC_("ANALYSIS_Imcsc", "A complex number") +}; + +const char* ANALYSIS_Imcot[] = +{ + NC_("ANALYSIS_Imcot", "Returns the cotangent of a complex number"), + NC_("ANALYSIS_Imcot", "Complex number"), + NC_("ANALYSIS_Imcot", "A complex number") +}; + +const char* ANALYSIS_Imsinh[] = +{ + NC_("ANALYSIS_Imsinh", "Returns the hyperbolic sine of a complex number"), + NC_("ANALYSIS_Imsinh", "Complex number"), + NC_("ANALYSIS_Imsinh", "A complex number") +}; + +const char* ANALYSIS_Imcosh[] = +{ + NC_("ANALYSIS_Imcosh", "Returns the hyperbolic cosine of a complex number"), + NC_("ANALYSIS_Imcosh", "Complex number"), + NC_("ANALYSIS_Imcosh", "A complex number") +}; + +const char* ANALYSIS_Imsech[] = +{ + NC_("ANALYSIS_Imsech", "Returns the hyperbolic secant of a complex number"), + NC_("ANALYSIS_Imsech", "Complex number"), + NC_("ANALYSIS_Imsech", "A complex number") +}; + +const char* ANALYSIS_Imcsch[] = +{ + NC_("ANALYSIS_Imcsch", "Returns the hyperbolic cosecant of a complex number"), + NC_("ANALYSIS_Imcsch", "Complex number"), + NC_("ANALYSIS_Imcsch", "A complex number") +}; + +const char* ANALYSIS_Complex[] = +{ + NC_("ANALYSIS_Complex", "Converts real and imaginary coefficients into a complex number"), + NC_("ANALYSIS_Complex", "Real num"), + NC_("ANALYSIS_Complex", "The real coefficient"), + NC_("ANALYSIS_Complex", "I num"), + NC_("ANALYSIS_Complex", "The imaginary coefficient"), + NC_("ANALYSIS_Complex", "Suffix"), + NC_("ANALYSIS_Complex", "The suffix") +}; + +const char* ANALYSIS_Convert[] = +{ + NC_("ANALYSIS_Convert", "Converts a number from one measurement system to another"), + NC_("ANALYSIS_Convert", "Number"), + NC_("ANALYSIS_Convert", "The number"), + NC_("ANALYSIS_Convert", "From unit"), + NC_("ANALYSIS_Convert", "Unit of measure for number"), + NC_("ANALYSIS_Convert", "To unit"), + NC_("ANALYSIS_Convert", "Unit of measure for the result") +}; + +const char* ANALYSIS_Amordegrc[] = +{ + NC_("ANALYSIS_Amordegrc", "Returns the prorated linear depreciation of an asset for each accounting period"), + NC_("ANALYSIS_Amordegrc", "Cost"), + NC_("ANALYSIS_Amordegrc", "Cost of the asset"), + NC_("ANALYSIS_Amordegrc", "Date purchased"), + NC_("ANALYSIS_Amordegrc", "Purchase date of the asset"), + NC_("ANALYSIS_Amordegrc", "First period"), + NC_("ANALYSIS_Amordegrc", "Date the first period ends"), + NC_("ANALYSIS_Amordegrc", "Salvage"), + NC_("ANALYSIS_Amordegrc", "Salvage value of an asset at the end of its life"), + NC_("ANALYSIS_Amordegrc", "Period"), + NC_("ANALYSIS_Amordegrc", "The period"), + NC_("ANALYSIS_Amordegrc", "Rate"), + NC_("ANALYSIS_Amordegrc", "The rate of depreciation"), + NC_("ANALYSIS_Amordegrc", "Basis"), + NC_("ANALYSIS_Amordegrc", "The year basis to be used") +}; + +const char* ANALYSIS_Amorlinc[] = +{ + NC_("ANALYSIS_Amorlinc", "Returns the prorated linear depreciation of an asset for each accounting period"), + NC_("ANALYSIS_Amorlinc", "Cost"), + NC_("ANALYSIS_Amorlinc", "Cost of the asset"), + NC_("ANALYSIS_Amorlinc", "Date purchased"), + NC_("ANALYSIS_Amorlinc", "Purchase date of the asset"), + NC_("ANALYSIS_Amorlinc", "First period"), + NC_("ANALYSIS_Amorlinc", "The date the first period ends"), + NC_("ANALYSIS_Amorlinc", "Salvage"), + NC_("ANALYSIS_Amorlinc", "The salvage value of an asset at the end of its life"), + NC_("ANALYSIS_Amorlinc", "Period"), + NC_("ANALYSIS_Amorlinc", "The period"), + NC_("ANALYSIS_Amorlinc", "Rate"), + NC_("ANALYSIS_Amorlinc", "The rate of depreciation"), + NC_("ANALYSIS_Amorlinc", "Basis"), + NC_("ANALYSIS_Amorlinc", "The year basis to be used") +}; + +const char* ANALYSIS_Accrint[] = +{ + NC_("ANALYSIS_Accrint", "Returns the accrued interest for a security that pays periodic interest"), + NC_("ANALYSIS_Accrint", "Issue"), + NC_("ANALYSIS_Accrint", "Issue date of the security"), + NC_("ANALYSIS_Accrint", "First interest"), + NC_("ANALYSIS_Accrint", "First interest date of the security"), + NC_("ANALYSIS_Accrint", "Settlement"), + NC_("ANALYSIS_Accrint", "The settlement"), + NC_("ANALYSIS_Accrint", "Rate"), + NC_("ANALYSIS_Accrint", "The rate"), + NC_("ANALYSIS_Accrint", "Par"), + NC_("ANALYSIS_Accrint", "The par value"), + NC_("ANALYSIS_Accrint", "Frequency"), + NC_("ANALYSIS_Accrint", "The frequency"), + NC_("ANALYSIS_Accrint", "Basis"), + NC_("ANALYSIS_Accrint", "The basis") +}; + +const char* ANALYSIS_Accrintm[] = +{ + NC_("ANALYSIS_Accrintm", "Returns the accrued interest for a security that pays interest at maturity"), + NC_("ANALYSIS_Accrintm", "Issue"), + NC_("ANALYSIS_Accrintm", "The issue date"), + NC_("ANALYSIS_Accrintm", "Settlement"), + NC_("ANALYSIS_Accrintm", "The settlement"), + NC_("ANALYSIS_Accrintm", "Rate"), + NC_("ANALYSIS_Accrintm", "The rate"), + NC_("ANALYSIS_Accrintm", "Par"), + NC_("ANALYSIS_Accrintm", "The par value"), + NC_("ANALYSIS_Accrintm", "Basis"), + NC_("ANALYSIS_Accrintm", "The basis") +}; + +const char* ANALYSIS_Received[] = +{ + NC_("ANALYSIS_Received", "Returns the amount paid out at maturity for a fully invested security"), + NC_("ANALYSIS_Received", "Settlement"), + NC_("ANALYSIS_Received", "The settlement"), + NC_("ANALYSIS_Received", "Maturity"), + NC_("ANALYSIS_Received", "The maturity"), + NC_("ANALYSIS_Received", "Investment"), + NC_("ANALYSIS_Received", "The investment"), + NC_("ANALYSIS_Received", "Discount"), + NC_("ANALYSIS_Received", "The discount"), + NC_("ANALYSIS_Received", "Basis"), + NC_("ANALYSIS_Received", "The basis") +}; + +const char* ANALYSIS_Disc[] = +{ + NC_("ANALYSIS_Disc", "Returns the discount rate for a security"), + NC_("ANALYSIS_Disc", "Settlement"), + NC_("ANALYSIS_Disc", "The settlement"), + NC_("ANALYSIS_Disc", "Maturity"), + NC_("ANALYSIS_Disc", "The maturity"), + NC_("ANALYSIS_Disc", "Price"), + NC_("ANALYSIS_Disc", "The price"), + NC_("ANALYSIS_Disc", "Redemption"), + NC_("ANALYSIS_Disc", "The redemption value"), + NC_("ANALYSIS_Disc", "Basis"), + NC_("ANALYSIS_Disc", "The basis") +}; + +const char* ANALYSIS_Duration[] = +{ + NC_("ANALYSIS_Duration", "Returns the annual Macaulay duration of a security with periodic interest payments"), + NC_("ANALYSIS_Duration", "Settlement"), + NC_("ANALYSIS_Duration", "The settlement"), + NC_("ANALYSIS_Duration", "Maturity"), + NC_("ANALYSIS_Duration", "The maturity"), + NC_("ANALYSIS_Duration", "Coupon"), + NC_("ANALYSIS_Duration", "The coupon rate"), + NC_("ANALYSIS_Duration", "Yield"), + NC_("ANALYSIS_Duration", "The yield"), + NC_("ANALYSIS_Duration", "Frequency"), + NC_("ANALYSIS_Duration", "The frequency"), + NC_("ANALYSIS_Duration", "Basis"), + NC_("ANALYSIS_Duration", "The basis") +}; + +const char* ANALYSIS_Effect[] = +{ + NC_("ANALYSIS_Effect", "Returns the effective annual interest rate"), + NC_("ANALYSIS_Effect", "Nominal rate"), + NC_("ANALYSIS_Effect", "The nominal rate"), + NC_("ANALYSIS_Effect", "Npery"), + NC_("ANALYSIS_Effect", "The periods") +}; + +const char* ANALYSIS_Cumprinc[] = +{ + NC_("ANALYSIS_Cumprinc", "Returns the cumulative principal on a loan to be paid between two periods"), + NC_("ANALYSIS_Cumprinc", "Rate"), + NC_("ANALYSIS_Cumprinc", "The rate"), + NC_("ANALYSIS_Cumprinc", "Nper"), + NC_("ANALYSIS_Cumprinc", "Number of payment periods"), + NC_("ANALYSIS_Cumprinc", "Pv"), + NC_("ANALYSIS_Cumprinc", "The present value"), + NC_("ANALYSIS_Cumprinc", "Start period"), + NC_("ANALYSIS_Cumprinc", "The start period"), + NC_("ANALYSIS_Cumprinc", "End period"), + NC_("ANALYSIS_Cumprinc", "The end period"), + NC_("ANALYSIS_Cumprinc", "Type"), + NC_("ANALYSIS_Cumprinc", "The type of maturity") +}; + +const char* ANALYSIS_Cumipmt[] = +{ + NC_("ANALYSIS_Cumipmt", "Returns the cumulative interest to be paid between two periods"), + NC_("ANALYSIS_Cumipmt", "Rate"), + NC_("ANALYSIS_Cumipmt", "The rate"), + NC_("ANALYSIS_Cumipmt", "Nper"), + NC_("ANALYSIS_Cumipmt", "Number of payment periods"), + NC_("ANALYSIS_Cumipmt", "Pv"), + NC_("ANALYSIS_Cumipmt", "The present value"), + NC_("ANALYSIS_Cumipmt", "Start period"), + NC_("ANALYSIS_Cumipmt", "The start period"), + NC_("ANALYSIS_Cumipmt", "End period"), + NC_("ANALYSIS_Cumipmt", "The end period"), + NC_("ANALYSIS_Cumipmt", "Type"), + NC_("ANALYSIS_Cumipmt", "The type of maturity") +}; + +const char* ANALYSIS_Price[] = +{ + NC_("ANALYSIS_Price", "Returns the price per 100 currency units face value of a security that pays periodic interest"), + NC_("ANALYSIS_Price", "Settlement"), + NC_("ANALYSIS_Price", "The settlement"), + NC_("ANALYSIS_Price", "Maturity"), + NC_("ANALYSIS_Price", "The maturity"), + NC_("ANALYSIS_Price", "Rate"), + NC_("ANALYSIS_Price", "The rate"), + NC_("ANALYSIS_Price", "Yield"), + NC_("ANALYSIS_Price", "The yield"), + NC_("ANALYSIS_Price", "Redemption"), + NC_("ANALYSIS_Price", "The redemption value"), + NC_("ANALYSIS_Price", "Frequency"), + NC_("ANALYSIS_Price", "The frequency"), + NC_("ANALYSIS_Price", "Basis"), + NC_("ANALYSIS_Price", "The basis") +}; + +const char* ANALYSIS_Pricedisc[] = +{ + NC_("ANALYSIS_Pricedisc", "Returns the price per 100 currency units face value of a discounted security"), + NC_("ANALYSIS_Pricedisc", "Settlement"), + NC_("ANALYSIS_Pricedisc", "The settlement"), + NC_("ANALYSIS_Pricedisc", "Maturity"), + NC_("ANALYSIS_Pricedisc", "The maturity"), + NC_("ANALYSIS_Pricedisc", "Discount"), + NC_("ANALYSIS_Pricedisc", "The discount"), + NC_("ANALYSIS_Pricedisc", "Redemption"), + NC_("ANALYSIS_Pricedisc", "The redemption value"), + NC_("ANALYSIS_Pricedisc", "Basis"), + NC_("ANALYSIS_Pricedisc", "The basis") +}; + +const char* ANALYSIS_Pricemat[] = +{ + NC_("ANALYSIS_Pricemat", "Returns the price per 100 currency units face value of a security that pays interest at maturity"), + NC_("ANALYSIS_Pricemat", "Settlement"), + NC_("ANALYSIS_Pricemat", "The settlement"), + NC_("ANALYSIS_Pricemat", "Maturity"), + NC_("ANALYSIS_Pricemat", "The maturity"), + NC_("ANALYSIS_Pricemat", "Issue"), + NC_("ANALYSIS_Pricemat", "The issue date"), + NC_("ANALYSIS_Pricemat", "Rate"), + NC_("ANALYSIS_Pricemat", "The rate"), + NC_("ANALYSIS_Pricemat", "Yield"), + NC_("ANALYSIS_Pricemat", "The yield"), + NC_("ANALYSIS_Pricemat", "Basis"), + NC_("ANALYSIS_Pricemat", "The basis") +}; + +const char* ANALYSIS_Mduration[] = +{ + NC_("ANALYSIS_Mduration", "Returns the Macaulay modified duration for a security with an assumed par value of 100 currency units"), + NC_("ANALYSIS_Mduration", "Settlement"), + NC_("ANALYSIS_Mduration", "The settlement"), + NC_("ANALYSIS_Mduration", "Maturity"), + NC_("ANALYSIS_Mduration", "The maturity"), + NC_("ANALYSIS_Mduration", "Coupon"), + NC_("ANALYSIS_Mduration", "The coupon rate"), + NC_("ANALYSIS_Mduration", "Yield"), + NC_("ANALYSIS_Mduration", "The yield"), + NC_("ANALYSIS_Mduration", "Frequency"), + NC_("ANALYSIS_Mduration", "The frequency"), + NC_("ANALYSIS_Mduration", "Basis"), + NC_("ANALYSIS_Mduration", "The basis") +}; + +const char* ANALYSIS_Nominal[] = +{ + NC_("ANALYSIS_Nominal", "Returns the annual nominal interest rate"), + NC_("ANALYSIS_Nominal", "Effective rate"), + NC_("ANALYSIS_Nominal", "The effective interest rate"), + NC_("ANALYSIS_Nominal", "Npery"), + NC_("ANALYSIS_Nominal", "The periods") +}; + +const char* ANALYSIS_Dollarfr[] = +{ + NC_("ANALYSIS_Dollarfr", "Converts a price expressed as a decimal into a price expressed as a fraction"), + NC_("ANALYSIS_Dollarfr", "Decimal dollar"), + NC_("ANALYSIS_Dollarfr", "The decimal number"), + NC_("ANALYSIS_Dollarfr", "Fraction"), + NC_("ANALYSIS_Dollarfr", "The divisor") +}; + +const char* ANALYSIS_Dollarde[] = +{ + NC_("ANALYSIS_Dollarde", "Converts a price expressed as a fraction into a price expressed as a decimal"), + NC_("ANALYSIS_Dollarde", "Fractional dollar"), + NC_("ANALYSIS_Dollarde", "The number as a fraction"), + NC_("ANALYSIS_Dollarde", "Fraction"), + NC_("ANALYSIS_Dollarde", "The divisor") +}; + +const char* ANALYSIS_Yield[] = +{ + NC_("ANALYSIS_Yield", "Returns the yield on a security that pays periodic interest"), + NC_("ANALYSIS_Yield", "Settlement"), + NC_("ANALYSIS_Yield", "The settlement"), + NC_("ANALYSIS_Yield", "Maturity"), + NC_("ANALYSIS_Yield", "The maturity"), + NC_("ANALYSIS_Yield", "Rate"), + NC_("ANALYSIS_Yield", "The rate"), + NC_("ANALYSIS_Yield", "Price"), + NC_("ANALYSIS_Yield", "The price"), + NC_("ANALYSIS_Yield", "Redemption"), + NC_("ANALYSIS_Yield", "The redemption value"), + NC_("ANALYSIS_Yield", "Frequency"), + NC_("ANALYSIS_Yield", "The frequency"), + NC_("ANALYSIS_Yield", "Basis"), + NC_("ANALYSIS_Yield", "The basis") +}; + +const char* ANALYSIS_Yielddisc[] = +{ + NC_("ANALYSIS_Yielddisc", "Returns the annual yield for a discounted security"), + NC_("ANALYSIS_Yielddisc", "Settlement"), + NC_("ANALYSIS_Yielddisc", "The settlement"), + NC_("ANALYSIS_Yielddisc", "Maturity"), + NC_("ANALYSIS_Yielddisc", "The maturity"), + NC_("ANALYSIS_Yielddisc", "Price"), + NC_("ANALYSIS_Yielddisc", "The price"), + NC_("ANALYSIS_Yielddisc", "Redemption"), + NC_("ANALYSIS_Yielddisc", "The redemption value"), + NC_("ANALYSIS_Yielddisc", "Basis"), + NC_("ANALYSIS_Yielddisc", "The basis") +}; + +const char* ANALYSIS_Yieldmat[] = +{ + NC_("ANALYSIS_Yieldmat", "Returns the annual yield of a security that pays interest at maturity"), + NC_("ANALYSIS_Yieldmat", "Settlement"), + NC_("ANALYSIS_Yieldmat", "The settlement"), + NC_("ANALYSIS_Yieldmat", "Maturity"), + NC_("ANALYSIS_Yieldmat", "The maturity"), + NC_("ANALYSIS_Yieldmat", "Issue"), + NC_("ANALYSIS_Yieldmat", "The issue date"), + NC_("ANALYSIS_Yieldmat", "Rate"), + NC_("ANALYSIS_Yieldmat", "The rate"), + NC_("ANALYSIS_Yieldmat", "Price"), + NC_("ANALYSIS_Yieldmat", "The price"), + NC_("ANALYSIS_Yieldmat", "Basis"), + NC_("ANALYSIS_Yieldmat", "The basis") +}; + +const char* ANALYSIS_Tbilleq[] = +{ + NC_("ANALYSIS_Tbilleq", "Returns the bond-equivalent yield for a treasury bill"), + NC_("ANALYSIS_Tbilleq", "Settlement"), + NC_("ANALYSIS_Tbilleq", "The settlement"), + NC_("ANALYSIS_Tbilleq", "Maturity"), + NC_("ANALYSIS_Tbilleq", "The maturity"), + NC_("ANALYSIS_Tbilleq", "Discount"), + NC_("ANALYSIS_Tbilleq", "The discount rate") +}; + +const char* ANALYSIS_Tbillprice[] = +{ + NC_("ANALYSIS_Tbillprice", "Returns the price of 100 currency units face value for a treasury bill"), + NC_("ANALYSIS_Tbillprice", "Settlement"), + NC_("ANALYSIS_Tbillprice", "The settlement"), + NC_("ANALYSIS_Tbillprice", "Maturity"), + NC_("ANALYSIS_Tbillprice", "The maturity"), + NC_("ANALYSIS_Tbillprice", "Discount"), + NC_("ANALYSIS_Tbillprice", "The discount rate") +}; + +const char* ANALYSIS_Tbillyield[] = +{ + NC_("ANALYSIS_Tbillyield", "Returns the yield for a treasury bill"), + NC_("ANALYSIS_Tbillyield", "Settlement"), + NC_("ANALYSIS_Tbillyield", "The settlement"), + NC_("ANALYSIS_Tbillyield", "Maturity"), + NC_("ANALYSIS_Tbillyield", "The maturity"), + NC_("ANALYSIS_Tbillyield", "Price"), + NC_("ANALYSIS_Tbillyield", "The price") +}; + +const char* ANALYSIS_Oddfprice[] = +{ + NC_("ANALYSIS_Oddfprice", "Returns the price per $100 face value of a security with an odd first period"), + NC_("ANALYSIS_Oddfprice", "Settlement"), + NC_("ANALYSIS_Oddfprice", "The settlement"), + NC_("ANALYSIS_Oddfprice", "Maturity"), + NC_("ANALYSIS_Oddfprice", "The maturity"), + NC_("ANALYSIS_Oddfprice", "Issue"), + NC_("ANALYSIS_Oddfprice", "The issue date"), + NC_("ANALYSIS_Oddfprice", "First coupon"), + NC_("ANALYSIS_Oddfprice", "The first coupon date"), + NC_("ANALYSIS_Oddfprice", "Rate"), + NC_("ANALYSIS_Oddfprice", "The rate"), + NC_("ANALYSIS_Oddfprice", "Yield"), + NC_("ANALYSIS_Oddfprice", "The yield"), + NC_("ANALYSIS_Oddfprice", "Redemption"), + NC_("ANALYSIS_Oddfprice", "The redemption value"), + NC_("ANALYSIS_Oddfprice", "Frequency"), + NC_("ANALYSIS_Oddfprice", "The frequency"), + NC_("ANALYSIS_Oddfprice", "Basis"), + NC_("ANALYSIS_Oddfprice", "The basis") +}; + +const char* ANALYSIS_Oddfyield[] = +{ + NC_("ANALYSIS_Oddfyield", "Returns the yield of a security with an odd first period"), + NC_("ANALYSIS_Oddfyield", "Settlement"), + NC_("ANALYSIS_Oddfyield", "The settlement"), + NC_("ANALYSIS_Oddfyield", "Maturity"), + NC_("ANALYSIS_Oddfyield", "The maturity"), + NC_("ANALYSIS_Oddfyield", "Issue"), + NC_("ANALYSIS_Oddfyield", "The issue date"), + NC_("ANALYSIS_Oddfyield", "First coupon"), + NC_("ANALYSIS_Oddfyield", "The first coupon date"), + NC_("ANALYSIS_Oddfyield", "Rate"), + NC_("ANALYSIS_Oddfyield", "The rate"), + NC_("ANALYSIS_Oddfyield", "Price"), + NC_("ANALYSIS_Oddfyield", "The price"), + NC_("ANALYSIS_Oddfyield", "Redemption"), + NC_("ANALYSIS_Oddfyield", "The redemption value"), + NC_("ANALYSIS_Oddfyield", "Frequency"), + NC_("ANALYSIS_Oddfyield", "The frequency"), + NC_("ANALYSIS_Oddfyield", "Basis"), + NC_("ANALYSIS_Oddfyield", "The basis") +}; + +const char* ANALYSIS_Oddlprice[] = +{ + NC_("ANALYSIS_Oddlprice", "Returns the price per $100 face value of a security with an odd last period"), + NC_("ANALYSIS_Oddlprice", "Settlement"), + NC_("ANALYSIS_Oddlprice", "The settlement"), + NC_("ANALYSIS_Oddlprice", "Maturity"), + NC_("ANALYSIS_Oddlprice", "The maturity"), + NC_("ANALYSIS_Oddlprice", "Last interest"), + NC_("ANALYSIS_Oddlprice", "The last interest date"), + NC_("ANALYSIS_Oddlprice", "Rate"), + NC_("ANALYSIS_Oddlprice", "The rate"), + NC_("ANALYSIS_Oddlprice", "Yield"), + NC_("ANALYSIS_Oddlprice", "The yield"), + NC_("ANALYSIS_Oddlprice", "Redemption"), + NC_("ANALYSIS_Oddlprice", "The redemption value"), + NC_("ANALYSIS_Oddlprice", "Frequency"), + NC_("ANALYSIS_Oddlprice", "The frequency"), + NC_("ANALYSIS_Oddlprice", "Basis"), + NC_("ANALYSIS_Oddlprice", "The basis") +}; + +const char* ANALYSIS_Oddlyield[] = +{ + NC_("ANALYSIS_Oddlyield", "Returns the yield of a security with an odd last period"), + NC_("ANALYSIS_Oddlyield", "Settlement"), + NC_("ANALYSIS_Oddlyield", "The settlement"), + NC_("ANALYSIS_Oddlyield", "Maturity"), + NC_("ANALYSIS_Oddlyield", "The maturity"), + NC_("ANALYSIS_Oddlyield", "Last interest"), + NC_("ANALYSIS_Oddlyield", "The last interest date"), + NC_("ANALYSIS_Oddlyield", "Rate"), + NC_("ANALYSIS_Oddlyield", "The rate"), + NC_("ANALYSIS_Oddlyield", "Price"), + NC_("ANALYSIS_Oddlyield", "The price"), + NC_("ANALYSIS_Oddlyield", "Redemption"), + NC_("ANALYSIS_Oddlyield", "The redemption value"), + NC_("ANALYSIS_Oddlyield", "Frequency"), + NC_("ANALYSIS_Oddlyield", "The frequency"), + NC_("ANALYSIS_Oddlyield", "Basis"), + NC_("ANALYSIS_Oddlyield", "The basis") +}; + +const char* ANALYSIS_Xirr[] = +{ + NC_("ANALYSIS_Xirr", "Returns the internal rate of return for a non-periodic schedule of payments"), + NC_("ANALYSIS_Xirr", "Values"), + NC_("ANALYSIS_Xirr", "The values"), + NC_("ANALYSIS_Xirr", "Dates"), + NC_("ANALYSIS_Xirr", "The dates"), + NC_("ANALYSIS_Xirr", "Guess"), + NC_("ANALYSIS_Xirr", "The guess") +}; + +const char* ANALYSIS_Xnpv[] = +{ + NC_("ANALYSIS_Xnpv", "Returns the net present value for a non-periodic schedule of payments"), + NC_("ANALYSIS_Xnpv", "Rate"), + NC_("ANALYSIS_Xnpv", "The rate"), + NC_("ANALYSIS_Xnpv", "Values"), + NC_("ANALYSIS_Xnpv", "The values"), + NC_("ANALYSIS_Xnpv", "Dates"), + NC_("ANALYSIS_Xnpv", "The dates") +}; + +const char* ANALYSIS_Intrate[] = +{ + NC_("ANALYSIS_Intrate", "Returns the interest rate for a fully invested security"), + NC_("ANALYSIS_Intrate", "Settlement"), + NC_("ANALYSIS_Intrate", "The settlement"), + NC_("ANALYSIS_Intrate", "Maturity"), + NC_("ANALYSIS_Intrate", "The maturity"), + NC_("ANALYSIS_Intrate", "Investment"), + NC_("ANALYSIS_Intrate", "The investment"), + NC_("ANALYSIS_Intrate", "Redemption"), + NC_("ANALYSIS_Intrate", "The redemption value"), + NC_("ANALYSIS_Intrate", "Basis"), + NC_("ANALYSIS_Intrate", "The basis") +}; + +const char* ANALYSIS_Coupncd[] = +{ + NC_("ANALYSIS_Coupncd", "Returns the first coupon date after the settlement date"), + NC_("ANALYSIS_Coupncd", "Settlement"), + NC_("ANALYSIS_Coupncd", "The settlement"), + NC_("ANALYSIS_Coupncd", "Maturity"), + NC_("ANALYSIS_Coupncd", "The maturity"), + NC_("ANALYSIS_Coupncd", "Frequency"), + NC_("ANALYSIS_Coupncd", "The frequency"), + NC_("ANALYSIS_Coupncd", "Basis"), + NC_("ANALYSIS_Coupncd", "The basis") +}; + +const char* ANALYSIS_Coupdays[] = +{ + NC_("ANALYSIS_Coupdays", "Returns the number of days in the coupon period containing the settlement date"), + NC_("ANALYSIS_Coupdays", "Settlement"), + NC_("ANALYSIS_Coupdays", "The settlement"), + NC_("ANALYSIS_Coupdays", "Maturity"), + NC_("ANALYSIS_Coupdays", "The maturity"), + NC_("ANALYSIS_Coupdays", "Frequency"), + NC_("ANALYSIS_Coupdays", "The frequency"), + NC_("ANALYSIS_Coupdays", "Basis"), + NC_("ANALYSIS_Coupdays", "The basis") +}; + +const char* ANALYSIS_Coupdaysnc[] = +{ + NC_("ANALYSIS_Coupdaysnc", "Returns the number of days from the settlement date to the next coupon date"), + NC_("ANALYSIS_Coupdaysnc", "Settlement"), + NC_("ANALYSIS_Coupdaysnc", "The settlement"), + NC_("ANALYSIS_Coupdaysnc", "Maturity"), + NC_("ANALYSIS_Coupdaysnc", "The maturity"), + NC_("ANALYSIS_Coupdaysnc", "Frequency"), + NC_("ANALYSIS_Coupdaysnc", "The frequency"), + NC_("ANALYSIS_Coupdaysnc", "Basis"), + NC_("ANALYSIS_Coupdaysnc", "The basis") +}; + +const char* ANALYSIS_Coupdaybs[] = +{ + NC_("ANALYSIS_Coupdaybs", "Returns the number of days from the beginning of the coupon period to the settlement date"), + NC_("ANALYSIS_Coupdaybs", "Settlement"), + NC_("ANALYSIS_Coupdaybs", "The settlement"), + NC_("ANALYSIS_Coupdaybs", "Maturity"), + NC_("ANALYSIS_Coupdaybs", "The maturity"), + NC_("ANALYSIS_Coupdaybs", "Frequency"), + NC_("ANALYSIS_Coupdaybs", "The frequency"), + NC_("ANALYSIS_Coupdaybs", "Basis"), + NC_("ANALYSIS_Coupdaybs", "The basis") +}; + +const char* ANALYSIS_Couppcd[] = +{ + NC_("ANALYSIS_Couppcd", "Returns the last coupon date preceding the settlement date"), + NC_("ANALYSIS_Couppcd", "Settlement"), + NC_("ANALYSIS_Couppcd", "The settlement"), + NC_("ANALYSIS_Couppcd", "Maturity"), + NC_("ANALYSIS_Couppcd", "The maturity"), + NC_("ANALYSIS_Couppcd", "Frequency"), + NC_("ANALYSIS_Couppcd", "The frequency"), + NC_("ANALYSIS_Couppcd", "Basis"), + NC_("ANALYSIS_Couppcd", "The basis") +}; + +const char* ANALYSIS_Coupnum[] = +{ + NC_("ANALYSIS_Coupnum", "Returns the number of coupons payable between the settlement and maturity dates"), + NC_("ANALYSIS_Coupnum", "Settlement"), + NC_("ANALYSIS_Coupnum", "The settlement"), + NC_("ANALYSIS_Coupnum", "Maturity"), + NC_("ANALYSIS_Coupnum", "The maturity"), + NC_("ANALYSIS_Coupnum", "Frequency"), + NC_("ANALYSIS_Coupnum", "The frequency"), + NC_("ANALYSIS_Coupnum", "Basis"), + NC_("ANALYSIS_Coupnum", "The basis") +}; + +const char* ANALYSIS_Fvschedule[] = +{ + NC_("ANALYSIS_Fvschedule", "Returns the future value of the initial principal after a series of compound interest rates are applied"), + NC_("ANALYSIS_Fvschedule", "Principal"), + NC_("ANALYSIS_Fvschedule", "The principal"), + NC_("ANALYSIS_Fvschedule", "Schedule"), + NC_("ANALYSIS_Fvschedule", "The schedule") +}; + +#endif + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/inc/datefunc.hrc b/scaddins/inc/datefunc.hrc new file mode 100644 index 000000000000..f5401fb299df --- /dev/null +++ b/scaddins/inc/datefunc.hrc @@ -0,0 +1,95 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#ifndef INCLUDED_SCADDINS_INC_PRICING_HRC +#define INCLUDED_SCADDINS_INC_PRICING_HRC + +#define NC_(Context, String) (Context "\004" u8##String) + +const char* DATE_FUNCDESC_DiffWeeks[] = +{ + NC_("DATE_FUNCDESC_DiffWeeks", "Calculates the number of weeks in a specific period"), + NC_("DATE_FUNCDESC_DiffWeeks", "Start date"), + NC_("DATE_FUNCDESC_DiffWeeks", "First day of the period"), + NC_("DATE_FUNCDESC_DiffWeeks", "End date"), + NC_("DATE_FUNCDESC_DiffWeeks", "Last day of the period"), + NC_("DATE_FUNCDESC_DiffWeeks", "Type"), + NC_("DATE_FUNCDESC_DiffWeeks", "Type of calculation: Type=0 means the time interval, Type=1 means calendar weeks.") +}; + +const char* DATE_FUNCDESC_DiffMonths[] = +{ + NC_("DATE_FUNCDESC_DiffMonths", "Determines the number of months in a specific period."), + NC_("DATE_FUNCDESC_DiffMonths", "Start date"), + NC_("DATE_FUNCDESC_DiffMonths", "First day of the period."), + NC_("DATE_FUNCDESC_DiffMonths", "End date"), + NC_("DATE_FUNCDESC_DiffMonths", "Last day of the period."), + NC_("DATE_FUNCDESC_DiffMonths", "Type"), + NC_("DATE_FUNCDESC_DiffMonths", "Type of calculation: Type=0 means the time interval, Type=1 means calendar months.") +}; + +const char* DATE_FUNCDESC_DiffYears[] = +{ + NC_("DATE_FUNCDESC_DiffYears", "Calculates the number of years in a specific period."), + NC_("DATE_FUNCDESC_DiffYears", "Start date"), + NC_("DATE_FUNCDESC_DiffYears", "First day of the period"), + NC_("DATE_FUNCDESC_DiffYears", "End date"), + NC_("DATE_FUNCDESC_DiffYears", "Last day of the period"), + NC_("DATE_FUNCDESC_DiffYears", "Type"), + NC_("DATE_FUNCDESC_DiffYears", "Type of calculation: Type=0 means the time interval, Type=1 means calendar years.") +}; + +const char* DATE_FUNCDESC_IsLeapYear[] = +{ + NC_("DATE_FUNCDESC_IsLeapYear", "Returns 1 (TRUE) if the date is a day of a leap year, otherwise 0 (FALSE)."), + NC_("DATE_FUNCDESC_IsLeapYear", "Date"), + NC_("DATE_FUNCDESC_IsLeapYear", "Any day in the desired year") +}; + +const char* DATE_FUNCDESC_DaysInMonth[] = +{ + NC_("DATE_FUNCDESC_DaysInMonth", "Returns the number of days of the month in which the date entered occurs"), + NC_("DATE_FUNCDESC_DaysInMonth", "Date"), + NC_("DATE_FUNCDESC_DaysInMonth", "Any day in the desired month") +}; + +const char* DATE_FUNCDESC_DaysInYear[] = +{ + NC_("DATE_FUNCDESC_DaysInYear", "Returns the number of days of the year in which the date entered occurs."), + NC_("DATE_FUNCDESC_DaysInYear", "Date"), + NC_("DATE_FUNCDESC_DaysInYear", "Any day in the desired year") +}; + +const char* DATE_FUNCDESC_WeeksInYear[] = +{ + NC_("DATE_FUNCDESC_WeeksInYear", "Returns the number of weeks of the year in which the date entered occurs"), + NC_("DATE_FUNCDESC_WeeksInYear", "Date"), + NC_("DATE_FUNCDESC_WeeksInYear", "Any day in the desired year") +}; + +const char* DATE_FUNCDESC_Rot13[] = +{ + NC_("DATE_FUNCDESC_Rot13", "Encrypts or decrypts a text using the ROT13 algorithm"), + NC_("DATE_FUNCDESC_Rot13", "Text"), + NC_("DATE_FUNCDESC_Rot13", "Text to be encrypted or text already encrypted") +}; + +#endif + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/inc/pricing.hrc b/scaddins/inc/pricing.hrc new file mode 100644 index 000000000000..c54a387a86fc --- /dev/null +++ b/scaddins/inc/pricing.hrc @@ -0,0 +1,124 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#ifndef INCLUDED_SCADDINS_INC_PRICING_HRC +#define INCLUDED_SCADDINS_INC_PRICING_HRC + +#define NC_(Context, String) (Context "\004" u8##String) + +// function and parameter description +const char* PRICING_FUNCDESC_OptBarrier[] = +{ + NC_("PRICING_FUNCDESC_OptBarrier", "Pricing of a barrier option"), + NC_("PRICING_FUNCDESC_OptBarrier", "spot"), + NC_("PRICING_FUNCDESC_OptBarrier", "Price/value of the underlying asset"), + NC_("PRICING_FUNCDESC_OptBarrier", "vol"), + NC_("PRICING_FUNCDESC_OptBarrier", "Annual volatility of the underlying asset"), + NC_("PRICING_FUNCDESC_OptBarrier", "r"), + NC_("PRICING_FUNCDESC_OptBarrier", "Interest rate (continuously compounded)"), + NC_("PRICING_FUNCDESC_OptBarrier", "rf"), + NC_("PRICING_FUNCDESC_OptBarrier", "Foreign interest rate (continuously compounded)"), + NC_("PRICING_FUNCDESC_OptBarrier", "T"), + NC_("PRICING_FUNCDESC_OptBarrier", "Time to maturity of the option in years"), + NC_("PRICING_FUNCDESC_OptBarrier", "strike"), + NC_("PRICING_FUNCDESC_OptBarrier", "Strike level of the option"), + NC_("PRICING_FUNCDESC_OptBarrier", "barrier_low"), + NC_("PRICING_FUNCDESC_OptBarrier", "Lower barrier (set to 0 for no lower barrier)"), + NC_("PRICING_FUNCDESC_OptBarrier", "barrier_up"), + NC_("PRICING_FUNCDESC_OptBarrier", "Upper barrier (set to 0 for no upper barrier)"), + NC_("PRICING_FUNCDESC_OptBarrier", "rebate"), + NC_("PRICING_FUNCDESC_OptBarrier", "Amount of money paid at maturity if barrier was hit"), + NC_("PRICING_FUNCDESC_OptBarrier", "put/call"), + NC_("PRICING_FUNCDESC_OptBarrier", "String to define if the option is a (p)ut or a (c)all"), + NC_("PRICING_FUNCDESC_OptBarrier", "knock in/out"), + NC_("PRICING_FUNCDESC_OptBarrier", "String to define if the option is of type knock-(i)n or knock-(o)ut"), + NC_("PRICING_FUNCDESC_OptBarrier", "barrier_type"), + NC_("PRICING_FUNCDESC_OptBarrier", "String to define whether the barrier is observed (c)ontinuously or only at the (e)nd/maturity"), + NC_("PRICING_FUNCDESC_OptBarrier", "greek"), + NC_("PRICING_FUNCDESC_OptBarrier", "Optional parameter, if left out then the function simply returns the option price; if set, the function returns price sensitivities (Greeks) to one of the input parameters; possible values are (d)elta, (g)amma, (t)heta, v(e)ga, v(o)lga, v(a)nna, (r)ho, rho(f)") +}; + +const char* PRICING_FUNCDESC_OptTouch[] = +{ + NC_("PRICING_FUNCDESC_OptTouch", "Pricing of a touch/no-touch option"), + NC_("PRICING_FUNCDESC_OptTouch", "spot"), + NC_("PRICING_FUNCDESC_OptTouch", "Price/value of the underlying asset"), + NC_("PRICING_FUNCDESC_OptTouch", "vol"), + NC_("PRICING_FUNCDESC_OptTouch", "Annual volatility of the underlying asset"), + NC_("PRICING_FUNCDESC_OptTouch", "r"), + NC_("PRICING_FUNCDESC_OptTouch", "Interest rate (continuously compounded)"), + NC_("PRICING_FUNCDESC_OptTouch", "rf"), + NC_("PRICING_FUNCDESC_OptTouch", "Foreign interest rate (continuously compounded)"), + NC_("PRICING_FUNCDESC_OptTouch", "T"), + NC_("PRICING_FUNCDESC_OptTouch", "Time to maturity of the option in years"), + NC_("PRICING_FUNCDESC_OptTouch", "barrier_low"), + NC_("PRICING_FUNCDESC_OptTouch", "Lower barrier (set to 0 for no lower barrier)"), + NC_("PRICING_FUNCDESC_OptTouch", "barrier_up"), + NC_("PRICING_FUNCDESC_OptTouch", "Upper barrier (set to 0 for no upper barrier)"), + NC_("PRICING_FUNCDESC_OptTouch", "foreign/domestic"), + NC_("PRICING_FUNCDESC_OptTouch", "String to define if the option pays one unit of (d)omestic currency (cash or nothing) or (f)oreign currency (asset or nothing)"), + NC_("PRICING_FUNCDESC_OptTouch", "knock in/out"), + NC_("PRICING_FUNCDESC_OptTouch", "String to define if the option is of type knock-(i)n (touch) or knock-(o)ut (no-touch)"), + NC_("PRICING_FUNCDESC_OptTouch", "barrier_type"), + NC_("PRICING_FUNCDESC_OptTouch", "String to define whether the barrier is observed (c)ontinuously or only at the (e)nd/maturity"), + NC_("PRICING_FUNCDESC_OptTouch", "greek"), + NC_("PRICING_FUNCDESC_OptTouch", "Optional parameter, if left out then the function simply returns the option price; if set, the function returns price sensitivities (Greeks) to one of the input parameters; possible values are (d)elta, (g)amma, (t)heta, v(e)ga, v(o)lga, v(a)nna, (r)ho, rho(f)") +}; + +const char* PRICING_FUNCDESC_OptProbHit[] = +{ + NC_("PRICING_FUNCDESC_OptProbHit", "Probability that an asset hits a barrier assuming it follows dS/S = mu dt + vol dW"), + NC_("PRICING_FUNCDESC_OptProbHit", "spot"), + NC_("PRICING_FUNCDESC_OptProbHit", "Price/value S of the underlying asset"), + NC_("PRICING_FUNCDESC_OptProbHit", "vol"), + NC_("PRICING_FUNCDESC_OptProbHit", "Annual volatility of the underlying asset"), + NC_("PRICING_FUNCDESC_OptProbHit", "drift"), + NC_("PRICING_FUNCDESC_OptProbHit", "Parameter mu in dS/S = mu dt + vol dW"), + NC_("PRICING_FUNCDESC_OptProbHit", "T"), + NC_("PRICING_FUNCDESC_OptProbHit", "Time to maturity"), + NC_("PRICING_FUNCDESC_OptProbHit", "barrier_low"), + NC_("PRICING_FUNCDESC_OptProbHit", "Lower barrier (set to 0 for no lower barrier)"), + NC_("PRICING_FUNCDESC_OptProbHit", "barrier_up"), + NC_("PRICING_FUNCDESC_OptProbHit", "Upper barrier (set to 0 for no upper barrier)") +}; + +const char* PRICING_FUNCDESC_OptProbInMoney[] = +{ + NC_("PRICING_FUNCDESC_OptProbInMoney", "Probability that an asset will at maturity end up between two barrier levels, assuming it follows dS/S = mu dt + vol dW (if the last two optional parameters (strike, put/call) are specified, the probability of S_T in [strike, upper barrier] for a call and S_T in [lower barrier, strike] for a put will be returned)"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "spot"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Price/value of the asset"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "vol"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Annual volatility of the asset"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "drift"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Parameter mu from dS/S = mu dt + vol dW"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "T"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Time to maturity in years"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "barrier_low"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Lower barrier (set to 0 for no lower barrier)"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "barrier_up"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Upper barrier (set to 0 for no upper barrier)"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "put/call"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Optional (p)ut/(c)all indicator"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "strike"), + NC_("PRICING_FUNCDESC_OptProbInMoney", "Optional strike level") +}; + +#endif + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/inc/strings.hrc b/scaddins/inc/strings.hrc new file mode 100644 index 000000000000..b7ab057e4f8e --- /dev/null +++ b/scaddins/inc/strings.hrc @@ -0,0 +1,144 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +#ifndef INCLUDED_SCADDINS_INC_STRINGS_HRC +#define INCLUDED_SCADDINS_INC_STRINGS_HRC + +#define NC_(Context, String) (Context "\004" u8##String) + +// function names as accessible from cells +#define PRICING_FUNCNAME_OptBarrier NC_("PRICING_FUNCNAME_OptBarrier", "OPT_BARRIER") +#define PRICING_FUNCNAME_OptTouch NC_("PRICING_FUNCNAME_OptTouch", "OPT_TOUCH") +#define PRICING_FUNCNAME_OptProbHit NC_("PRICING_FUNCNAME_OptProbHit", "OPT_PROB_HIT") +#define PRICING_FUNCNAME_OptProbInMoney NC_("PRICING_FUNCNAME_OptProbInMoney", "OPT_PROB_INMONEY") + +#define DATE_FUNCNAME_DiffWeeks NC_("DATE_FUNCNAME_DiffWeeks", "WEEKS") +#define DATE_FUNCNAME_DiffMonths NC_("DATE_FUNCNAME_DiffMonths", "MONTHS") +#define DATE_FUNCNAME_DiffYears NC_("DATE_FUNCNAME_DiffYears", "YEARS") +#define DATE_FUNCNAME_IsLeapYear NC_("DATE_FUNCNAME_IsLeapYear", "ISLEAPYEAR") +#define DATE_FUNCNAME_DaysInMonth NC_("DATE_FUNCNAME_DaysInMonth", "DAYSINMONTH") +#define DATE_FUNCNAME_DaysInYear NC_("DATE_FUNCNAME_DaysInYear", "DAYSINYEAR") +#define DATE_FUNCNAME_WeeksInYear NC_("DATE_FUNCNAME_WeeksInYear", "WEEKSINYEAR") +#define DATE_FUNCNAME_Rot13 NC_("DATE_FUNCNAME_Rot13", "ROT13") + +#define ANALYSIS_FUNCNAME_Workday NC_("ANALYSIS_FUNCNAME_Workday", "WORKDAY") +#define ANALYSIS_FUNCNAME_Yearfrac NC_("ANALYSIS_FUNCNAME_Yearfrac", "YEARFRAC") +#define ANALYSIS_FUNCNAME_Edate NC_("ANALYSIS_FUNCNAME_Edate", "EDATE") +#define ANALYSIS_FUNCNAME_Weeknum NC_("ANALYSIS_FUNCNAME_Weeknum", "WEEKNUM") +#define ANALYSIS_FUNCNAME_Eomonth NC_("ANALYSIS_FUNCNAME_Eomonth", "EOMONTH") +#define ANALYSIS_FUNCNAME_Networkdays NC_("ANALYSIS_FUNCNAME_Networkdays", "NETWORKDAYS") +#define ANALYSIS_FUNCNAME_Amordegrc NC_("ANALYSIS_FUNCNAME_Amordegrc", "AMORDEGRC") +#define ANALYSIS_FUNCNAME_Amorlinc NC_("ANALYSIS_FUNCNAME_Amorlinc", "AMORLINC") +#define ANALYSIS_FUNCNAME_Accrint NC_("ANALYSIS_FUNCNAME_Accrint", "ACCRINT") +#define ANALYSIS_FUNCNAME_Accrintm NC_("ANALYSIS_FUNCNAME_Accrintm", "ACCRINTM") +#define ANALYSIS_FUNCNAME_Received NC_("ANALYSIS_FUNCNAME_Received", "RECEIVED") +#define ANALYSIS_FUNCNAME_Disc NC_("ANALYSIS_FUNCNAME_Disc", "DISC") +#define ANALYSIS_FUNCNAME_Duration NC_("ANALYSIS_FUNCNAME_Duration", "DURATION") +#define ANALYSIS_FUNCNAME_Effect NC_("ANALYSIS_FUNCNAME_Effect", "EFFECT") +#define ANALYSIS_FUNCNAME_Cumprinc NC_("ANALYSIS_FUNCNAME_Cumprinc", "CUMPRINC") +#define ANALYSIS_FUNCNAME_Cumipmt NC_("ANALYSIS_FUNCNAME_Cumipmt", "CUMIPMT") +#define ANALYSIS_FUNCNAME_Price NC_("ANALYSIS_FUNCNAME_Price", "PRICE") +#define ANALYSIS_FUNCNAME_Pricedisc NC_("ANALYSIS_FUNCNAME_Pricedisc", "PRICEDISC") +#define ANALYSIS_FUNCNAME_Pricemat NC_("ANALYSIS_FUNCNAME_Pricemat", "PRICEMAT") +#define ANALYSIS_FUNCNAME_Mduration NC_("ANALYSIS_FUNCNAME_Mduration", "MDURATION") +#define ANALYSIS_FUNCNAME_Nominal NC_("ANALYSIS_FUNCNAME_Nominal", "NOMINAL") +#define ANALYSIS_FUNCNAME_Dollarfr NC_("ANALYSIS_FUNCNAME_Dollarfr", "DOLLARFR") +#define ANALYSIS_FUNCNAME_Dollarde NC_("ANALYSIS_FUNCNAME_Dollarde", "DOLLARDE") +#define ANALYSIS_FUNCNAME_Yield NC_("ANALYSIS_FUNCNAME_Yield", "YIELD") +#define ANALYSIS_FUNCNAME_Yielddisc NC_("ANALYSIS_FUNCNAME_Yielddisc", "YIELDDISC") +#define ANALYSIS_FUNCNAME_Yieldmat NC_("ANALYSIS_FUNCNAME_Yieldmat", "YIELDMAT") +#define ANALYSIS_FUNCNAME_Tbilleq NC_("ANALYSIS_FUNCNAME_Tbilleq", "TBILLEQ") +#define ANALYSIS_FUNCNAME_Tbillprice NC_("ANALYSIS_FUNCNAME_Tbillprice", "TBILLPRICE") +#define ANALYSIS_FUNCNAME_Tbillyield NC_("ANALYSIS_FUNCNAME_Tbillyield", "TBILLYIELD") +#define ANALYSIS_FUNCNAME_Oddfprice NC_("ANALYSIS_FUNCNAME_Oddfprice", "ODDFPRICE") +#define ANALYSIS_FUNCNAME_Oddfyield NC_("ANALYSIS_FUNCNAME_Oddfyield", "ODDFYIELD") +#define ANALYSIS_FUNCNAME_Oddlprice NC_("ANALYSIS_FUNCNAME_Oddlprice", "ODDLPRICE") +#define ANALYSIS_FUNCNAME_Oddlyield NC_("ANALYSIS_FUNCNAME_Oddlyield", "ODDLYIELD") +#define ANALYSIS_FUNCNAME_Xirr NC_("ANALYSIS_FUNCNAME_Xirr", "XIRR") +#define ANALYSIS_FUNCNAME_Xnpv NC_("ANALYSIS_FUNCNAME_Xnpv", "XNPV") +#define ANALYSIS_FUNCNAME_Intrate NC_("ANALYSIS_FUNCNAME_Intrate", "INTRATE") +#define ANALYSIS_FUNCNAME_Coupncd NC_("ANALYSIS_FUNCNAME_Coupncd", "COUPNCD") +#define ANALYSIS_FUNCNAME_Coupdays NC_("ANALYSIS_FUNCNAME_Coupdays", "COUPDAYS") +#define ANALYSIS_FUNCNAME_Coupdaysnc NC_("ANALYSIS_FUNCNAME_Coupdaysnc", "COUPDAYSNC") +#define ANALYSIS_FUNCNAME_Coupdaybs NC_("ANALYSIS_FUNCNAME_Coupdaybs", "COUPDAYBS") +#define ANALYSIS_FUNCNAME_Couppcd NC_("ANALYSIS_FUNCNAME_Couppcd", "COUPPCD") +#define ANALYSIS_FUNCNAME_Coupnum NC_("ANALYSIS_FUNCNAME_Coupnum", "COUPNUM") +#define ANALYSIS_FUNCNAME_Fvschedule NC_("ANALYSIS_FUNCNAME_Fvschedule", "FVSCHEDULE") +#define ANALYSIS_FUNCNAME_Iseven NC_("ANALYSIS_FUNCNAME_Iseven", "ISEVEN") +#define ANALYSIS_FUNCNAME_Isodd NC_("ANALYSIS_FUNCNAME_Isodd", "ISODD") +#define ANALYSIS_FUNCNAME_Gcd NC_("ANALYSIS_FUNCNAME_Gcd", "GCD") +#define ANALYSIS_FUNCNAME_Lcm NC_("ANALYSIS_FUNCNAME_Lcm", "LCM") +#define ANALYSIS_FUNCNAME_Multinomial NC_("ANALYSIS_FUNCNAME_Multinomial", "MULTINOMIAL") +#define ANALYSIS_FUNCNAME_Seriessum NC_("ANALYSIS_FUNCNAME_Seriessum", "SERIESSUM") +#define ANALYSIS_FUNCNAME_Quotient NC_("ANALYSIS_FUNCNAME_Quotient", "QUOTIENT") +#define ANALYSIS_FUNCNAME_Mround NC_("ANALYSIS_FUNCNAME_Mround", "MROUND") +#define ANALYSIS_FUNCNAME_Sqrtpi NC_("ANALYSIS_FUNCNAME_Sqrtpi", "SQRTPI") +#define ANALYSIS_FUNCNAME_Randbetween NC_("ANALYSIS_FUNCNAME_Randbetween", "RANDBETWEEN") +#define ANALYSIS_FUNCNAME_Besseli NC_("ANALYSIS_FUNCNAME_Besseli", "BESSELI") +#define ANALYSIS_FUNCNAME_Besselj NC_("ANALYSIS_FUNCNAME_Besselj", "BESSELJ") +#define ANALYSIS_FUNCNAME_Besselk NC_("ANALYSIS_FUNCNAME_Besselk", "BESSELK") +#define ANALYSIS_FUNCNAME_Bessely NC_("ANALYSIS_FUNCNAME_Bessely", "BESSELY") +#define ANALYSIS_FUNCNAME_Bin2Dec NC_("ANALYSIS_FUNCNAME_Bin2Dec", "BIN2DEC") +#define ANALYSIS_FUNCNAME_Bin2Hex NC_("ANALYSIS_FUNCNAME_Bin2Hex", "BIN2HEX") +#define ANALYSIS_FUNCNAME_Bin2Oct NC_("ANALYSIS_FUNCNAME_Bin2Oct", "BIN2OCT") +#define ANALYSIS_FUNCNAME_Delta NC_("ANALYSIS_FUNCNAME_Delta", "DELTA") +#define ANALYSIS_FUNCNAME_Dec2Bin NC_("ANALYSIS_FUNCNAME_Dec2Bin", "DEC2BIN") +#define ANALYSIS_FUNCNAME_Dec2Hex NC_("ANALYSIS_FUNCNAME_Dec2Hex", "DEC2HEX") +#define ANALYSIS_FUNCNAME_Dec2Oct NC_("ANALYSIS_FUNCNAME_Dec2Oct", "DEC2OCT") +#define ANALYSIS_FUNCNAME_Erf NC_("ANALYSIS_FUNCNAME_Erf", "ERF") +#define ANALYSIS_FUNCNAME_Erfc NC_("ANALYSIS_FUNCNAME_Erfc", "ERFC") +#define ANALYSIS_FUNCNAME_Gestep NC_("ANALYSIS_FUNCNAME_Gestep", "GESTEP") +#define ANALYSIS_FUNCNAME_Hex2Bin NC_("ANALYSIS_FUNCNAME_Hex2Bin", "HEX2BIN") +#define ANALYSIS_FUNCNAME_Hex2Dec NC_("ANALYSIS_FUNCNAME_Hex2Dec", "HEX2DEC") +#define ANALYSIS_FUNCNAME_Hex2Oct NC_("ANALYSIS_FUNCNAME_Hex2Oct", "HEX2OCT") +#define ANALYSIS_FUNCNAME_Imabs NC_("ANALYSIS_FUNCNAME_Imabs", "IMABS") +#define ANALYSIS_FUNCNAME_Imaginary NC_("ANALYSIS_FUNCNAME_Imaginary", "IMAGINARY") +#define ANALYSIS_FUNCNAME_Impower NC_("ANALYSIS_FUNCNAME_Impower", "IMPOWER") +#define ANALYSIS_FUNCNAME_Imargument NC_("ANALYSIS_FUNCNAME_Imargument", "IMARGUMENT") +#define ANALYSIS_FUNCNAME_Imcos NC_("ANALYSIS_FUNCNAME_Imcos", "IMCOS") +#define ANALYSIS_FUNCNAME_Imdiv NC_("ANALYSIS_FUNCNAME_Imdiv", "IMDIV") +#define ANALYSIS_FUNCNAME_Imexp NC_("ANALYSIS_FUNCNAME_Imexp", "IMEXP") +#define ANALYSIS_FUNCNAME_Imconjugate NC_("ANALYSIS_FUNCNAME_Imconjugate", "IMCONJUGATE") +#define ANALYSIS_FUNCNAME_Imln NC_("ANALYSIS_FUNCNAME_Imln", "IMLN") +#define ANALYSIS_FUNCNAME_Imlog10 NC_("ANALYSIS_FUNCNAME_Imlog10", "IMLOG10") +#define ANALYSIS_FUNCNAME_Imlog2 NC_("ANALYSIS_FUNCNAME_Imlog2", "IMLOG2") +#define ANALYSIS_FUNCNAME_Improduct NC_("ANALYSIS_FUNCNAME_Improduct", "IMPRODUCT") +#define ANALYSIS_FUNCNAME_Imreal NC_("ANALYSIS_FUNCNAME_Imreal", "IMREAL") +#define ANALYSIS_FUNCNAME_Imsin NC_("ANALYSIS_FUNCNAME_Imsin", "IMSIN") +#define ANALYSIS_FUNCNAME_Imsub NC_("ANALYSIS_FUNCNAME_Imsub", "IMSUB") +#define ANALYSIS_FUNCNAME_Imsum NC_("ANALYSIS_FUNCNAME_Imsum", "IMSUM") +#define ANALYSIS_FUNCNAME_Imsqrt NC_("ANALYSIS_FUNCNAME_Imsqrt", "IMSQRT") +#define ANALYSIS_FUNCNAME_Imtan NC_("ANALYSIS_FUNCNAME_Imtan", "IMTAN") +#define ANALYSIS_FUNCNAME_Imsec NC_("ANALYSIS_FUNCNAME_Imsec", "IMSEC") +#define ANALYSIS_FUNCNAME_Imcsc NC_("ANALYSIS_FUNCNAME_Imcsc", "IMCSC") +#define ANALYSIS_FUNCNAME_Imcot NC_("ANALYSIS_FUNCNAME_Imcot", "IMCOT") +#define ANALYSIS_FUNCNAME_Imsinh NC_("ANALYSIS_FUNCNAME_Imsinh", "IMSINH") +#define ANALYSIS_FUNCNAME_Imcosh NC_("ANALYSIS_FUNCNAME_Imcosh", "IMCOSH") +#define ANALYSIS_FUNCNAME_Imsech NC_("ANALYSIS_FUNCNAME_Imsech", "IMSECH") +#define ANALYSIS_FUNCNAME_Imcsch NC_("ANALYSIS_FUNCNAME_Imcsch", "IMCSCH") +#define ANALYSIS_FUNCNAME_Complex NC_("ANALYSIS_FUNCNAME_Complex", "COMPLEX") +#define ANALYSIS_FUNCNAME_Oct2Bin NC_("ANALYSIS_FUNCNAME_Oct2Bin", "OCT2BIN") +#define ANALYSIS_FUNCNAME_Oct2Dec NC_("ANALYSIS_FUNCNAME_Oct2Dec", "OCT2DEC") +#define ANALYSIS_FUNCNAME_Oct2Hex NC_("ANALYSIS_FUNCNAME_Oct2Hex", "OCT2HEX") +#define ANALYSIS_FUNCNAME_Convert NC_("ANALYSIS_FUNCNAME_Convert", "CONVERT") +#define ANALYSIS_FUNCNAME_Factdouble NC_("ANALYSIS_FUNCNAME_Factdouble", "FACTDOUBLE") + +#endif + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/analysis/analysis.cxx b/scaddins/source/analysis/analysis.cxx index 14a9b6b89481..4d98db9a1ea3 100644 --- a/scaddins/source/analysis/analysis.cxx +++ b/scaddins/source/analysis/analysis.cxx @@ -18,7 +18,7 @@ */ #include "analysis.hxx" -#include "analysis.hrc" +#include "strings.hrc" #include "bessel.hxx" #include <cppuhelper/factory.hxx> #include <comphelper/processfactory.hxx> @@ -29,9 +29,7 @@ #include <rtl/math.hxx> #include <sal/macros.h> #include <string.h> -#include <tools/resary.hxx> #include <tools/resmgr.hxx> -#include <tools/rcid.h> #include <algorithm> #include <cmath> @@ -66,29 +64,14 @@ extern "C" SAL_DLLPUBLIC_EXPORT void* SAL_CALL analysis_component_getFactory( return pRet; } -ResMgr& AnalysisAddIn::GetResMgr() +OUString AnalysisAddIn::GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex) { - if( !pResMgr ) - { - InitData(); // try to get resource manager - - if( !pResMgr ) - throw uno::RuntimeException(); - } - - return *pResMgr; -} - -OUString AnalysisAddIn::GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ) -{ - ResStringArray aArr(AnalysisResId(nResId, GetResMgr())); - return aArr.GetString(nStrIndex - 1); + return AnalysisResId(pResId[nStrIndex - 1]); } void AnalysisAddIn::InitData() { - delete pResMgr; - pResMgr = ResMgr::CreateResMgr("analysis", LanguageTag(aFuncLoc)); + aResLocale = Translate::Create("analysis", LanguageTag(aFuncLoc)); delete pFD; pFD = new FuncDataList; @@ -103,14 +86,12 @@ AnalysisAddIn::AnalysisAddIn( const uno::Reference< uno::XComponentContext >& xC pFD( nullptr ), pFactDoubles( nullptr ), pCDL( nullptr ), - pResMgr( nullptr ), aAnyConv( xContext ) { } AnalysisAddIn::~AnalysisAddIn() { - delete pResMgr; delete pCDL; delete pFD; delete[] pDefLocales; @@ -240,7 +221,7 @@ OUString SAL_CALL AnalysisAddIn::getDisplayFunctionName( const OUString& aProgra auto it = std::find_if(pFD->begin(), pFD->end(), FindFuncData( aProgrammaticName ) ); if( it != pFD->end() ) { - aRet = AnalysisResId(it->GetUINameID(), GetResMgr()); + aRet = AnalysisResId(it->GetUINameID()); if( it->IsDouble() ) { const OUString& rSuffix = it->GetSuffix(); @@ -1124,4 +1105,9 @@ double SAL_CALL AnalysisAddIn::getConvert( double f, const OUString& aFU, const RETURN_FINITE( fRet ); } +OUString AnalysisAddIn::AnalysisResId(const char* pResId) +{ + return Translate::get(pResId, aResLocale); +} + /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/analysis/analysis.hrc b/scaddins/source/analysis/analysis.hrc deleted file mode 100644 index 75d4bfe28363..000000000000 --- a/scaddins/source/analysis/analysis.hrc +++ /dev/null @@ -1,234 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ -#ifndef SCADDINS_ANALYSIS_HRC -#define SCADDINS_ANALYSIS_HRC - -#define ANALYSIS_RESOURCE_START 1000 - -#define ANALYSIS_FUNCDESC_START (ANALYSIS_RESOURCE_START) - -#define ANALYSIS_Workday (ANALYSIS_FUNCDESC_START) -#define ANALYSIS_Yearfrac (ANALYSIS_FUNCDESC_START+1) -#define ANALYSIS_Edate (ANALYSIS_FUNCDESC_START+2) -#define ANALYSIS_Weeknum (ANALYSIS_FUNCDESC_START+3) -#define ANALYSIS_Eomonth (ANALYSIS_FUNCDESC_START+4) -#define ANALYSIS_Networkdays (ANALYSIS_FUNCDESC_START+5) -#define ANALYSIS_Iseven (ANALYSIS_FUNCDESC_START+6) -#define ANALYSIS_Isodd (ANALYSIS_FUNCDESC_START+7) -#define ANALYSIS_Multinomial (ANALYSIS_FUNCDESC_START+8) -#define ANALYSIS_Seriessum (ANALYSIS_FUNCDESC_START+9) -#define ANALYSIS_Quotient (ANALYSIS_FUNCDESC_START+10) -#define ANALYSIS_Mround (ANALYSIS_FUNCDESC_START+11) -#define ANALYSIS_Sqrtpi (ANALYSIS_FUNCDESC_START+12) -#define ANALYSIS_Randbetween (ANALYSIS_FUNCDESC_START+13) -#define ANALYSIS_Gcd (ANALYSIS_FUNCDESC_START+14) -#define ANALYSIS_Lcm (ANALYSIS_FUNCDESC_START+15) -#define ANALYSIS_Besseli (ANALYSIS_FUNCDESC_START+16) -#define ANALYSIS_Besselj (ANALYSIS_FUNCDESC_START+17) -#define ANALYSIS_Besselk (ANALYSIS_FUNCDESC_START+18) -#define ANALYSIS_Bessely (ANALYSIS_FUNCDESC_START+19) -#define ANALYSIS_Bin2Oct (ANALYSIS_FUNCDESC_START+20) -#define ANALYSIS_Bin2Dec (ANALYSIS_FUNCDESC_START+21) -#define ANALYSIS_Bin2Hex (ANALYSIS_FUNCDESC_START+22) -#define ANALYSIS_Oct2Bin (ANALYSIS_FUNCDESC_START+23) -#define ANALYSIS_Oct2Dec (ANALYSIS_FUNCDESC_START+24) -#define ANALYSIS_Oct2Hex (ANALYSIS_FUNCDESC_START+25) -#define ANALYSIS_Dec2Bin (ANALYSIS_FUNCDESC_START+26) -#define ANALYSIS_Dec2Hex (ANALYSIS_FUNCDESC_START+27) -#define ANALYSIS_Dec2Oct (ANALYSIS_FUNCDESC_START+28) -#define ANALYSIS_Hex2Bin (ANALYSIS_FUNCDESC_START+29) -#define ANALYSIS_Hex2Dec (ANALYSIS_FUNCDESC_START+30) -#define ANALYSIS_Hex2Oct (ANALYSIS_FUNCDESC_START+31) -#define ANALYSIS_Delta (ANALYSIS_FUNCDESC_START+32) -#define ANALYSIS_Erf (ANALYSIS_FUNCDESC_START+33) -#define ANALYSIS_Erfc (ANALYSIS_FUNCDESC_START+34) -#define ANALYSIS_Gestep (ANALYSIS_FUNCDESC_START+35) -#define ANALYSIS_Factdouble (ANALYSIS_FUNCDESC_START+36) -#define ANALYSIS_Imabs (ANALYSIS_FUNCDESC_START+37) -#define ANALYSIS_Imaginary (ANALYSIS_FUNCDESC_START+38) -#define ANALYSIS_Impower (ANALYSIS_FUNCDESC_START+39) -#define ANALYSIS_Imargument (ANALYSIS_FUNCDESC_START+40) -#define ANALYSIS_Imcos (ANALYSIS_FUNCDESC_START+41) -#define ANALYSIS_Imdiv (ANALYSIS_FUNCDESC_START+42) -#define ANALYSIS_Imexp (ANALYSIS_FUNCDESC_START+43) -#define ANALYSIS_Imconjugate (ANALYSIS_FUNCDESC_START+44) -#define ANALYSIS_Imln (ANALYSIS_FUNCDESC_START+45) -#define ANALYSIS_Imlog10 (ANALYSIS_FUNCDESC_START+46) -#define ANALYSIS_Imlog2 (ANALYSIS_FUNCDESC_START+47) -#define ANALYSIS_Improduct (ANALYSIS_FUNCDESC_START+48) -#define ANALYSIS_Imreal (ANALYSIS_FUNCDESC_START+49) -#define ANALYSIS_Imsin (ANALYSIS_FUNCDESC_START+50) -#define ANALYSIS_Imsub (ANALYSIS_FUNCDESC_START+51) -#define ANALYSIS_Imsqrt (ANALYSIS_FUNCDESC_START+52) -#define ANALYSIS_Imsum (ANALYSIS_FUNCDESC_START+53) -#define ANALYSIS_Complex (ANALYSIS_FUNCDESC_START+54) -#define ANALYSIS_Convert (ANALYSIS_FUNCDESC_START+55) -#define ANALYSIS_Amordegrc (ANALYSIS_FUNCDESC_START+56) -#define ANALYSIS_Amorlinc (ANALYSIS_FUNCDESC_START+57) -#define ANALYSIS_Accrint (ANALYSIS_FUNCDESC_START+58) -#define ANALYSIS_Accrintm (ANALYSIS_FUNCDESC_START+59) -#define ANALYSIS_Received (ANALYSIS_FUNCDESC_START+60) -#define ANALYSIS_Disc (ANALYSIS_FUNCDESC_START+61) -#define ANALYSIS_Duration (ANALYSIS_FUNCDESC_START+62) -#define ANALYSIS_Effect (ANALYSIS_FUNCDESC_START+63) -#define ANALYSIS_Cumprinc (ANALYSIS_FUNCDESC_START+64) -#define ANALYSIS_Cumipmt (ANALYSIS_FUNCDESC_START+65) -#define ANALYSIS_Price (ANALYSIS_FUNCDESC_START+66) -#define ANALYSIS_Pricedisc (ANALYSIS_FUNCDESC_START+67) -#define ANALYSIS_Pricemat (ANALYSIS_FUNCDESC_START+68) -#define ANALYSIS_Mduration (ANALYSIS_FUNCDESC_START+69) -#define ANALYSIS_Nominal (ANALYSIS_FUNCDESC_START+70) -#define ANALYSIS_Dollarfr (ANALYSIS_FUNCDESC_START+71) -#define ANALYSIS_Dollarde (ANALYSIS_FUNCDESC_START+72) -#define ANALYSIS_Yield (ANALYSIS_FUNCDESC_START+73) -#define ANALYSIS_Yielddisc (ANALYSIS_FUNCDESC_START+74) -#define ANALYSIS_Yieldmat (ANALYSIS_FUNCDESC_START+75) -#define ANALYSIS_Tbilleq (ANALYSIS_FUNCDESC_START+76) -#define ANALYSIS_Tbillprice (ANALYSIS_FUNCDESC_START+77) -#define ANALYSIS_Tbillyield (ANALYSIS_FUNCDESC_START+78) -#define ANALYSIS_Oddfprice (ANALYSIS_FUNCDESC_START+79) -#define ANALYSIS_Oddfyield (ANALYSIS_FUNCDESC_START+80) -#define ANALYSIS_Oddlprice (ANALYSIS_FUNCDESC_START+81) -#define ANALYSIS_Oddlyield (ANALYSIS_FUNCDESC_START+82) -#define ANALYSIS_Xirr (ANALYSIS_FUNCDESC_START+83) -#define ANALYSIS_Xnpv (ANALYSIS_FUNCDESC_START+84) -#define ANALYSIS_Intrate (ANALYSIS_FUNCDESC_START+85) -#define ANALYSIS_Coupncd (ANALYSIS_FUNCDESC_START+86) -#define ANALYSIS_Coupdays (ANALYSIS_FUNCDESC_START+87) -#define ANALYSIS_Coupdaysnc (ANALYSIS_FUNCDESC_START+88) -#define ANALYSIS_Coupdaybs (ANALYSIS_FUNCDESC_START+89) -#define ANALYSIS_Couppcd (ANALYSIS_FUNCDESC_START+90) -#define ANALYSIS_Coupnum (ANALYSIS_FUNCDESC_START+91) -#define ANALYSIS_Fvschedule (ANALYSIS_FUNCDESC_START+92) -#define ANALYSIS_Imtan (ANALYSIS_FUNCDESC_START+93) -#define ANALYSIS_Imsec (ANALYSIS_FUNCDESC_START+94) -#define ANALYSIS_Imcsc (ANALYSIS_FUNCDESC_START+95) -#define ANALYSIS_Imcot (ANALYSIS_FUNCDESC_START+96) -#define ANALYSIS_Imsinh (ANALYSIS_FUNCDESC_START+97) -#define ANALYSIS_Imcosh (ANALYSIS_FUNCDESC_START+98) -#define ANALYSIS_Imsech (ANALYSIS_FUNCDESC_START+99) -#define ANALYSIS_Imcsch (ANALYSIS_FUNCDESC_START+100) - -#define ANALYSIS_FUNCNAME_START (ANALYSIS_RESOURCE_START+2000) - -#define ANALYSIS_FUNCNAME_Workday (ANALYSIS_FUNCNAME_START) -#define ANALYSIS_FUNCNAME_Yearfrac (ANALYSIS_FUNCNAME_START+1) -#define ANALYSIS_FUNCNAME_Edate (ANALYSIS_FUNCNAME_START+2) -#define ANALYSIS_FUNCNAME_Weeknum (ANALYSIS_FUNCNAME_START+3) -#define ANALYSIS_FUNCNAME_Eomonth (ANALYSIS_FUNCNAME_START+4) -#define ANALYSIS_FUNCNAME_Networkdays (ANALYSIS_FUNCNAME_START+5) -#define ANALYSIS_FUNCNAME_Iseven (ANALYSIS_FUNCNAME_START+6) -#define ANALYSIS_FUNCNAME_Isodd (ANALYSIS_FUNCNAME_START+7) -#define ANALYSIS_FUNCNAME_Multinomial (ANALYSIS_FUNCNAME_START+8) -#define ANALYSIS_FUNCNAME_Seriessum (ANALYSIS_FUNCNAME_START+9) -#define ANALYSIS_FUNCNAME_Quotient (ANALYSIS_FUNCNAME_START+10) -#define ANALYSIS_FUNCNAME_Mround (ANALYSIS_FUNCNAME_START+11) -#define ANALYSIS_FUNCNAME_Sqrtpi (ANALYSIS_FUNCNAME_START+12) -#define ANALYSIS_FUNCNAME_Randbetween (ANALYSIS_FUNCNAME_START+13) -#define ANALYSIS_FUNCNAME_Gcd (ANALYSIS_FUNCNAME_START+14) -#define ANALYSIS_FUNCNAME_Lcm (ANALYSIS_FUNCNAME_START+15) -#define ANALYSIS_FUNCNAME_Besseli (ANALYSIS_FUNCNAME_START+16) -#define ANALYSIS_FUNCNAME_Besselj (ANALYSIS_FUNCNAME_START+17) -#define ANALYSIS_FUNCNAME_Besselk (ANALYSIS_FUNCNAME_START+18) -#define ANALYSIS_FUNCNAME_Bessely (ANALYSIS_FUNCNAME_START+19) -#define ANALYSIS_FUNCNAME_Bin2Oct (ANALYSIS_FUNCNAME_START+20) -#define ANALYSIS_FUNCNAME_Bin2Dec (ANALYSIS_FUNCNAME_START+21) -#define ANALYSIS_FUNCNAME_Bin2Hex (ANALYSIS_FUNCNAME_START+22) -#define ANALYSIS_FUNCNAME_Oct2Bin (ANALYSIS_FUNCNAME_START+23) -#define ANALYSIS_FUNCNAME_Oct2Dec (ANALYSIS_FUNCNAME_START+24) -#define ANALYSIS_FUNCNAME_Oct2Hex (ANALYSIS_FUNCNAME_START+25) -#define ANALYSIS_FUNCNAME_Dec2Bin (ANALYSIS_FUNCNAME_START+26) -#define ANALYSIS_FUNCNAME_Dec2Hex (ANALYSIS_FUNCNAME_START+27) -#define ANALYSIS_FUNCNAME_Dec2Oct (ANALYSIS_FUNCNAME_START+28) -#define ANALYSIS_FUNCNAME_Hex2Bin (ANALYSIS_FUNCNAME_START+29) -#define ANALYSIS_FUNCNAME_Hex2Dec (ANALYSIS_FUNCNAME_START+30) -#define ANALYSIS_FUNCNAME_Hex2Oct (ANALYSIS_FUNCNAME_START+31) -#define ANALYSIS_FUNCNAME_Delta (ANALYSIS_FUNCNAME_START+32) -#define ANALYSIS_FUNCNAME_Erf (ANALYSIS_FUNCNAME_START+33) -#define ANALYSIS_FUNCNAME_Erfc (ANALYSIS_FUNCNAME_START+34) -#define ANALYSIS_FUNCNAME_Gestep (ANALYSIS_FUNCNAME_START+35) -#define ANALYSIS_FUNCNAME_Factdouble (ANALYSIS_FUNCNAME_START+36) -#define ANALYSIS_FUNCNAME_Imabs (ANALYSIS_FUNCNAME_START+37) -#define ANALYSIS_FUNCNAME_Imaginary (ANALYSIS_FUNCNAME_START+38) -#define ANALYSIS_FUNCNAME_Impower (ANALYSIS_FUNCNAME_START+39) -#define ANALYSIS_FUNCNAME_Imargument (ANALYSIS_FUNCNAME_START+40) -#define ANALYSIS_FUNCNAME_Imcos (ANALYSIS_FUNCNAME_START+41) -#define ANALYSIS_FUNCNAME_Imdiv (ANALYSIS_FUNCNAME_START+42) -#define ANALYSIS_FUNCNAME_Imexp (ANALYSIS_FUNCNAME_START+43) -#define ANALYSIS_FUNCNAME_Imconjugate (ANALYSIS_FUNCNAME_START+44) -#define ANALYSIS_FUNCNAME_Imln (ANALYSIS_FUNCNAME_START+45) -#define ANALYSIS_FUNCNAME_Imlog10 (ANALYSIS_FUNCNAME_START+46) -#define ANALYSIS_FUNCNAME_Imlog2 (ANALYSIS_FUNCNAME_START+47) -#define ANALYSIS_FUNCNAME_Improduct (ANALYSIS_FUNCNAME_START+48) -#define ANALYSIS_FUNCNAME_Imreal (ANALYSIS_FUNCNAME_START+49) -#define ANALYSIS_FUNCNAME_Imsin (ANALYSIS_FUNCNAME_START+50) -#define ANALYSIS_FUNCNAME_Imsub (ANALYSIS_FUNCNAME_START+51) -#define ANALYSIS_FUNCNAME_Imsqrt (ANALYSIS_FUNCNAME_START+52) -#define ANALYSIS_FUNCNAME_Imsum (ANALYSIS_FUNCNAME_START+53) -#define ANALYSIS_FUNCNAME_Complex (ANALYSIS_FUNCNAME_START+54) -#define ANALYSIS_FUNCNAME_Convert (ANALYSIS_FUNCNAME_START+55) -#define ANALYSIS_FUNCNAME_Amordegrc (ANALYSIS_FUNCNAME_START+56) -#define ANALYSIS_FUNCNAME_Amorlinc (ANALYSIS_FUNCNAME_START+57) -#define ANALYSIS_FUNCNAME_Accrint (ANALYSIS_FUNCNAME_START+58) -#define ANALYSIS_FUNCNAME_Accrintm (ANALYSIS_FUNCNAME_START+59) -#define ANALYSIS_FUNCNAME_Received (ANALYSIS_FUNCNAME_START+60) -#define ANALYSIS_FUNCNAME_Disc (ANALYSIS_FUNCNAME_START+61) -#define ANALYSIS_FUNCNAME_Duration (ANALYSIS_FUNCNAME_START+62) -#define ANALYSIS_FUNCNAME_Effect (ANALYSIS_FUNCNAME_START+63) -#define ANALYSIS_FUNCNAME_Cumprinc (ANALYSIS_FUNCNAME_START+64) -#define ANALYSIS_FUNCNAME_Cumipmt (ANALYSIS_FUNCNAME_START+65) -#define ANALYSIS_FUNCNAME_Price (ANALYSIS_FUNCNAME_START+66) -#define ANALYSIS_FUNCNAME_Pricedisc (ANALYSIS_FUNCNAME_START+67) -#define ANALYSIS_FUNCNAME_Pricemat (ANALYSIS_FUNCNAME_START+68) -#define ANALYSIS_FUNCNAME_Mduration (ANALYSIS_FUNCNAME_START+69) -#define ANALYSIS_FUNCNAME_Nominal (ANALYSIS_FUNCNAME_START+70) -#define ANALYSIS_FUNCNAME_Dollarfr (ANALYSIS_FUNCNAME_START+71) -#define ANALYSIS_FUNCNAME_Dollarde (ANALYSIS_FUNCNAME_START+72) -#define ANALYSIS_FUNCNAME_Yield (ANALYSIS_FUNCNAME_START+73) -#define ANALYSIS_FUNCNAME_Yielddisc (ANALYSIS_FUNCNAME_START+74) -#define ANALYSIS_FUNCNAME_Yieldmat (ANALYSIS_FUNCNAME_START+75) -#define ANALYSIS_FUNCNAME_Tbilleq (ANALYSIS_FUNCNAME_START+76) -#define ANALYSIS_FUNCNAME_Tbillprice (ANALYSIS_FUNCNAME_START+77) -#define ANALYSIS_FUNCNAME_Tbillyield (ANALYSIS_FUNCNAME_START+78) -#define ANALYSIS_FUNCNAME_Oddfprice (ANALYSIS_FUNCNAME_START+79) -#define ANALYSIS_FUNCNAME_Oddfyield (ANALYSIS_FUNCNAME_START+80) -#define ANALYSIS_FUNCNAME_Oddlprice (ANALYSIS_FUNCNAME_START+81) -#define ANALYSIS_FUNCNAME_Oddlyield (ANALYSIS_FUNCNAME_START+82) -#define ANALYSIS_FUNCNAME_Xirr (ANALYSIS_FUNCNAME_START+83) -#define ANALYSIS_FUNCNAME_Xnpv (ANALYSIS_FUNCNAME_START+84) -#define ANALYSIS_FUNCNAME_Intrate (ANALYSIS_FUNCNAME_START+85) -#define ANALYSIS_FUNCNAME_Coupncd (ANALYSIS_FUNCNAME_START+86) -#define ANALYSIS_FUNCNAME_Coupdays (ANALYSIS_FUNCNAME_START+87) -#define ANALYSIS_FUNCNAME_Coupdaysnc (ANALYSIS_FUNCNAME_START+88) -#define ANALYSIS_FUNCNAME_Coupdaybs (ANALYSIS_FUNCNAME_START+89) -#define ANALYSIS_FUNCNAME_Couppcd (ANALYSIS_FUNCNAME_START+90) -#define ANALYSIS_FUNCNAME_Coupnum (ANALYSIS_FUNCNAME_START+91) -#define ANALYSIS_FUNCNAME_Fvschedule (ANALYSIS_FUNCNAME_START+92) -#define ANALYSIS_FUNCNAME_Imtan (ANALYSIS_FUNCNAME_START+93) -#define ANALYSIS_FUNCNAME_Imsec (ANALYSIS_FUNCNAME_START+94) -#define ANALYSIS_FUNCNAME_Imcsc (ANALYSIS_FUNCNAME_START+95) -#define ANALYSIS_FUNCNAME_Imcot (ANALYSIS_FUNCNAME_START+96) -#define ANALYSIS_FUNCNAME_Imsinh (ANALYSIS_FUNCNAME_START+97) -#define ANALYSIS_FUNCNAME_Imcosh (ANALYSIS_FUNCNAME_START+98) -#define ANALYSIS_FUNCNAME_Imsech (ANALYSIS_FUNCNAME_START+99) -#define ANALYSIS_FUNCNAME_Imcsch (ANALYSIS_FUNCNAME_START+100) - -#endif - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/analysis/analysis.hxx b/scaddins/source/analysis/analysis.hxx index c38c65759148..22e82cddfe15 100644 --- a/scaddins/source/analysis/analysis.hxx +++ b/scaddins/source/analysis/analysis.hxx @@ -40,8 +40,6 @@ namespace sca { namespace analysis { class ConvertDataList; } } -class ResMgr; - css::uno::Reference< css::uno::XInterface > SAL_CALL AnalysisAddIn_CreateInstance( const css::uno::Reference< css::lang::XMultiServiceFactory >& ); @@ -59,14 +57,12 @@ private: sca::analysis::FuncDataList* pFD; std::unique_ptr<double[]> pFactDoubles; sca::analysis::ConvertDataList* pCDL; - ResMgr* pResMgr; + std::locale aResLocale; sca::analysis::ScaAnyConverter aAnyConv; /// @throws css::uno::RuntimeException - ResMgr& GetResMgr(); - /// @throws css::uno::RuntimeException - OUString GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ); + OUString GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex); void InitDefLocales(); inline const css::lang::Locale& GetLocale( sal_uInt32 nInd ); void InitData(); @@ -82,6 +78,9 @@ private: public: explicit AnalysisAddIn( const css::uno::Reference< css::uno::XComponentContext >& xContext ); + + OUString AnalysisResId(const char* pId); + virtual ~AnalysisAddIn() override; /// @throws css::uno::RuntimeException diff --git a/scaddins/source/analysis/analysis.src b/scaddins/source/analysis/analysis.src deleted file mode 100644 index 14d15b9e3f5b..000000000000 --- a/scaddins/source/analysis/analysis.src +++ /dev/null @@ -1,1404 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#include "analysis.hrc" - -StringArray ANALYSIS_Workday -{ - ItemList [ en-US ] = - { - < "Returns the serial number of the date before or after a specified number of workdays"; > ; - < "Start date"; > ; - < "The start date"; > ; - < "Days"; > ; - < "The number of workdays before or after the start date"; > ; - < "Holidays"; > ; - < "List of date values of days off (vacation, holidays, etc.)"; > ; - }; -}; - -StringArray ANALYSIS_Yearfrac -{ - ItemList [ en-US ] = - { - < "Returns the number of years (including fractional part) between two dates"; > ; - < "Start date"; > ; - < "The start date"; > ; - < "End date"; > ; - < "The end date"; > ; - < "Basis"; > ; - < "Basis indicates the day-count convention to use in the calculation"; > ; - }; -}; - -StringArray ANALYSIS_Edate -{ - ItemList [ en-US ] = - { - < "Returns the serial number of the date that is a specified number of months before or after the start date"; > ; - < "Start date"; > ; - < "The start date"; > ; - < "Months"; > ; - < "Number of months before or after the start date"; > ; - }; -}; - -StringArray ANALYSIS_Weeknum -{ - ItemList [ en-US ] = - { - < "Returns the number of the calendar week in which the specified date occurs.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use WEEKNUM instead."; > ; - < "Date"; > ; - < "The date or date serial number"; > ; - < "Return type"; > ; - < "Indicates the first day of the week (1 = Sunday, 2 = Monday)"; > ; - }; -}; - -StringArray ANALYSIS_Eomonth -{ - ItemList [ en-US ] = - { - < "Returns the serial number of the last day of the month that comes a certain number of months before or after the start date"; > ; - < "Start date"; > ; - < "The start date"; > ; - < "Months"; > ; - < "Number of months before or after the start date"; > ; - }; -}; - -StringArray ANALYSIS_Networkdays -{ - ItemList [ en-US ] = - { - < "Returns the number of workdays between two dates.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use NETWORKDAYS instead."; > ; - < "Start date"; > ; - < "The start date"; > ; - < "End date"; > ; - < "The end date"; > ; - < "Holidays"; > ; - < "List of date values representing days off (vacation, holidays, etc.)"; > ; - }; -}; - -StringArray ANALYSIS_Iseven -{ - ItemList [ en-US ] = - { - < "Returns the value 'true' if the number is even"; > ; - < "Number"; > ; - < "The number"; > ; - }; -}; - -StringArray ANALYSIS_Isodd -{ - ItemList [ en-US ] = - { - < "Returns the value 'true' if the number is odd"; > ; - < "Number"; > ; - < "The number"; > ; - }; -}; - -StringArray ANALYSIS_Multinomial -{ - ItemList [ en-US ] = - { - < "Returns the multinomial coefficient of a set of numbers"; > ; - < "Number"; > ; - < "Number or list of numbers for which you want the multinomial coefficient"; > ; - }; -}; - -StringArray ANALYSIS_Seriessum -{ - ItemList [ en-US ] = - { - < "Returns the sum of a power series"; > ; - < "X"; > ; - < "The independent variable of the power series"; > ; - < "N"; > ; - < "The initial power to which x is to be raised"; > ; - < "M"; > ; - < "The increment by which to increase n for each term in the series"; > ; - < "Coefficients"; > ; - < "Set of coefficients by which each successive power of the variable x is multiplied"; > ; - }; -}; - -StringArray ANALYSIS_Quotient -{ - ItemList [ en-US ] = - { - < "Returns the integer portion of a division"; > ; - < "Numerator"; > ; - < "The dividend"; > ; - < "Denominator"; > ; - < "The divisor"; > ; - }; -}; - -StringArray ANALYSIS_Mround -{ - ItemList [ en-US ] = - { - < "Returns a number rounded to a specified multiple"; > ; - < "Number"; > ; - < "The number to round off"; > ; - < "Multiple"; > ; - < "The multiple to which you want to round number"; > ; - }; -}; - -StringArray ANALYSIS_Sqrtpi -{ - ItemList [ en-US ] = - { - < "Returns the square root of a number which has been multiplied by pi"; > ; - < "Number"; > ; - < "The number by which pi is multiplied"; > ; - }; -}; - -StringArray ANALYSIS_Randbetween -{ - ItemList [ en-US ] = - { - < "Returns a random integer between the numbers you specify"; > ; - < "Bottom"; > ; - < "The smallest integer returned"; > ; - < "Top"; > ; - < "The largest integer returned"; > ; - }; -}; - -StringArray ANALYSIS_Gcd -{ - ItemList [ en-US ] = - { - < "Returns the greatest common divisor.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use GCD instead."; > ; - < "Number"; > ; - < "Number or list of numbers"; > ; - }; -}; - -StringArray ANALYSIS_Lcm -{ - ItemList [ en-US ] = - { - < "Returns the least common multiple.\nThis function exists for interoperability with older Microsoft Excel documents, for new documents use LCM instead."; > ; - < "Number"; > ; - < "Number or list of numbers"; > ; - }; -}; - -StringArray ANALYSIS_Besseli -{ - ItemList [ en-US ] = - { - < "Returns the modified Bessel function In(x)"; > ; - < "X"; > ; - < "The value at which the function is to be evaluated"; > ; - < "N"; > ; - < "The order of the Bessel function"; > ; - }; -}; - -StringArray ANALYSIS_Besselj -{ - ItemList [ en-US ] = - { - < "Returns the Bessel function Jn(x)"; > ; - < "X"; > ; - < "The value at which the function is to be evaluated"; > ; - < "N"; > ; - < "The order of the Bessel function"; > ; - }; -}; - -StringArray ANALYSIS_Besselk -{ - ItemList [ en-US ] = - { - < "Returns the Bessel function Kn(x)"; > ; - < "X"; > ; - < "The value at which the function is to be evaluated"; > ; - < "N"; > ; - < "The order of the Bessel function"; > ; - }; -}; - -StringArray ANALYSIS_Bessely -{ - ItemList [ en-US ] = - { - < "Returns the Bessel function Yn(x)"; > ; - < "X"; > ; - < "The value at which the function is to be evaluated"; > ; - < "N"; > ; - < "The order of the Bessel function"; > ; - }; -}; - -StringArray ANALYSIS_Bin2Oct -{ - ItemList [ en-US ] = - { - < "Converts a binary number to an octal number"; > ; - < "Number"; > ; - < "The binary number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Bin2Dec -{ - ItemList [ en-US ] = - { - < "Converts a binary number to a decimal number"; > ; - < "Number"; > ; - < "The binary number to be converted (as text)"; > ; - }; -}; - -StringArray ANALYSIS_Bin2Hex -{ - ItemList [ en-US ] = - { - < "Converts a binary number to a hexadecimal number"; > ; - < "Number"; > ; - < "The binary number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used."; > ; - }; -}; - -StringArray ANALYSIS_Oct2Bin -{ - ItemList [ en-US ] = - { - < "Converts an octal number to a binary number"; > ; - < "Number"; > ; - < "The octal number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Oct2Dec -{ - ItemList [ en-US ] = - { - < "Converts an octal number to a decimal number"; > ; - < "Number"; > ; - < "The octal number to be converted (as text)"; > ; - }; -}; - -StringArray ANALYSIS_Oct2Hex -{ - ItemList [ en-US ] = - { - < "Converts an octal number to a hexadecimal number"; > ; - < "Number"; > ; - < "The octal number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Dec2Bin -{ - ItemList [ en-US ] = - { - < "Converts a decimal number to a binary number"; > ; - < "Number"; > ; - < "The decimal integer to be converted"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Dec2Hex -{ - ItemList [ en-US ] = - { - < "Converts a decimal number to a hexadecimal number"; > ; - < "Number"; > ; - < "The decimal integer to be converted"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Dec2Oct -{ - ItemList [ en-US ] = - { - < "Converts a decimal number into an octal number"; > ; - < "Number"; > ; - < "The decimal number"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Hex2Bin -{ - ItemList [ en-US ] = - { - < "Converts a hexadecimal number to a binary number"; > ; - < "Number"; > ; - < "The hexadecimal number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Hex2Dec -{ - ItemList [ en-US ] = - { - < "Converts a hexadecimal number to a decimal number"; > ; - < "Number"; > ; - < "The hexadecimal number to be converted (as text)"; > ; - }; -}; - -StringArray ANALYSIS_Hex2Oct -{ - ItemList [ en-US ] = - { - < "Converts a hexadecimal number to an octal number"; > ; - < "Number"; > ; - < "The hexadecimal number to be converted (as text)"; > ; - < "Places"; > ; - < "Number of places used"; > ; - }; -}; - -StringArray ANALYSIS_Delta -{ - ItemList [ en-US ] = - { - < "Tests whether two values are equal"; > ; - < "Number 1"; > ; - < "The first number"; > ; - < "Number 2"; > ; - < "The second number"; > ; - }; -}; - -StringArray ANALYSIS_Erf -{ - ItemList [ en-US ] = - { - < "Returns the error function"; > ; - < "Lower limit"; > ; - < "The lower limit for integration"; > ; - < "Upper limit"; > ; - < "The upper limit for integration"; > ; - }; -}; - -StringArray ANALYSIS_Erfc -{ - ItemList [ en-US ] = - { - < "Returns the complementary error function"; > ; - < "Lower limit"; > ; - < "The lower limit for integration"; > ; - }; -}; - -StringArray ANALYSIS_Gestep -{ - ItemList [ en-US ] = - { - < "Tests whether a number is greater than a threshold value"; > ; - < "Number"; > ; - < "The value to test against step"; > ; - < "Step"; > ; - < "The threshold value"; > ; - }; -}; - -StringArray ANALYSIS_Factdouble -{ - ItemList [ en-US ] = - { - < "Returns the double factorial of Number"; > ; - < "Number"; > ; - < "The number"; > ; - }; -}; - -StringArray ANALYSIS_Imabs -{ - ItemList [ en-US ] = - { - < "Returns the absolute value (modulus) of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imaginary -{ - ItemList [ en-US ] = - { - < "Returns the imaginary coefficient of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Impower -{ - ItemList [ en-US ] = - { - < "Returns a complex number raised to a real power"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - < "Number"; > ; - < "Power to which the complex number is raised"; > ; - }; -}; - -StringArray ANALYSIS_Imargument -{ - ItemList [ en-US ] = - { - < "Returns the argument theta, an angle expressed in radians"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imcos -{ - ItemList [ en-US ] = - { - < "Returns the cosine of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imdiv -{ - ItemList [ en-US ] = - { - < "Returns the quotient of two complex numbers"; > ; - < "Numerator"; > ; - < "The dividend"; > ; - < "Denominator"; > ; - < "The divisor"; > ; - }; -}; - -StringArray ANALYSIS_Imexp -{ - ItemList [ en-US ] = - { - < "Returns the algebraic form of the exponential of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imconjugate -{ - ItemList [ en-US ] = - { - < "Returns the complex conjugate of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imln -{ - ItemList [ en-US ] = - { - < "Returns the natural logarithm of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imlog10 -{ - ItemList [ en-US ] = - { - < "Returns the base-10 logarithm of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imlog2 -{ - ItemList [ en-US ] = - { - < "Returns the base-2 logarithm of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Improduct -{ - ItemList [ en-US ] = - { - < "Returns the product of several complex numbers"; > ; - < "Complex number"; > ; - < "The first complex number"; > ; - < "Complex number"; > ; - < "Another complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imreal -{ - ItemList [ en-US ] = - { - < "Returns the real coefficient of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsin -{ - ItemList [ en-US ] = - { - < "Returns the sine of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsub -{ - ItemList [ en-US ] = - { - < "Returns the difference of two complex numbers"; > ; - < "Complex number 1"; > ; - < "Complex number 1"; > ; - < "Complex number 2"; > ; - < "Complex number 2"; > ; - }; -}; - -StringArray ANALYSIS_Imsqrt -{ - ItemList [ en-US ] = - { - < "Returns the square root of a complex number"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsum -{ - ItemList [ en-US ] = - { - < "Returns the sum of complex numbers"; > ; - < "Complex number"; > ; - < "The complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imtan -{ - ItemList [ en-US ] = - { - < "Returns the tangent of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsec -{ - ItemList [ en-US ] = - { - < "Returns the secant of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imcsc -{ - ItemList [ en-US ] = - { - < "Returns the cosecant of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imcot -{ - ItemList [ en-US ] = - { - < "Returns the cotangent of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsinh -{ - ItemList [ en-US ] = - { - < "Returns the hyperbolic sine of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imcosh -{ - ItemList [ en-US ] = - { - < "Returns the hyperbolic cosine of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imsech -{ - ItemList [ en-US ] = - { - < "Returns the hyperbolic secant of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Imcsch -{ - ItemList [ en-US ] = - { - < "Returns the hyperbolic cosecant of a complex number"; > ; - < "Complex number"; > ; - < "A complex number"; > ; - }; -}; - -StringArray ANALYSIS_Complex -{ - ItemList [ en-US ] = - { - < "Converts real and imaginary coefficients into a complex number"; > ; - < "Real num"; > ; - < "The real coefficient"; > ; - < "I num"; > ; - < "The imaginary coefficient"; > ; - < "Suffix"; > ; - < "The suffix"; > ; - }; -}; - -StringArray ANALYSIS_Convert -{ - ItemList [ en-US ] = - { - < "Converts a number from one measurement system to another"; > ; - < "Number"; > ; - < "The number"; > ; - < "From unit"; > ; - < "Unit of measure for number"; > ; - < "To unit"; > ; - < "Unit of measure for the result"; > ; - }; -}; - -StringArray ANALYSIS_Amordegrc -{ - ItemList [ en-US ] = - { - < "Returns the prorated linear depreciation of an asset for each accounting period"; > ; - < "Cost"; > ; - < "Cost of the asset"; > ; - < "Date purchased"; > ; - < "Purchase date of the asset"; > ; - < "First period"; > ; - < "Date the first period ends"; > ; - < "Salvage"; > ; - < "Salvage value of an asset at the end of its life"; > ; - < "Period"; > ; - < "The period"; > ; - < "Rate"; > ; - < "The rate of depreciation"; > ; - < "Basis"; > ; - < "The year basis to be used"; > ; - }; -}; - -StringArray ANALYSIS_Amorlinc -{ - ItemList [ en-US ] = - { - < "Returns the prorated linear depreciation of an asset for each accounting period"; > ; - < "Cost"; > ; - < "Cost of the asset"; > ; - < "Date purchased"; > ; - < "Purchase date of the asset"; > ; - < "First period"; > ; - < "The date the first period ends"; > ; - < "Salvage"; > ; - < "The salvage value of an asset at the end of its life"; > ; - < "Period"; > ; - < "The period"; > ; - < "Rate"; > ; - < "The rate of depreciation"; > ; - < "Basis"; > ; - < "The year basis to be used"; > ; - }; -}; - -StringArray ANALYSIS_Accrint -{ - ItemList [ en-US ] = - { - < "Returns the accrued interest for a security that pays periodic interest"; > ; - < "Issue"; > ; - < "Issue date of the security"; > ; - < "First interest"; > ; - < "First interest date of the security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Par"; > ; - < "The par value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Accrintm -{ - ItemList [ en-US ] = - { - < "Returns the accrued interest for a security that pays interest at maturity"; > ; - < "Issue"; > ; - < "The issue date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Par"; > ; - < "The par value"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Received -{ - ItemList [ en-US ] = - { - < "Returns the amount paid out at maturity for a fully invested security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Investment"; > ; - < "The investment"; > ; - < "Discount"; > ; - < "The discount"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Disc -{ - ItemList [ en-US ] = - { - < "Returns the discount rate for a security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Price"; > ; - < "The price"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Duration -{ - ItemList [ en-US ] = - { - < "Returns the annual Macaulay duration of a security with periodic interest payments"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Coupon"; > ; - < "The coupon rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Effect -{ - ItemList [ en-US ] = - { - < "Returns the effective annual interest rate"; > ; - < "Nominal rate"; > ; - < "The nominal rate"; > ; - < "Npery"; > ; - < "The periods"; > ; - }; -}; - -StringArray ANALYSIS_Cumprinc -{ - ItemList [ en-US ] = - { - < "Returns the cumulative principal on a loan to be paid between two periods"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Nper"; > ; - < "Number of payment periods"; > ; - < "Pv"; > ; - < "The present value"; > ; - < "Start period"; > ; - < "The start period"; > ; - < "End period"; > ; - < "The end period"; > ; - < "Type"; > ; - < "The type of maturity"; > ; - }; -}; - -StringArray ANALYSIS_Cumipmt -{ - ItemList [ en-US ] = - { - < "Returns the cumulative interest to be paid between two periods"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Nper"; > ; - < "Number of payment periods"; > ; - < "Pv"; > ; - < "The present value"; > ; - < "Start period"; > ; - < "The start period"; > ; - < "End period"; > ; - < "The end period"; > ; - < "Type"; > ; - < "The type of maturity"; > ; - }; -}; - -StringArray ANALYSIS_Price -{ - ItemList [ en-US ] = - { - < "Returns the price per 100 currency units face value of a security that pays periodic interest"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Pricedisc -{ - ItemList [ en-US ] = - { - < "Returns the price per 100 currency units face value of a discounted security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Discount"; > ; - < "The discount"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Pricemat -{ - ItemList [ en-US ] = - { - < "Returns the price per 100 currency units face value of a security that pays interest at maturity"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Issue"; > ; - < "The issue date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Mduration -{ - ItemList [ en-US ] = - { - < "Returns the Macaulay modified duration for a security with an assumed par value of 100 currency units"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Coupon"; > ; - < "The coupon rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Nominal -{ - ItemList [ en-US ] = - { - < "Returns the annual nominal interest rate"; > ; - < "Effective rate"; > ; - < "The effective interest rate"; > ; - < "Npery"; > ; - < "The periods"; > ; - }; -}; - -StringArray ANALYSIS_Dollarfr -{ - ItemList [ en-US ] = - { - < "Converts a price expressed as a decimal into a price expressed as a fraction"; > ; - < "Decimal dollar"; > ; - < "The decimal number"; > ; - < "Fraction"; > ; - < "The divisor"; > ; - }; -}; - -StringArray ANALYSIS_Dollarde -{ - ItemList [ en-US ] = - { - < "Converts a price expressed as a fraction into a price expressed as a decimal"; > ; - < "Fractional dollar"; > ; - < "The number as a fraction"; > ; - < "Fraction"; > ; - < "The divisor"; > ; - }; -}; - -StringArray ANALYSIS_Yield -{ - ItemList [ en-US ] = - { - < "Returns the yield on a security that pays periodic interest"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Price"; > ; - < "The price"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Yielddisc -{ - ItemList [ en-US ] = - { - < "Returns the annual yield for a discounted security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Price"; > ; - < "The price"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Yieldmat -{ - ItemList [ en-US ] = - { - < "Returns the annual yield of a security that pays interest at maturity"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Issue"; > ; - < "The issue date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Price"; > ; - < "The price"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Tbilleq -{ - ItemList [ en-US ] = - { - < "Returns the bond-equivalent yield for a treasury bill"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Discount"; > ; - < "The discount rate"; > ; - }; -}; - -StringArray ANALYSIS_Tbillprice -{ - ItemList [ en-US ] = - { - < "Returns the price of 100 currency units face value for a treasury bill"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Discount"; > ; - < "The discount rate"; > ; - }; -}; - -StringArray ANALYSIS_Tbillyield -{ - ItemList [ en-US ] = - { - < "Returns the yield for a treasury bill"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Price"; > ; - < "The price"; > ; - }; -}; - -StringArray ANALYSIS_Oddfprice -{ - ItemList [ en-US ] = - { - < "Returns the price per $100 face value of a security with an odd first period"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Issue"; > ; - < "The issue date"; > ; - < "First coupon"; > ; - < "The first coupon date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Oddfyield -{ - ItemList [ en-US ] = - { - < "Returns the yield of a security with an odd first period"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Issue"; > ; - < "The issue date"; > ; - < "First coupon"; > ; - < "The first coupon date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Price"; > ; - < "The price"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Oddlprice -{ - ItemList [ en-US ] = - { - < "Returns the price per $100 face value of a security with an odd last period"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Last interest"; > ; - < "The last interest date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Yield"; > ; - < "The yield"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Oddlyield -{ - ItemList [ en-US ] = - { - < "Returns the yield of a security with an odd last period"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Last interest"; > ; - < "The last interest date"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Price"; > ; - < "The price"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Xirr -{ - ItemList [ en-US ] = - { - < "Returns the internal rate of return for a non-periodic schedule of payments"; > ; - < "Values"; > ; - < "The values"; > ; - < "Dates"; > ; - < "The dates"; > ; - < "Guess"; > ; - < "The guess"; > ; - }; -}; - -StringArray ANALYSIS_Xnpv -{ - ItemList [ en-US ] = - { - < "Returns the net present value for a non-periodic schedule of payments"; > ; - < "Rate"; > ; - < "The rate"; > ; - < "Values"; > ; - < "The values"; > ; - < "Dates"; > ; - < "The dates"; > ; - }; -}; - -StringArray ANALYSIS_Intrate -{ - ItemList [ en-US ] = - { - < "Returns the interest rate for a fully invested security"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Investment"; > ; - < "The investment"; > ; - < "Redemption"; > ; - < "The redemption value"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Coupncd -{ - ItemList [ en-US ] = - { - < "Returns the first coupon date after the settlement date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Coupdays -{ - ItemList [ en-US ] = - { - < "Returns the number of days in the coupon period containing the settlement date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Coupdaysnc -{ - ItemList [ en-US ] = - { - < "Returns the number of days from the settlement date to the next coupon date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Coupdaybs -{ - ItemList [ en-US ] = - { - < "Returns the number of days from the beginning of the coupon period to the settlement date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Couppcd -{ - ItemList [ en-US ] = - { - < "Returns the last coupon date preceding the settlement date"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Coupnum -{ - ItemList [ en-US ] = - { - < "Returns the number of coupons payable between the settlement and maturity dates"; > ; - < "Settlement"; > ; - < "The settlement"; > ; - < "Maturity"; > ; - < "The maturity"; > ; - < "Frequency"; > ; - < "The frequency"; > ; - < "Basis"; > ; - < "The basis"; > ; - }; -}; - -StringArray ANALYSIS_Fvschedule -{ - ItemList [ en-US ] = - { - < "Returns the future value of the initial principal after a series of compound interest rates are applied"; > ; - < "Principal"; > ; - < "The principal"; > ; - < "Schedule"; > ; - < "The schedule"; > ; - }; -}; - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/analysis/analysis_funcnames.src b/scaddins/source/analysis/analysis_funcnames.src deleted file mode 100644 index 540bf2c30207..000000000000 --- a/scaddins/source/analysis/analysis_funcnames.src +++ /dev/null @@ -1,527 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#include "analysis.hrc" - -String ANALYSIS_FUNCNAME_Workday -{ - Text [ en-US ] = "WORKDAY"; -}; - -String ANALYSIS_FUNCNAME_Yearfrac -{ - Text [ en-US ] = "YEARFRAC"; -}; - -String ANALYSIS_FUNCNAME_Edate -{ - Text [ en-US ] = "EDATE"; -}; - -String ANALYSIS_FUNCNAME_Weeknum -{ - Text [ en-US ] = "WEEKNUM"; -}; - -String ANALYSIS_FUNCNAME_Eomonth -{ - Text [ en-US ] = "EOMONTH"; -}; - -String ANALYSIS_FUNCNAME_Networkdays -{ - Text [ en-US ] = "NETWORKDAYS"; -}; - -String ANALYSIS_FUNCNAME_Amordegrc -{ - Text [ en-US ] = "AMORDEGRC"; -}; - -String ANALYSIS_FUNCNAME_Amorlinc -{ - Text [ en-US ] = "AMORLINC"; -}; - -String ANALYSIS_FUNCNAME_Accrint -{ - Text [ en-US ] = "ACCRINT"; -}; - -String ANALYSIS_FUNCNAME_Accrintm -{ - Text [ en-US ] = "ACCRINTM"; -}; - -String ANALYSIS_FUNCNAME_Received -{ - Text [ en-US ] = "RECEIVED"; -}; - -String ANALYSIS_FUNCNAME_Disc -{ - Text [ en-US ] = "DISC"; -}; - -String ANALYSIS_FUNCNAME_Duration -{ - Text [ en-US ] = "DURATION"; -}; - -String ANALYSIS_FUNCNAME_Effect -{ - Text [ en-US ] = "EFFECT"; -}; - -String ANALYSIS_FUNCNAME_Cumprinc -{ - Text [ en-US ] = "CUMPRINC"; -}; - -String ANALYSIS_FUNCNAME_Cumipmt -{ - Text [ en-US ] = "CUMIPMT"; -}; - -String ANALYSIS_FUNCNAME_Price -{ - Text [ en-US ] = "PRICE"; -}; - -String ANALYSIS_FUNCNAME_Pricedisc -{ - Text [ en-US ] = "PRICEDISC"; -}; - -String ANALYSIS_FUNCNAME_Pricemat -{ - Text [ en-US ] = "PRICEMAT"; -}; - -String ANALYSIS_FUNCNAME_Mduration -{ - Text [ en-US ] = "MDURATION"; -}; - -String ANALYSIS_FUNCNAME_Nominal -{ - Text [ en-US ] = "NOMINAL"; -}; - -String ANALYSIS_FUNCNAME_Dollarfr -{ - Text [ en-US ] = "DOLLARFR"; -}; - -String ANALYSIS_FUNCNAME_Dollarde -{ - Text [ en-US ] = "DOLLARDE"; -}; - -String ANALYSIS_FUNCNAME_Yield -{ - Text [ en-US ] = "YIELD"; -}; - -String ANALYSIS_FUNCNAME_Yielddisc -{ - Text [ en-US ] = "YIELDDISC"; -}; - -String ANALYSIS_FUNCNAME_Yieldmat -{ - Text [ en-US ] = "YIELDMAT"; -}; - -String ANALYSIS_FUNCNAME_Tbilleq -{ - Text [ en-US ] = "TBILLEQ"; -}; - -String ANALYSIS_FUNCNAME_Tbillprice -{ - Text [ en-US ] = "TBILLPRICE"; -}; - -String ANALYSIS_FUNCNAME_Tbillyield -{ - Text [ en-US ] = "TBILLYIELD"; -}; - -String ANALYSIS_FUNCNAME_Oddfprice -{ - Text [ en-US ] = "ODDFPRICE"; -}; - -String ANALYSIS_FUNCNAME_Oddfyield -{ - Text [ en-US ] = "ODDFYIELD"; -}; - -String ANALYSIS_FUNCNAME_Oddlprice -{ - Text [ en-US ] = "ODDLPRICE"; -}; - -String ANALYSIS_FUNCNAME_Oddlyield -{ - Text [ en-US ] = "ODDLYIELD"; -}; - -String ANALYSIS_FUNCNAME_Xirr -{ - Text [ en-US ] = "XIRR"; -}; - -String ANALYSIS_FUNCNAME_Xnpv -{ - Text [ en-US ] = "XNPV"; -}; - -String ANALYSIS_FUNCNAME_Intrate -{ - Text [ en-US ] = "INTRATE"; -}; - -String ANALYSIS_FUNCNAME_Coupncd -{ - Text [ en-US ] = "COUPNCD"; -}; - -String ANALYSIS_FUNCNAME_Coupdays -{ - Text [ en-US ] = "COUPDAYS"; -}; - -String ANALYSIS_FUNCNAME_Coupdaysnc -{ - Text [ en-US ] = "COUPDAYSNC"; -}; - -String ANALYSIS_FUNCNAME_Coupdaybs -{ - Text [ en-US ] = "COUPDAYBS"; -}; - -String ANALYSIS_FUNCNAME_Couppcd -{ - Text [ en-US ] = "COUPPCD"; -}; - -String ANALYSIS_FUNCNAME_Coupnum -{ - Text [ en-US ] = "COUPNUM"; -}; - -String ANALYSIS_FUNCNAME_Fvschedule -{ - Text [ en-US ] = "FVSCHEDULE"; -}; - -String ANALYSIS_FUNCNAME_Iseven -{ - Text [ en-US ] = "ISEVEN"; -}; - -String ANALYSIS_FUNCNAME_Isodd -{ - Text [ en-US ] = "ISODD"; -}; - -String ANALYSIS_FUNCNAME_Gcd -{ - Text [ en-US ] = "GCD"; -}; - -String ANALYSIS_FUNCNAME_Lcm -{ - Text [ en-US ] = "LCM"; -}; - -String ANALYSIS_FUNCNAME_Multinomial -{ - Text [ en-US ] = "MULTINOMIAL"; -}; - -String ANALYSIS_FUNCNAME_Seriessum -{ - Text [ en-US ] = "SERIESSUM"; -}; - -String ANALYSIS_FUNCNAME_Quotient -{ - Text [ en-US ] = "QUOTIENT"; -}; - -String ANALYSIS_FUNCNAME_Mround -{ - Text [ en-US ] = "MROUND"; -}; - -String ANALYSIS_FUNCNAME_Sqrtpi -{ - Text [ en-US ] = "SQRTPI"; -}; - -String ANALYSIS_FUNCNAME_Randbetween -{ - Text [ en-US ] = "RANDBETWEEN"; -}; - -String ANALYSIS_FUNCNAME_Besseli -{ - Text [ en-US ] = "BESSELI"; -}; - -String ANALYSIS_FUNCNAME_Besselj -{ - Text [ en-US ] = "BESSELJ"; -}; - -String ANALYSIS_FUNCNAME_Besselk -{ - Text [ en-US ] = "BESSELK"; -}; - -String ANALYSIS_FUNCNAME_Bessely -{ - Text [ en-US ] = "BESSELY"; -}; - -String ANALYSIS_FUNCNAME_Bin2Dec -{ - Text [ en-US ] = "BIN2DEC"; -}; - -String ANALYSIS_FUNCNAME_Bin2Hex -{ - Text [ en-US ] = "BIN2HEX"; -}; - -String ANALYSIS_FUNCNAME_Bin2Oct -{ - Text [ en-US ] = "BIN2OCT"; -}; - -String ANALYSIS_FUNCNAME_Delta -{ - Text [ en-US ] = "DELTA"; -}; - -String ANALYSIS_FUNCNAME_Dec2Bin -{ - Text [ en-US ] = "DEC2BIN"; -}; - -String ANALYSIS_FUNCNAME_Dec2Hex -{ - Text [ en-US ] = "DEC2HEX"; -}; - -String ANALYSIS_FUNCNAME_Dec2Oct -{ - Text [ en-US ] = "DEC2OCT"; -}; - -String ANALYSIS_FUNCNAME_Erf -{ - Text [ en-US ] = "ERF"; -}; - -String ANALYSIS_FUNCNAME_Erfc -{ - Text [ en-US ] = "ERFC"; -}; - -String ANALYSIS_FUNCNAME_Gestep -{ - Text [ en-US ] = "GESTEP"; -}; - -String ANALYSIS_FUNCNAME_Hex2Bin -{ - Text [ en-US ] = "HEX2BIN"; -}; - -String ANALYSIS_FUNCNAME_Hex2Dec -{ - Text [ en-US ] = "HEX2DEC"; -}; - -String ANALYSIS_FUNCNAME_Hex2Oct -{ - Text [ en-US ] = "HEX2OCT"; -}; - -String ANALYSIS_FUNCNAME_Imabs -{ - Text [ en-US ] = "IMABS"; -}; - -String ANALYSIS_FUNCNAME_Imaginary -{ - Text [ en-US ] = "IMAGINARY"; -}; - -String ANALYSIS_FUNCNAME_Impower -{ - Text [ en-US ] = "IMPOWER"; -}; - -String ANALYSIS_FUNCNAME_Imargument -{ - Text [ en-US ] = "IMARGUMENT"; -}; - -String ANALYSIS_FUNCNAME_Imcos -{ - Text [ en-US ] = "IMCOS"; -}; - -String ANALYSIS_FUNCNAME_Imdiv -{ - Text [ en-US ] = "IMDIV"; -}; - -String ANALYSIS_FUNCNAME_Imexp -{ - Text [ en-US ] = "IMEXP"; -}; - -String ANALYSIS_FUNCNAME_Imconjugate -{ - Text [ en-US ] = "IMCONJUGATE"; -}; - -String ANALYSIS_FUNCNAME_Imln -{ - Text [ en-US ] = "IMLN"; -}; - -String ANALYSIS_FUNCNAME_Imlog10 -{ - Text [ en-US ] = "IMLOG10"; -}; - -String ANALYSIS_FUNCNAME_Imlog2 -{ - Text [ en-US ] = "IMLOG2"; -}; - -String ANALYSIS_FUNCNAME_Improduct -{ - Text [ en-US ] = "IMPRODUCT"; -}; - -String ANALYSIS_FUNCNAME_Imreal -{ - Text [ en-US ] = "IMREAL"; -}; - -String ANALYSIS_FUNCNAME_Imsin -{ - Text [ en-US ] = "IMSIN"; -}; - -String ANALYSIS_FUNCNAME_Imsub -{ - Text [ en-US ] = "IMSUB"; -}; - -String ANALYSIS_FUNCNAME_Imsum -{ - Text [ en-US ] = "IMSUM"; -}; - -String ANALYSIS_FUNCNAME_Imsqrt -{ - Text [ en-US ] = "IMSQRT"; -}; - -String ANALYSIS_FUNCNAME_Imtan -{ - Text [ en-US ] = "IMTAN"; -}; - -String ANALYSIS_FUNCNAME_Imsec -{ - Text [ en-US ] = "IMSEC"; -}; - -String ANALYSIS_FUNCNAME_Imcsc -{ - Text [ en-US ] = "IMCSC"; -}; - -String ANALYSIS_FUNCNAME_Imcot -{ - Text [ en-US ] = "IMCOT"; -}; - -String ANALYSIS_FUNCNAME_Imsinh -{ - Text [ en-US ] = "IMSINH"; -}; - -String ANALYSIS_FUNCNAME_Imcosh -{ - Text [ en-US ] = "IMCOSH"; -}; - -String ANALYSIS_FUNCNAME_Imsech -{ - Text [ en-US ] = "IMSECH"; -}; - -String ANALYSIS_FUNCNAME_Imcsch -{ - Text [ en-US ] = "IMCSCH"; -}; - -String ANALYSIS_FUNCNAME_Complex -{ - Text [ en-US ] = "COMPLEX"; -}; - -String ANALYSIS_FUNCNAME_Oct2Bin -{ - Text [ en-US ] = "OCT2BIN"; -}; - -String ANALYSIS_FUNCNAME_Oct2Dec -{ - Text [ en-US ] = "OCT2DEC"; -}; - -String ANALYSIS_FUNCNAME_Oct2Hex -{ - Text [ en-US ] = "OCT2HEX"; -}; - -String ANALYSIS_FUNCNAME_Convert -{ - Text [ en-US ] = "CONVERT"; -}; - -String ANALYSIS_FUNCNAME_Factdouble -{ - Text [ en-US ] = "FACTDOUBLE"; -}; - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/analysis/analysishelper.cxx b/scaddins/source/analysis/analysishelper.cxx index 6b7e3dbe8501..1225f20027ee 100644 --- a/scaddins/source/analysis/analysishelper.cxx +++ b/scaddins/source/analysis/analysishelper.cxx @@ -23,13 +23,13 @@ #include <string.h> #include <stdio.h> #include <o3tl/any.hxx> -#include <tools/resary.hxx> #include <rtl/math.hxx> #include <sal/macros.h> #include <algorithm> #include <memory> #include "analysishelper.hxx" #include "analysis.hrc" +#include "strings.hrc" #include "deffuncname.hxx" using namespace ::com::sun::star; @@ -1375,8 +1375,8 @@ double GetCoupnum( sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_I FuncData::FuncData(const FuncDataBase& r) : aIntName( OUString::createFromAscii( r.pIntName ) ), - nUINameID( r.nUINameID ), - nDescrID( r.nDescrID ), + pUINameID( r.pUINameID ), + pDescrID( r.pDescrID ), bDouble( r.bDouble ), bWithOpt( r.bWithOpt ), nParam( r.nNumOfParams ), @@ -1411,10 +1411,6 @@ void InitFuncDataList(FuncDataList& rList) rList.push_back(FuncData(rFuncData)); } -AnalysisResId::AnalysisResId( sal_uInt16 nId, ResMgr& rResMgr ) : ResId( nId, rResMgr ) -{ -} - SortedIndividualInt32List::SortedIndividualInt32List() { } diff --git a/scaddins/source/analysis/analysishelper.hxx b/scaddins/source/analysis/analysishelper.hxx index 8e4528339c39..591150aaaafa 100644 --- a/scaddins/source/analysis/analysishelper.hxx +++ b/scaddins/source/analysis/analysishelper.hxx @@ -32,15 +32,11 @@ #include <math.h> -#include <tools/resid.hxx> - #include "analysisdefs.hxx" #include <vector> -class ResMgr; - namespace sca { namespace analysis { class SortedIndividualInt32List; @@ -202,8 +198,8 @@ enum class FDCategory struct FuncDataBase { const sal_Char* pIntName; - sal_uInt16 nUINameID; // resource ID to UI name - sal_uInt16 nDescrID; // resource ID to description, parameter names and ~ description + const char* pUINameID; // resource ID to UI name + const char** pDescrID; // resource ID to description, parameter names and ~ description bool bDouble; // name already exist in Calc bool bWithOpt; // first parameter is internal const char** pCompListID; // list of valid names @@ -217,8 +213,8 @@ class FuncData final { private: OUString aIntName; - sal_uInt16 nUINameID; - sal_uInt16 nDescrID; // leads also to parameter descriptions! + const char* pUINameID; + const char** pDescrID; // leads also to parameter descriptions! bool bDouble; // flag for names that already exist in Calc bool bWithOpt; // has internal parameter on first position @@ -231,8 +227,8 @@ public: FuncData(const FuncDataBase& rBaseData); ~FuncData(); - inline sal_uInt16 GetUINameID() const; - inline sal_uInt16 GetDescrID() const; + inline const char* GetUINameID() const; + inline const char** GetDescrID() const; inline bool IsDouble() const; inline const OUString& GetSuffix() const; @@ -257,12 +253,6 @@ struct FindFuncData bool operator() ( FuncData const & rCandidate ) const { return rCandidate.Is(m_rId); } }; -class AnalysisResId : public ResId -{ - public: - AnalysisResId( sal_uInt16 nId, ResMgr& rResMgr ); -}; - /// sorted list with unique sal_Int32 values class SortedIndividualInt32List final { @@ -626,15 +616,15 @@ inline double GetYearFrac( const css::uno::Reference< css::beans::XPropertySet > } -inline sal_uInt16 FuncData::GetUINameID() const +inline const char* FuncData::GetUINameID() const { - return nUINameID; + return pUINameID; } -inline sal_uInt16 FuncData::GetDescrID() const +inline const char** FuncData::GetDescrID() const { - return nDescrID; + return pDescrID; } diff --git a/scaddins/source/datefunc/datefunc.cxx b/scaddins/source/datefunc/datefunc.cxx index d2a33ccf5398..ef73390c854b 100644 --- a/scaddins/source/datefunc/datefunc.cxx +++ b/scaddins/source/datefunc/datefunc.cxx @@ -19,11 +19,11 @@ #include "datefunc.hxx" #include "datefunc.hrc" +#include "strings.hrc" #include <com/sun/star/util/Date.hpp> #include <cppuhelper/factory.hxx> #include <cppuhelper/supportsservice.hxx> #include <rtl/ustrbuf.hxx> -#include <tools/rcid.h> #include <tools/resmgr.hxx> #include <algorithm> #include "deffuncname.hxx" @@ -34,11 +34,6 @@ using namespace ::com::sun::star; #define MY_SERVICE "com.sun.star.sheet.addin.DateFunctions" #define MY_IMPLNAME "com.sun.star.sheet.addin.DateFunctionsImpl" -ScaResId::ScaResId( sal_uInt16 nId, ResMgr& rResMgr ) : - ResId( nId, rResMgr ) -{ -} - #define UNIQUE false // function name does not exist in Calc #define STDPAR false // all parameters are described @@ -63,8 +58,8 @@ const ScaFuncDataBase pFuncDataArr[] = ScaFuncData::ScaFuncData(const ScaFuncDataBase& rBaseData) : aIntName( OUString::createFromAscii( rBaseData.pIntName ) ), - nUINameID( rBaseData.nUINameID ), - nDescrID( rBaseData.nDescrID ), + pUINameID( rBaseData.pUINameID ), + pDescrID( rBaseData.pDescrID ), nParamCount( rBaseData.nParamCount ), eCat( rBaseData.eCat ), bDouble( rBaseData.bDouble ), @@ -129,7 +124,6 @@ SAL_DLLPUBLIC_EXPORT void * SAL_CALL date_component_getFactory( // "normal" service implementation ScaDateAddIn::ScaDateAddIn() : pDefLocales( nullptr ), - pResMgr( nullptr ), pFuncDataList( nullptr ) { } @@ -157,20 +151,9 @@ const lang::Locale& ScaDateAddIn::GetLocale( sal_uInt32 nIndex ) return (nIndex < sizeof( pLang )) ? pDefLocales[ nIndex ] : aFuncLoc; } -ResMgr& ScaDateAddIn::GetResMgr() -{ - if( !pResMgr ) - { - InitData(); // try to get resource manager - if( !pResMgr ) - throw uno::RuntimeException(); - } - return *pResMgr; -} - void ScaDateAddIn::InitData() { - pResMgr.reset(ResMgr::CreateResMgr("date", LanguageTag(aFuncLoc))); + aResLocale = Translate::Create("sca", LanguageTag(aFuncLoc)); pFuncDataList.reset(); pFuncDataList.reset(new ScaFuncDataList); @@ -182,10 +165,9 @@ void ScaDateAddIn::InitData() } } -OUString ScaDateAddIn::GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ) +OUString ScaDateAddIn::GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex) { - ResStringArray aArr(ScaResId(nResId, GetResMgr())); - return aArr.GetString(nStrIndex - 1); + return ScaResId(pResId[nStrIndex - 1]); } OUString ScaDateAddIn::getImplementationName_Static() @@ -252,7 +234,7 @@ OUString SAL_CALL ScaDateAddIn::getDisplayFunctionName( const OUString& aProgram FindScaFuncData( aProgrammaticName ) ); if( fDataIt != pFuncDataList->end() ) { - aRet = ScaResId(fDataIt->GetUINameID(), GetResMgr()); + aRet = ScaResId(fDataIt->GetUINameID()); if( fDataIt->IsDouble() ) aRet += "_ADD"; } @@ -770,4 +752,9 @@ OUString SAL_CALL ScaDateAddIn::getRot13( const OUString& aSrcString ) return aBuffer.makeStringAndClear(); } +OUString ScaDateAddIn::ScaResId(const char* pId) +{ + return Translate::get(pId, aResLocale); +} + /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/datefunc/datefunc.hrc b/scaddins/source/datefunc/datefunc.hrc deleted file mode 100644 index 44653ef848a2..000000000000 --- a/scaddins/source/datefunc/datefunc.hrc +++ /dev/null @@ -1,49 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#ifndef INCLUDED_SCADDINS_SOURCE_DATEFUNC_DATEFUNC_HRC -#define INCLUDED_SCADDINS_SOURCE_DATEFUNC_DATEFUNC_HRC - -#define DATE_RESOURCE_START 1000 - -#define DATE_FUNCDESC_START DATE_RESOURCE_START - -#define DATE_FUNCDESC_DiffWeeks (DATE_FUNCDESC_START) -#define DATE_FUNCDESC_DiffMonths (DATE_FUNCDESC_START+1) -#define DATE_FUNCDESC_DiffYears (DATE_FUNCDESC_START+2) -#define DATE_FUNCDESC_IsLeapYear (DATE_FUNCDESC_START+3) -#define DATE_FUNCDESC_DaysInMonth (DATE_FUNCDESC_START+4) -#define DATE_FUNCDESC_DaysInYear (DATE_FUNCDESC_START+5) -#define DATE_FUNCDESC_WeeksInYear (DATE_FUNCDESC_START+6) -#define DATE_FUNCDESC_Rot13 (DATE_FUNCDESC_START+7) - -#define DATE_FUNCNAME_START (DATE_RESOURCE_START+1000) - -#define DATE_FUNCNAME_DiffWeeks (DATE_FUNCNAME_START) -#define DATE_FUNCNAME_DiffMonths (DATE_FUNCNAME_START+1) -#define DATE_FUNCNAME_DiffYears (DATE_FUNCNAME_START+2) -#define DATE_FUNCNAME_IsLeapYear (DATE_FUNCNAME_START+3) -#define DATE_FUNCNAME_DaysInMonth (DATE_FUNCNAME_START+4) -#define DATE_FUNCNAME_DaysInYear (DATE_FUNCNAME_START+5) -#define DATE_FUNCNAME_WeeksInYear (DATE_FUNCNAME_START+6) -#define DATE_FUNCNAME_Rot13 (DATE_FUNCNAME_START+7) - -#endif - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/datefunc/datefunc.hxx b/scaddins/source/datefunc/datefunc.hxx index 816aaffd6c19..51b2899daeef 100644 --- a/scaddins/source/datefunc/datefunc.hxx +++ b/scaddins/source/datefunc/datefunc.hxx @@ -33,14 +33,6 @@ #include <com/sun/star/sheet/addin/XDateFunctions.hpp> #include <com/sun/star/sheet/addin/XMiscFunctions.hpp> #include <cppuhelper/implbase.hxx> -#include <tools/resid.hxx> -#include <tools/resary.hxx> - -class ScaResId : public ResId -{ -public: - ScaResId(sal_uInt16 nResId, ResMgr& rResMgr); -}; enum class ScaCategory { @@ -55,8 +47,8 @@ enum class ScaCategory struct ScaFuncDataBase { const sal_Char* pIntName; // internal name (get***) - sal_uInt16 nUINameID; // resource ID to UI name - sal_uInt16 nDescrID; // resource ID to description, parameter names and ~ description + const char* pUINameID; // resource ID to UI name + const char** pDescrID; // resource ID to description, parameter names and ~ description const char** pCompListID; // list of valid names sal_uInt16 nParamCount; // number of named / described parameters ScaCategory eCat; // function category @@ -68,8 +60,8 @@ class ScaFuncData final { private: OUString aIntName; // internal name (get***) - sal_uInt16 nUINameID; // resource ID to UI name - sal_uInt16 nDescrID; // leads also to parameter descriptions! + const char* pUINameID; // resource ID to UI name + const char** pDescrID; // leads also to parameter descriptions! sal_uInt16 nParamCount; // num of parameters std::vector<OUString> aCompList; // list of all valid names ScaCategory eCat; // function category @@ -80,8 +72,8 @@ public: ScaFuncData(const ScaFuncDataBase& rBaseData); ~ScaFuncData(); - sal_uInt16 GetUINameID() const { return nUINameID; } - sal_uInt16 GetDescrID() const { return nDescrID; } + const char* GetUINameID() const { return pUINameID; } + const char** GetDescrID() const { return pDescrID; } ScaCategory GetCategory() const { return eCat; } bool IsDouble() const { return bDouble; } @@ -120,22 +112,22 @@ class ScaDateAddIn : public ::cppu::WeakImplHelper< private: css::lang::Locale aFuncLoc; std::unique_ptr< css::lang::Locale[] > pDefLocales; - std::unique_ptr< ResMgr > pResMgr; + std::locale aResLocale; std::unique_ptr< ScaFuncDataList > pFuncDataList; void InitDefLocales(); const css::lang::Locale& GetLocale( sal_uInt32 nIndex ); - /// @throws css::uno::RuntimeException - ResMgr& GetResMgr(); void InitData(); /// @throws css::uno::RuntimeException - OUString GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ); + OUString GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex); public: ScaDateAddIn(); + OUString ScaResId(const char* pId); + static OUString getImplementationName_Static(); static css::uno::Sequence< OUString > getSupportedServiceNames_Static(); diff --git a/scaddins/source/datefunc/datefunc.src b/scaddins/source/datefunc/datefunc.src deleted file mode 100644 index 9e8632995a37..000000000000 --- a/scaddins/source/datefunc/datefunc.src +++ /dev/null @@ -1,154 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#include "datefunc.hrc" - -StringArray DATE_FUNCDESC_DiffWeeks -{ - ItemList [ en-US ] = - { - < "Calculates the number of weeks in a specific period"; > ; - < "Start date"; > ; - < "First day of the period"; > ; - < "End date"; > ; - < "Last day of the period"; > ; - < "Type"; > ; - < "Type of calculation: Type=0 means the time interval, Type=1 means calendar weeks."; > ; - }; -}; - -StringArray DATE_FUNCDESC_DiffMonths -{ - ItemList [ en-US ] = - { - < "Determines the number of months in a specific period."; > ; - < "Start date"; > ; - < "First day of the period."; > ; - < "End date"; > ; - < "Last day of the period."; > ; - < "Type"; > ; - < "Type of calculation: Type=0 means the time interval, Type=1 means calendar months."; > ; - }; -}; - -StringArray DATE_FUNCDESC_DiffYears -{ - ItemList [ en-US ] = - { - < "Calculates the number of years in a specific period."; > ; - < "Start date"; > ; - < "First day of the period"; > ; - < "End date"; > ; - < "Last day of the period"; > ; - < "Type"; > ; - < "Type of calculation: Type=0 means the time interval, Type=1 means calendar years."; > ; - }; -}; - -StringArray DATE_FUNCDESC_IsLeapYear -{ - ItemList [ en-US ] = - { - < "Returns 1 (TRUE) if the date is a day of a leap year, otherwise 0 (FALSE)."; > ; - < "Date"; > ; - < "Any day in the desired year"; > ; - }; -}; - -StringArray DATE_FUNCDESC_DaysInMonth -{ - ItemList [ en-US ] = - { - < "Returns the number of days of the month in which the date entered occurs"; > ; - < "Date"; > ; - < "Any day in the desired month"; > ; - }; -}; - -StringArray DATE_FUNCDESC_DaysInYear -{ - ItemList [ en-US ] = - { - < "Returns the number of days of the year in which the date entered occurs."; > ; - < "Date"; > ; - < "Any day in the desired year"; > ; - }; -}; - -StringArray DATE_FUNCDESC_WeeksInYear -{ - ItemList [ en-US ] = - { - < "Returns the number of weeks of the year in which the date entered occurs"; > ; - < "Date"; > ; - < "Any day in the desired year"; > ; - }; -}; - -StringArray DATE_FUNCDESC_Rot13 -{ - ItemList [ en-US ] = - { - < "Encrypts or decrypts a text using the ROT13 algorithm"; > ; - < "Text"; > ; - < "Text to be encrypted or text already encrypted"; > ; - }; -}; - -String DATE_FUNCNAME_DiffWeeks -{ - Text [ en-US ] = "WEEKS"; -}; - -String DATE_FUNCNAME_DiffMonths -{ - Text [ en-US ] = "MONTHS"; -}; - -String DATE_FUNCNAME_DiffYears -{ - Text [ en-US ] = "YEARS"; -}; - -String DATE_FUNCNAME_IsLeapYear -{ - Text [ en-US ] = "ISLEAPYEAR"; -}; - -String DATE_FUNCNAME_DaysInMonth -{ - Text [ en-US ] = "DAYSINMONTH"; -}; - -String DATE_FUNCNAME_DaysInYear -{ - Text [ en-US ] = "DAYSINYEAR"; -}; - -String DATE_FUNCNAME_WeeksInYear -{ - Text [ en-US ] = "WEEKSINYEAR"; -}; - -String DATE_FUNCNAME_Rot13 -{ - Text [ en-US ] = "ROT13"; -}; - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/pricing/pricing.cxx b/scaddins/source/pricing/pricing.cxx index 466c0e78fd44..3df3fe78a061 100644 --- a/scaddins/source/pricing/pricing.cxx +++ b/scaddins/source/pricing/pricing.cxx @@ -25,6 +25,7 @@ #include "pricing.hxx" #include "black_scholes.hxx" #include "pricing.hrc" +#include "strings.hrc" #include <cppuhelper/factory.hxx> #include <cppuhelper/supportsservice.hxx> @@ -32,7 +33,6 @@ #include <algorithm> #include <rtl/math.hxx> #include <rtl/ustrbuf.hxx> -#include <tools/rcid.h> #include <tools/resmgr.hxx> using namespace ::com::sun::star; @@ -43,11 +43,6 @@ using namespace sca::pricing; #define MY_SERVICE "com.sun.star.sheet.addin.PricingFunctions" #define MY_IMPLNAME "com.sun.star.sheet.addin.PricingFunctionsImpl" -ScaResId::ScaResId( sal_uInt16 nId, ResMgr& rResMgr ) : - ResId( nId, rResMgr ) -{ -} - #define UNIQUE false // function name does not exist in Calc #define STDPAR false // all parameters are described @@ -67,8 +62,8 @@ const ScaFuncDataBase pFuncDataArr[] = ScaFuncData::ScaFuncData( const ScaFuncDataBase& rBaseData ) : aIntName( OUString::createFromAscii( rBaseData.pIntName ) ), - nUINameID( rBaseData.nUINameID ), - nDescrID( rBaseData.nDescrID ), + pUINameID( rBaseData.pUINameID ), + pDescrID( rBaseData.pDescrID ), nParamCount( rBaseData.nParamCount ), eCat( rBaseData.eCat ), bDouble( rBaseData.bDouble ), @@ -132,7 +127,6 @@ SAL_DLLPUBLIC_EXPORT void * SAL_CALL pricing_component_getFactory( // "normal" service implementation ScaPricingAddIn::ScaPricingAddIn() : pDefLocales( nullptr ), - pResMgr( nullptr ), pFuncDataList( nullptr ) { } @@ -140,7 +134,6 @@ ScaPricingAddIn::ScaPricingAddIn() : ScaPricingAddIn::~ScaPricingAddIn() { delete pFuncDataList; - delete pResMgr; delete[] pDefLocales; } @@ -167,32 +160,13 @@ const lang::Locale& ScaPricingAddIn::GetLocale( sal_uInt32 nIndex ) return (nIndex < sizeof( pLang )) ? pDefLocales[ nIndex ] : aFuncLoc; } -ResMgr& ScaPricingAddIn::GetResMgr() -{ - if( !pResMgr ) - { - InitData(); // try to get resource manager - if( !pResMgr ) - throw uno::RuntimeException(); - } - return *pResMgr; -} - void ScaPricingAddIn::InitData() { - delete pResMgr; - pResMgr = ResMgr::CreateResMgr("pricing", LanguageTag( aFuncLoc) ); + aResLocale = Translate::Create("sca", LanguageTag(aFuncLoc)); delete pFuncDataList; - if(pResMgr) - { - pFuncDataList = new ScaFuncDataList; - InitScaFuncDataList(*pFuncDataList); - } - else - { - pFuncDataList = nullptr; - } + pFuncDataList = new ScaFuncDataList; + InitScaFuncDataList(*pFuncDataList); if( pDefLocales ) { @@ -201,10 +175,9 @@ void ScaPricingAddIn::InitData() } } -OUString ScaPricingAddIn::GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ) +OUString ScaPricingAddIn::GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex) { - ResStringArray aArr(ScaResId(nResId, GetResMgr())); - return aArr.GetString(nStrIndex - 1); + return ScaResId(pResId[nStrIndex - 1]); } OUString ScaPricingAddIn::getImplementationName_Static() @@ -271,9 +244,9 @@ OUString SAL_CALL ScaPricingAddIn::getDisplayFunctionName( const OUString& aProg auto fDataIt = std::find_if(pFuncDataList->begin(), pFuncDataList->end(), FindScaFuncData( aProgrammaticName ) ); - if(fDataIt != pFuncDataList->end() ) + if (fDataIt != pFuncDataList->end() ) { - aRet = ScaResId(fDataIt->GetUINameID(), GetResMgr()); + aRet = ScaResId(fDataIt->GetUINameID()); if( fDataIt->IsDouble() ) aRet += "_ADD"; } @@ -583,5 +556,9 @@ double SAL_CALL ScaPricingAddIn::getOptProbInMoney( double spot, double vol, RETURN_FINITE( fRet ); } +OUString ScaPricingAddIn::ScaResId(const char* pResId) +{ + return Translate::get(pResId, aResLocale); +} /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/pricing/pricing.hrc b/scaddins/source/pricing/pricing.hrc deleted file mode 100644 index af516650eb75..000000000000 --- a/scaddins/source/pricing/pricing.hrc +++ /dev/null @@ -1,41 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#ifndef INCLUDED_SCADDINS_SOURCE_PRICING_PRICING_HRC -#define INCLUDED_SCADDINS_SOURCE_PRICING_PRICING_HRC - -#define PRICING_RESOURCE_START 1000 - -#define PRICING_FUNCDESC_START PRICING_RESOURCE_START - -#define PRICING_FUNCDESC_OptBarrier (PRICING_FUNCDESC_START) -#define PRICING_FUNCDESC_OptTouch (PRICING_FUNCDESC_START+1) -#define PRICING_FUNCDESC_OptProbHit (PRICING_FUNCDESC_START+2) -#define PRICING_FUNCDESC_OptProbInMoney (PRICING_FUNCDESC_START+3) - -#define PRICING_FUNCNAME_START (PRICING_RESOURCE_START+1000) - -#define PRICING_FUNCNAME_OptBarrier (PRICING_FUNCNAME_START) -#define PRICING_FUNCNAME_OptTouch (PRICING_FUNCNAME_START+1) -#define PRICING_FUNCNAME_OptProbHit (PRICING_FUNCNAME_START+2) -#define PRICING_FUNCNAME_OptProbInMoney (PRICING_FUNCNAME_START+3) - -#endif - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ diff --git a/scaddins/source/pricing/pricing.hxx b/scaddins/source/pricing/pricing.hxx index 18acc54c811f..82fbbb6cacc5 100644 --- a/scaddins/source/pricing/pricing.hxx +++ b/scaddins/source/pricing/pricing.hxx @@ -37,8 +37,6 @@ #include <com/sun/star/sheet/XCompatibilityNames.hpp> #include <com/sun/star/sheet/addin/XPricingFunctions.hpp> #include <cppuhelper/implbase.hxx> -#include <tools/resid.hxx> -#include <tools/resary.hxx> #define RETURN_FINITE(d) if( ::rtl::math::isFinite( d ) ) return d; else throw css::lang::IllegalArgumentException() @@ -46,12 +44,6 @@ namespace sca { namespace pricing { -class ScaResId : public ResId -{ -public: - ScaResId( sal_uInt16 nResId, ResMgr& rResMgr ); -}; - enum class ScaCategory { DateTime, @@ -65,8 +57,8 @@ enum class ScaCategory struct ScaFuncDataBase { const sal_Char* pIntName; // internal name (get***) - sal_uInt16 nUINameID; // resource ID to UI name - sal_uInt16 nDescrID; // resource ID to description, parameter names and ~ description + const char* pUINameID; // resource ID to UI name + const char** pDescrID; // resource ID to description, parameter names and ~ description // pCompName was originally meant to be able to load Excel documents that for // some time were stored with localized function names. // This is not relevant to this add-in, so we only supply the same @@ -82,12 +74,12 @@ struct ScaFuncDataBase class ScaFuncData final { private: - OUString aIntName; // internal name (get***) - sal_uInt16 nUINameID; // resource ID to UI name - sal_uInt16 nDescrID; // leads also to parameter descriptions! - sal_uInt16 nParamCount; // num of parameters - std::vector<OUString> aCompList; // list of all valid names - ScaCategory eCat; // function category + OUString aIntName; // internal name (get***) + const char* pUINameID; // resource ID to UI name + const char** pDescrID; // leads also to parameter descriptions! + sal_uInt16 nParamCount; // num of parameters + std::vector<OUString> aCompList; // list of all valid names + ScaCategory eCat; // function category bool bDouble; // name already exist in Calc bool bWithOpt; // first parameter is internal @@ -95,8 +87,8 @@ public: ScaFuncData(const ScaFuncDataBase& rBaseData); ~ScaFuncData(); - sal_uInt16 GetUINameID() const { return nUINameID; } - sal_uInt16 GetDescrID() const { return nDescrID; } + const char* GetUINameID() const { return pUINameID; } + const char** GetDescrID() const { return pDescrID; } ScaCategory GetCategory() const { return eCat; } bool IsDouble() const { return bDouble; } @@ -140,23 +132,23 @@ class ScaPricingAddIn : public ::cppu::WeakImplHelper< private: css::lang::Locale aFuncLoc; css::lang::Locale* pDefLocales; - ResMgr* pResMgr; + std::locale aResLocale; sca::pricing::ScaFuncDataList* pFuncDataList; void InitDefLocales(); const css::lang::Locale& GetLocale( sal_uInt32 nIndex ); - /// @throws css::uno::RuntimeException - ResMgr& GetResMgr(); void InitData(); /// @throws css::uno::RuntimeException - OUString GetFuncDescrStr( sal_uInt16 nResId, sal_uInt16 nStrIndex ); + OUString GetFuncDescrStr(const char** pResId, sal_uInt16 nStrIndex); public: ScaPricingAddIn(); virtual ~ScaPricingAddIn() override; + OUString ScaResId(const char* pResId); + static OUString getImplementationName_Static(); static css::uno::Sequence< OUString > getSupportedServiceNames_Static(); diff --git a/scaddins/source/pricing/pricing.src b/scaddins/source/pricing/pricing.src deleted file mode 100644 index d1ed46a08898..000000000000 --- a/scaddins/source/pricing/pricing.src +++ /dev/null @@ -1,153 +0,0 @@ -/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you under the Apache - * License, Version 2.0 (the "License"); you may not use this file - * except in compliance with the License. You may obtain a copy of - * the License at http://www.apache.org/licenses/LICENSE-2.0 . - */ - -#include "pricing.hrc" - -// function and parameter description -StringArray PRICING_FUNCDESC_OptBarrier -{ - ItemList [ en-US ] = - { - < "Pricing of a barrier option"; > ; - < "spot"; > ; - < "Price/value of the underlying asset"; > ; - < "vol"; > ; - < "Annual volatility of the underlying asset"; > ; - < "r"; > ; - < "Interest rate (continuously compounded)"; > ; - < "rf"; > ; - < "Foreign interest rate (continuously compounded)"; > ; - < "T"; > ; - < "Time to maturity of the option in years"; > ; - < "strike"; > ; - < "Strike level of the option"; > ; - < "barrier_low"; > ; - < "Lower barrier (set to 0 for no lower barrier)"; > ; - < "barrier_up"; > ; - < "Upper barrier (set to 0 for no upper barrier)"; > ; - < "rebate"; > ; - < "Amount of money paid at maturity if barrier was hit"; > ; - < "put/call"; > ; - < "String to define if the option is a (p)ut or a (c)all"; > ; - < "knock in/out"; > ; - < "String to define if the option is of type knock-(i)n or knock-(o)ut"; > ; - < "barrier_type"; > ; - < "String to define whether the barrier is observed (c)ontinuously or only at the (e)nd/maturity"; > ; - < "greek"; > ; - < "Optional parameter, if left out then the function simply returns the option price; if set, the function returns price sensitivities (Greeks) to one of the input parameters; possible values are (d)elta, (g)amma, (t)heta, v(e)ga, v(o)lga, v(a)nna, (r)ho, rho(f)"; > ; - }; -}; - -StringArray PRICING_FUNCDESC_OptTouch -{ - ItemList [ en-US ] = - { - < "Pricing of a touch/no-touch option"; > ; - < "spot"; > ; - < "Price/value of the underlying asset"; > ; - < "vol"; > ; - < "Annual volatility of the underlying asset"; > ; - < "r"; > ; - < "Interest rate (continuously compounded)"; > ; - < "rf"; > ; - < "Foreign interest rate (continuously compounded)"; > ; - < "T"; > ; - < "Time to maturity of the option in years"; > ; - < "barrier_low"; > ; - < "Lower barrier (set to 0 for no lower barrier)"; > ; - < "barrier_up"; > ; - < "Upper barrier (set to 0 for no upper barrier)"; > ; - < "foreign/domestic"; > ; - < "String to define if the option pays one unit of (d)omestic currency (cash or nothing) or (f)oreign currency (asset or nothing)"; > ; - < "knock in/out"; > ; - < "String to define if the option is of type knock-(i)n (touch) or knock-(o)ut (no-touch)"; > ; - < "barrier_type"; > ; - < "String to define whether the barrier is observed (c)ontinuously or only at the (e)nd/maturity"; > ; - < "greek"; > ; - < "Optional parameter, if left out then the function simply returns the option price; if set, the function returns price sensitivities (Greeks) to one of the input parameters; possible values are (d)elta, (g)amma, (t)heta, v(e)ga, v(o)lga, v(a)nna, (r)ho, rho(f)"; > ; - }; -}; - -StringArray PRICING_FUNCDESC_OptProbHit -{ - ItemList [ en-US ] = - { - < "Probability that an asset hits a barrier assuming it follows dS/S = mu dt + vol dW"; > ; - < "spot"; > ; - < "Price/value S of the underlying asset"; > ; - < "vol"; > ; - < "Annual volatility of the underlying asset"; > ; - < "drift"; > ; - < "Parameter mu in dS/S = mu dt + vol dW"; > ; - < "T"; > ; - < "Time to maturity"; > ; - < "barrier_low"; > ; - < "Lower barrier (set to 0 for no lower barrier)"; > ; - < "barrier_up"; > ; - < "Upper barrier (set to 0 for no upper barrier)"; > ; - }; -}; - -StringArray PRICING_FUNCDESC_OptProbInMoney -{ - ItemList [ en-US ] = - { - < "Probability that an asset will at maturity end up between two barrier levels, assuming it follows dS/S = mu dt + vol dW (if the last two optional parameters (strike, put/call) are specified, the probability of S_T in [strike, upper barrier] for a call and S_T in [lower barrier, strike] for a put will be returned)"; > ; - < "spot"; > ; - < "Price/value of the asset"; > ; - < "vol"; > ; - < "Annual volatility of the asset"; > ; - < "drift"; > ; - < "Parameter mu from dS/S = mu dt + vol dW"; > ; - < "T"; > ; - < "Time to maturity in years"; > ; - < "barrier_low"; > ; - < "Lower barrier (set to 0 for no lower barrier)"; > ; - < "barrier_up"; > ; - < "Upper barrier (set to 0 for no upper barrier)"; > ; - < "put/call"; > ; - < "Optional (p)ut/(c)all indicator"; > ; - < "strike"; > ; - < "Optional strike level"; > ; - }; -}; - -// function names as accessible from cells - -String PRICING_FUNCNAME_OptBarrier -{ - Text [ en-US ] = "OPT_BARRIER"; -}; - -String PRICING_FUNCNAME_OptTouch -{ - Text [ en-US ] = "OPT_TOUCH"; -}; - -String PRICING_FUNCNAME_OptProbHit -{ - Text [ en-US ] = "OPT_PROB_HIT"; -}; - -String PRICING_FUNCNAME_OptProbInMoney -{ - Text [ en-US ] = "OPT_PROB_INMONEY"; -}; - -/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |