diff options
Diffstat (limited to 'scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl')
| -rw-r--r-- | scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl | 609 |
1 files changed, 609 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 000000000..24142964e --- /dev/null +++ b/scaddins/idl/com/sun/star/sheet/addin/XAnalysis.idl @@ -0,0 +1,609 @@ +/* -*- 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 com_sun_star_sheet_addin_XAnalysis_idl +#define com_sun_star_sheet_addin_XAnalysis_idl + +#include <com/sun/star/uno/XInterface.idl> +#include <com/sun/star/beans/XPropertySet.idl> +#include <com/sun/star/sheet/NoConvergenceException.idl> + +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 ); + }; +}; +}; +}; +}; +}; + +#endif + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |