summaryrefslogtreecommitdiffstats
path: root/scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl
diff options
context:
space:
mode:
Diffstat (limited to 'scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl')
-rw-r--r--scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl600
1 files changed, 600 insertions, 0 deletions
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: */