Adding upstream version 4:24.2.0.upstream/4%24.2.0

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

8 files changed, 969 insertions, 0 deletions

diff --git a/scaddins/idl/com/sun/star/sheet/addin/Analysis.idl b/scaddins/idl/com/sun/star/sheet/addin/Analysis.idl
new file mode 100644
index 0000000000..dbcaf85357
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/Analysis.idl
@@ -0,0 +1,42 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    service Analysis
+    {
+        // exported interfaces:
+        interface XCompatibilityNames;
+        interface XAnalysis;
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/DateFunctions.idl b/scaddins/idl/com/sun/star/sheet/addin/DateFunctions.idl
new file mode 100644
index 0000000000..4cec89753d
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/DateFunctions.idl
@@ -0,0 +1,42 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    service DateFunctions
+    {
+        // exported interfaces:
+        interface XDateFunctions;
+        interface XMiscFunctions;
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/PricingFunctions.idl b/scaddins/idl/com/sun/star/sheet/addin/PricingFunctions.idl
new file mode 100644
index 0000000000..eb955ea16d
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/PricingFunctions.idl
@@ -0,0 +1,42 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    service PricingFunctions
+    {
+        // exported interfaces:
+        interface XPricingFunctions;
+
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl b/scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl
new file mode 100644
index 0000000000..e05c66dbf5
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl
@@ -0,0 +1,600 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    /**
+    * Interface with analysis functions.
+    */
+    interface XAnalysis : com::sun::star::uno::XInterface
+    {
+        /// workday.
+        long getWorkday(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nDays, [in] any aHolidays )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// yearfrac.
+        double getYearfrac(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long StartDate, [in] long EndDate, [in] any Mode )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// edate.
+        long getEdate(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nNumOfMonths )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// weeknum.
+        long getWeeknum(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nMode )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// eomonth.
+        long getEomonth(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nMonths )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// networkdays.
+        long getNetworkdays(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long StartDate, [in] long EndDate, [in] any Holidays )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// iseven.
+        long getIseven( [in] long nValue )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// isodd.
+        long getIsodd( [in] long nValue )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// multinomial.
+        double getMultinomial(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< long > > aValList,
+                    [in] sequence< any > aOptVLst )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// seriessum.
+        double getSeriessum(
+                    [in] double X, [in] double N, [in] double M,
+                    [in] sequence< sequence< double > > CoeffList )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        // quotient.
+        double getQuotient( [in] double Num, [in] double Denum )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        // mround.
+        double getMround( [in] double Number, [in] double Multiple )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        // sqrtpi.
+        double getSqrtpi( [in] double Number )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        // randbetween.
+        // Min is the smallest value randbetween will return
+        // Max is the largest value randbetween will return
+        double getRandbetween( [in] double Min, [in] double Max )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// gcd.
+        double getGcd(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< double > > FirstValList,
+                    [in] sequence< any > OptionalValList )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// lcm.
+        double getLcm(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< double > > FirstValList,
+                    [in] sequence< any > OptionalValList )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// besseli.
+        double getBesseli( [in] double Num, [in] long Order )
+            raises( com::sun::star::lang::IllegalArgumentException,
+                    com::sun::star::sheet::NoConvergenceException );
+
+        /// besselj.
+        double getBesselj( [in] double Num, [in] long Order )
+            raises( com::sun::star::lang::IllegalArgumentException,
+                    com::sun::star::sheet::NoConvergenceException );
+
+        /// besselk.
+        double getBesselk( [in] double Num, [in] long Order )
+            raises( com::sun::star::lang::IllegalArgumentException,
+                    com::sun::star::sheet::NoConvergenceException );
+
+        /// bessely.
+        double getBessely( [in] double Num, [in] long Order )
+            raises( com::sun::star::lang::IllegalArgumentException,
+                    com::sun::star::sheet::NoConvergenceException );
+
+        /// bin2oct.
+        string getBin2Oct(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string BinaryNum, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// bin2dec.
+        double getBin2Dec( [in] string BinaryNum )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// bin2hex.
+        string getBin2Hex(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string BinaryNum, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oct2bin.
+        string getOct2Bin(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string OctalNum, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oct2dec.
+        double getOct2Dec( [in] string OctalNum )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oct2hex.
+        string getOct2Hex(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string OctalNum, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// dec2bin.
+        string getDec2Bin(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Value, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// dec2oct.
+        string getDec2Oct(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Value, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// dec2hex.
+        string getDec2Hex(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double Value, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// hex2bin.
+        string getHex2Bin(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string HexadecimalValue, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// hex2dec.
+        double getHex2Dec( [in] string HexadecimalValue )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// hex2oct.
+        string getHex2Oct(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] string HexadecimalValue, [in] any Places )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// delta.
+        long getDelta(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double Num1, [in] any Num2 )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// erf.
+        double getErf(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double LowerLimit, [in] any UpperLimit )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// erfc.
+        double getErfc( [in] double LowerLimit )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// gestep.
+        long getGestep(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double Num, [in] any Step )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// factdouble.
+        double getFactdouble( [in] long Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imabs.
+        double getImabs( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imaginary.
+        double getImaginary( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// impower.
+        string getImpower( [in] string Num, [in] double Power )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imargument.
+        double getImargument( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imcos.
+        string getImcos( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imdiv.
+        string getImdiv( [in] string Num1, [in] string Num2 )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imexp.
+        string getImexp( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imconjugate.
+        string getImconjugate( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imln.
+        string getImln( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imlog10.
+        string getImlog10( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imlog2.
+        string getImlog2( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// improduct.
+        string getImproduct(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< string > > Num1,
+                    [in] sequence< any > NumberList )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imreal.
+        double getImreal( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsin.
+        string getImsin( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsub.
+        string getImsub( [in] string Num1, [in] string Num2 )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsum.
+        string getImsum(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< string > > Num1,
+                    [in] sequence< any > OptNums )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsqrt.
+        string getImsqrt( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imtan.
+        string getImtan( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsec.
+        string getImsec( [in] string Num)
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imcsc.
+        string getImcsc( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imcot.
+        string getImcot( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsinh.
+        string getImsinh( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imcosh.
+        string getImcosh( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imsech.
+        string getImsech( [in] string Num)
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// imcsch.
+        string getImcsch( [in] string Num )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// complex.
+        string getComplex( [in] double Real, [in] double Imaginary, [in] any Suffix )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// convert.
+        double getConvert( [in] double Value, [in] string FromUnit, [in] string ToUnit )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+
+        /// amordegrc.
+        double getAmordegrc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double Cost, [in] long Date, [in] long FirstPer, [in] double RestVal,
+                    [in] double Periode, [in] double Rate, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// amorlinc.
+        double getAmorlinc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] double Cost, [in] long Date, [in] long FirstPer, [in] double RestVal,
+                    [in] double Periode, [in] double Rate, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// accrint.
+        double getAccrint(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Issue, [in] long FirstInterest, [in] long Settlement, [in] double Rate,
+                    [in] any Value, [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// accrintm.
+        double getAccrintm(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Issue, [in] long Settlement, [in] double Rate, [in] any Value, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// received.
+        double getReceived(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Investment, [in] double Discount,
+                    [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// disc.
+        double getDisc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Price, [in] double Redemption,
+                    [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// duration.
+        double getDuration(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Yield,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// effect.
+        double getEffect( [in] double Nomial, [in] long NumOfPeriods )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// cumprinc.
+        double getCumprinc(
+                    [in] double Rate, [in] long NumOfPeriods, [in] double Val, [in] long StartPeriode,
+                    [in] long EndPeriode, [in] long PayType )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// cumipmt.
+        double getCumipmt(
+                    [in] double Rate, [in] long NumOfPeriods, [in] double Val, [in] long StartPeriode,
+                    [in] long EndPeriode, [in] long PayType )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// price.
+        double getPrice(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Rate, [in] double Yield,
+                    [in] double Redemption, [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// pricedisc.
+        double getPricedisc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Discont, [in] double Redemption,
+                    [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// pricemat.
+        double getPricemat(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] double Rate, [in] double Yield,
+                    [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// mduration.
+        double getMduration(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Yield,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// nominal.
+        double getNominal( [in] double Rate, [in] long NumOfPeriods )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// dollarfr.
+        double getDollarfr( [in] double DollarDecimal, [in] long Fraction )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// dollarde.
+        double getDollarde( [in] double DollarFractional, [in] long Fraction )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// yield.
+        double getYield(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Price,
+                    [in] double Redemption, [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// yielddisc.
+        double getYielddisc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Price,
+                    [in] double Redemption, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// yieldmat.
+        double getYieldmat(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] double Rate,
+                    [in] double Price, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// tbilleq.
+        double getTbilleq(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Discont )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// tbillprice.
+        double getTbillprice(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Discont )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// tbillyield.
+        double getTbillyield(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] double Price )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oddfprice.
+        double getOddfprice(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] long FirstCouponDate,
+                    [in] double Rate, [in] double Yield, [in] double Redemption,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oddfyield.
+        double getOddfyield(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] long FirstCouponDate,
+                    [in] double Rate, [in] double Price, [in] double Redemption,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oddlprice.
+        double getOddlprice(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long LastInterest,
+                    [in] double Rate, [in] double Yield, [in] double Redemption,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// oddlyield.
+        double getOddlyield(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity, [in] long LastInterest,
+                    [in] double Rate, [in] double Price, [in] double Redemption,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// xirr.
+        double getXirr(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] sequence< sequence< double > > Values,
+                    [in] sequence< sequence< long > > Dates, [in] any Guess )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// xnpv.
+        double getXnpv(
+                    [in] double Rate,
+                    [in] sequence< sequence< double > > Values,
+                    [in] sequence< sequence< long > > Dates )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// intrate.
+        double getIntrate(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] double Investment, [in] double Redemption, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// coupncd.
+        double getCoupncd(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// coupdays.
+        double getCoupdays(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+
+        /// coupdaysnc.
+        double getCoupdaysnc(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// coupdaybs.
+        double getCoupdaybs(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// couppcd.
+        double getCouppcd(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// coupnum.
+        double getCoupnum(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long Settlement, [in] long Maturity,
+                    [in] long Frequency, [in] any Base )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// fvschedule.
+        double getFvschedule( [in] double Principal, [in] sequence< sequence< double > > Schedule )
+            raises( com::sun::star::lang::IllegalArgumentException );
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/XCompatibilityNames.idl b/scaddins/idl/com/sun/star/sheet/addin/XCompatibilityNames.idl
new file mode 100644
index 0000000000..0da24ad2fb
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/XCompatibilityNames.idl
@@ -0,0 +1,41 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    interface XCompatibilityNames  : com::sun::star::uno::XInterface
+    {
+        /// @return a sequence with all localized names for a programmatic name
+        sequence< com::sun::star::sheet::LocalizedName > getCompatibilityNames ( [in] string aProgrammaticName );
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/XDateFunctions.idl b/scaddins/idl/com/sun/star/sheet/addin/XDateFunctions.idl
new file mode 100644
index 0000000000..1c4e6ee4fe
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/XDateFunctions.idl
@@ -0,0 +1,83 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    /**
+     * Interface with date functions.
+     */
+    interface XDateFunctions : com::sun::star::uno::XInterface
+    {
+        /// calculates the number of weeks between two dates.
+        long getDiffWeeks(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nEndDate, [in] long nMode )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// calculates the number of months between two dates.
+        long getDiffMonths(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nEndDate, [in] long nMode )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// calculates the number of years between two dates.
+        long getDiffYears(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nStartDate, [in] long nEndDate, [in] long nMode )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// checks if a date is in a leap year.
+        long getIsLeapYear(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nDate )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// calculates the number of days in a month.
+        long getDaysInMonth(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nDate )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// calculates the number of days in a year.
+        long getDaysInYear(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nDate )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// calculates the number of weeks in a year.
+        long getWeeksInYear(
+                    [in] com::sun::star::beans::XPropertySet xOptions,
+                    [in] long nDate )
+            raises( com::sun::star::lang::IllegalArgumentException );
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/XMiscFunctions.idl b/scaddins/idl/com/sun/star/sheet/addin/XMiscFunctions.idl
new file mode 100644
index 0000000000..bad5a210a7
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/XMiscFunctions.idl
@@ -0,0 +1,45 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    /**
+     * Interface with miscellaneous functions.
+     */
+    interface XMiscFunctions : com::sun::star::uno::XInterface
+    {
+        /// Encrypts or decrypts a string using the ROT13 algorithm.
+        string getRot13( [in] string aSrcString )
+            raises( com::sun::star::lang::IllegalArgumentException );
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
diff --git a/scaddins/idl/com/sun/star/sheet/addin/XPricingFunctions.idl b/scaddins/idl/com/sun/star/sheet/addin/XPricingFunctions.idl
new file mode 100644
index 0000000000..1eac78a660
--- /dev/null
+++ b/scaddins/idl/com/sun/star/sheet/addin/XPricingFunctions.idl
@@ -0,0 +1,74 @@
+/* -*- 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 .
+ */
+
+module com
+{
+module sun
+{
+module star
+{
+module sheet
+{
+module addin
+{
+    /**
+     * Interface with pricing functions.
+     */
+    interface XPricingFunctions : com::sun::star::uno::XInterface
+    {
+        /// OPT_BARRIER(), pricing of a barrier option.
+        double getOptBarrier( [in] double spot, [in] double vol,
+            [in] double rate, [in] double rateForeign,
+            [in] double maturity, [in] double strike,
+            [in] double barrierLow, [in] double barrierUp,
+            [in] double rebate,
+            [in] string putCall, [in] string inOut,
+            [in] string continuous, [in] any greek  )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// OPT_TOUCH(), pricing of a touch/no-touch option.
+        double getOptTouch( [in] double spot, [in] double vol,
+            [in] double rate, [in] double rateForeign,
+            [in] double maturity,
+            [in] double barrierLow, [in] double barrierUp,
+            [in] string foreignDomestic, [in] string inOut,
+            [in] string continuous, [in] any greek  )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// OPT_PROB_HIT(), probability of hitting a barrier.
+        double getOptProbHit( [in] double spot, [in] double vol,
+            [in] double mu, [in] double maturity,
+            [in] double barrierLow, [in] double barrierUp )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+        /// OPT_PROB_INMONEY(), probability of ending up in-the-money.
+        double getOptProbInMoney( [in] double spot, [in] double vol,
+            [in] double mu, [in] double maturity,
+            [in] double barrierLow, [in] double barrierUp,
+            [in] any strike, [in] any putCall )
+            raises( com::sun::star::lang::IllegalArgumentException );
+
+    };
+};
+};
+};
+};
+};
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */