1/**************************************************************
2 *
3 * Licensed to the Apache Software Foundation (ASF) under one
4 * or more contributor license agreements.  See the NOTICE file
5 * distributed with this work for additional information
6 * regarding copyright ownership.  The ASF licenses this file
7 * to you under the Apache License, Version 2.0 (the
8 * "License"); you may not use this file except in compliance
9 * with the License.  You may obtain a copy of the License at
10 *
11 *   http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied.  See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24#ifndef __com_sun_star_sheet_NoConvergenceException_idl__
25#include <com/sun/star/sheet/NoConvergenceException.idl>
26#endif
27
28#include <com/sun/star/uno/XInterface.idl>
29#include <com/sun/star/beans/XPropertySet.idl>
30#include <com/sun/star/sheet/LocalizedName.idl>
31
32module com
33{
34module sun
35{
36module star
37{
38module sheet
39{
40module addin
41{
42    interface XCompatibilityNames  : com::sun::star::uno::XInterface
43    {
44        /// getCompatibilityNames.
45        sequence< com::sun::star::sheet::LocalizedName > getCompatibilityNames ( [in] string aProgrammaticName );
46    };
47
48    /**
49    * Interface with analysis functions.
50    */
51    interface XAnalysis : com::sun::star::uno::XInterface
52    {
53        /// _test.
54//      double get_Test(
55//                  [in] com::sun::star::beans::XPropertySet xOptions,
56//                  [in] long Mode, [in] double f1, [in] double f2, [in] double f3 );
57
58        /// workday.
59        long getWorkday(
60                    [in] com::sun::star::beans::XPropertySet xOptions,
61                    [in] long nStartDate, [in] long nDays, [in] any aHolidays )
62            raises( com::sun::star::lang::IllegalArgumentException );
63
64        /// yearfrac.
65        double getYearfrac(
66                    [in] com::sun::star::beans::XPropertySet xOptions,
67                    [in] long StartDate, [in] long EndDate, [in] any Mode )
68            raises( com::sun::star::lang::IllegalArgumentException );
69
70        /// edate.
71        long getEdate(
72                    [in] com::sun::star::beans::XPropertySet xOptions,
73                    [in] long nStartDate, [in] long nNumOfMonths )
74            raises( com::sun::star::lang::IllegalArgumentException );
75
76        /// weeknum.
77        long getWeeknum(
78                    [in] com::sun::star::beans::XPropertySet xOptions,
79                    [in] long nStartDate, [in] long nMode )
80            raises( com::sun::star::lang::IllegalArgumentException );
81
82        /// eomonth.
83        long getEomonth(
84                    [in] com::sun::star::beans::XPropertySet xOptions,
85                    [in] long nStartDate, [in] long nMonths )
86            raises( com::sun::star::lang::IllegalArgumentException );
87
88        /// networkdays.
89        long getNetworkdays(
90                    [in] com::sun::star::beans::XPropertySet xOptions,
91                    [in] long StartDate, [in] long EndDate, [in] any Holidays )
92            raises( com::sun::star::lang::IllegalArgumentException );
93
94        /// iseven.
95        long getIseven( [in] long nValue )
96            raises( com::sun::star::lang::IllegalArgumentException );
97
98        /// isodd.
99        long getIsodd( [in] long nValue )
100            raises( com::sun::star::lang::IllegalArgumentException );
101
102        /// multinomial.
103		double getMultinomial(
104					[in] com::sun::star::beans::XPropertySet xOptions,
105					[in] sequence< sequence< long > > aValList,
106					[in] sequence< any > aOptVLst )
107            raises( com::sun::star::lang::IllegalArgumentException );
108
109        /// seriessum.
110        double getSeriessum(
111                    [in] double X, [in] double N, [in] double M,
112                    [in] sequence< sequence< double > > CoeffList )
113            raises( com::sun::star::lang::IllegalArgumentException );
114
115        // quotient.
116        double getQuotient( [in] double Num, [in] double Denum )
117            raises( com::sun::star::lang::IllegalArgumentException );
118
119        // mround.
120        double getMround( [in] double Number, [in] double Multiple )
121            raises( com::sun::star::lang::IllegalArgumentException );
122
123        // sqrtpi.
124        double getSqrtpi( [in] double Number )
125            raises( com::sun::star::lang::IllegalArgumentException );
126
127        // randbetween.
128        double getRandbetween( [in] double Min, [in] double Max )
129            raises( com::sun::star::lang::IllegalArgumentException );
130
131        /// gcd.
132        double getGcd(
133                    [in] com::sun::star::beans::XPropertySet xOptions,
134                    [in] sequence< sequence< double > > FirstValList,
135                    [in] sequence< any > OptionalValList )
136            raises( com::sun::star::lang::IllegalArgumentException );
137
138        /// lcm.
139        double getLcm(
140                    [in] com::sun::star::beans::XPropertySet xOptions,
141                    [in] sequence< sequence< double > > FirstValList,
142                    [in] sequence< any > OptionalValList )
143            raises( com::sun::star::lang::IllegalArgumentException );
144
145        /// besseli.
146        double getBesseli( [in] double Num, [in] long Order )
147            raises( com::sun::star::lang::IllegalArgumentException,
148                    com::sun::star::sheet::NoConvergenceException );
149
150        /// besselj.
151        double getBesselj( [in] double Num, [in] long Order )
152            raises( com::sun::star::lang::IllegalArgumentException,
153                    com::sun::star::sheet::NoConvergenceException );
154
155        /// besselk.
156        double getBesselk( [in] double Num, [in] long Order )
157            raises( com::sun::star::lang::IllegalArgumentException,
158                    com::sun::star::sheet::NoConvergenceException );
159
160        /// bessely.
161        double getBessely( [in] double Num, [in] long Order )
162            raises( com::sun::star::lang::IllegalArgumentException,
163                    com::sun::star::sheet::NoConvergenceException );
164
165        /// bin2oct.
166        string getBin2Oct(
167                    [in] com::sun::star::beans::XPropertySet xOptions,
168                    [in] string BinaryNum, [in] any Places )
169            raises( com::sun::star::lang::IllegalArgumentException );
170
171        /// bin2dec.
172        double getBin2Dec( [in] string BinaryNum )
173            raises( com::sun::star::lang::IllegalArgumentException );
174
175        /// bin2hex.
176        string getBin2Hex(
177                    [in] com::sun::star::beans::XPropertySet xOptions,
178                    [in] string BinaryNum, [in] any Places )
179            raises( com::sun::star::lang::IllegalArgumentException );
180
181        /// oct2bin.
182        string getOct2Bin(
183                    [in] com::sun::star::beans::XPropertySet xOptions,
184                    [in] string OctalNum, [in] any Places )
185            raises( com::sun::star::lang::IllegalArgumentException );
186
187        /// oct2dec.
188        double getOct2Dec( [in] string OctalNum )
189            raises( com::sun::star::lang::IllegalArgumentException );
190
191        /// oct2hex.
192        string getOct2Hex(
193                    [in] com::sun::star::beans::XPropertySet xOptions,
194                    [in] string OctalNum, [in] any Places )
195            raises( com::sun::star::lang::IllegalArgumentException );
196
197        /// dec2bin.
198        string getDec2Bin(
199                    [in] com::sun::star::beans::XPropertySet xOptions,
200                    [in] long Value, [in] any Places )
201            raises( com::sun::star::lang::IllegalArgumentException );
202
203        /// dec2oct.
204        string getDec2Oct(
205                    [in] com::sun::star::beans::XPropertySet xOptions,
206                    [in] long Value, [in] any Places )
207            raises( com::sun::star::lang::IllegalArgumentException );
208
209        /// dec2hex.
210        string getDec2Hex(
211                    [in] com::sun::star::beans::XPropertySet xOptions,
212                    [in] double Value, [in] any Places )
213            raises( com::sun::star::lang::IllegalArgumentException );
214
215        /// hex2bin.
216        string getHex2Bin(
217                    [in] com::sun::star::beans::XPropertySet xOptions,
218                    [in] string HexadecimalValue, [in] any Places )
219            raises( com::sun::star::lang::IllegalArgumentException );
220
221        /// hex2dec.
222        double getHex2Dec( [in] string HexadecimalValue )
223            raises( com::sun::star::lang::IllegalArgumentException );
224
225        /// hex2oct.
226        string getHex2Oct(
227                    [in] com::sun::star::beans::XPropertySet xOptions,
228                    [in] string HexadecimalValue, [in] any Places )
229            raises( com::sun::star::lang::IllegalArgumentException );
230
231        /// delta.
232        long getDelta(
233                    [in] com::sun::star::beans::XPropertySet xOptions,
234                    [in] double Num1, [in] any Num2 )
235            raises( com::sun::star::lang::IllegalArgumentException );
236
237        /// erf.
238        double getErf(
239                    [in] com::sun::star::beans::XPropertySet xOptions,
240                    [in] double LowerLimit, [in] any UpperLimit )
241            raises( com::sun::star::lang::IllegalArgumentException );
242
243        /// erfc.
244        double getErfc( [in] double LowerLimit )
245            raises( com::sun::star::lang::IllegalArgumentException );
246
247        /// gestep.
248        long getGestep(
249                    [in] com::sun::star::beans::XPropertySet xOptions,
250                    [in] double Num, [in] any Step )
251            raises( com::sun::star::lang::IllegalArgumentException );
252
253        /// factdouble.
254        double getFactdouble( [in] long Num )
255            raises( com::sun::star::lang::IllegalArgumentException );
256
257        /// imabs.
258        double getImabs( [in] string Num )
259            raises( com::sun::star::lang::IllegalArgumentException );
260
261        /// imaginary.
262        double getImaginary( [in] string Num )
263            raises( com::sun::star::lang::IllegalArgumentException );
264
265        /// impower.
266        string getImpower( [in] string Num, [in] double Power )
267            raises( com::sun::star::lang::IllegalArgumentException );
268
269        /// imargument.
270        double getImargument( [in] string Num )
271            raises( com::sun::star::lang::IllegalArgumentException );
272
273        /// imcos.
274        string getImcos( [in] string Num )
275            raises( com::sun::star::lang::IllegalArgumentException );
276
277        /// imdiv.
278        string getImdiv( [in] string Num1, [in] string Num2 )
279            raises( com::sun::star::lang::IllegalArgumentException );
280
281        /// imexp.
282        string getImexp( [in] string Num )
283            raises( com::sun::star::lang::IllegalArgumentException );
284
285        /// imconjugate.
286        string getImconjugate( [in] string Num )
287            raises( com::sun::star::lang::IllegalArgumentException );
288
289        /// imln.
290        string getImln( [in] string Num )
291            raises( com::sun::star::lang::IllegalArgumentException );
292
293        /// imlog10.
294        string getImlog10( [in] string Num )
295            raises( com::sun::star::lang::IllegalArgumentException );
296
297        /// imlog2.
298        string getImlog2( [in] string Num )
299            raises( com::sun::star::lang::IllegalArgumentException );
300
301        /// improduct.
302        string getImproduct(
303                    [in] com::sun::star::beans::XPropertySet xOptions,
304                    [in] sequence< sequence< string > > Num1,
305                    [in] sequence< any > NumberList )
306            raises( com::sun::star::lang::IllegalArgumentException );
307
308        /// imreal.
309        double getImreal( [in] string Num )
310            raises( com::sun::star::lang::IllegalArgumentException );
311
312        /// imsin.
313        string getImsin( [in] string Num )
314            raises( com::sun::star::lang::IllegalArgumentException );
315
316        /// imsub.
317        string getImsub( [in] string Num1, [in] string Num2 )
318            raises( com::sun::star::lang::IllegalArgumentException );
319
320        /// imsum.
321        string getImsum(
322                    [in] com::sun::star::beans::XPropertySet xOptions,
323                    [in] sequence< sequence< string > > Num1,
324                    [in] sequence< any > OptNums )
325            raises( com::sun::star::lang::IllegalArgumentException );
326
327        /// imsqrt.
328        string getImsqrt( [in] string Num )
329            raises( com::sun::star::lang::IllegalArgumentException );
330
331        /// complex.
332        string getComplex( [in] double Real, [in] double Imaginary, [in] any Suffix )
333            raises( com::sun::star::lang::IllegalArgumentException );
334
335        /// convert.
336        double getConvert( [in] double Value, [in] string FromUnit, [in] string ToUnit )
337            raises( com::sun::star::lang::IllegalArgumentException );
338
339
340        /// amordegrc.
341        double getAmordegrc(
342                    [in] com::sun::star::beans::XPropertySet xOptions,
343                    [in] double Cost, [in] long Date, [in] long FirstPer, [in] double RestVal,
344                    [in] double Periode, [in] double Rate, [in] any Base )
345            raises( com::sun::star::lang::IllegalArgumentException );
346
347        /// amorlinc.
348        double getAmorlinc(
349                    [in] com::sun::star::beans::XPropertySet xOptions,
350                    [in] double Cost, [in] long Date, [in] long FirstPer, [in] double RestVal,
351                    [in] double Periode, [in] double Rate, [in] any Base )
352            raises( com::sun::star::lang::IllegalArgumentException );
353
354        /// accrint.
355        double getAccrint(
356                    [in] com::sun::star::beans::XPropertySet xOptions,
357                    [in] long Issue, [in] long FirstInterest, [in] long Settlement, [in] double Rate,
358                    [in] any Value, [in] long Frequency, [in] any Base )
359            raises( com::sun::star::lang::IllegalArgumentException );
360
361        /// accrintm.
362        double getAccrintm(
363                    [in] com::sun::star::beans::XPropertySet xOptions,
364                    [in] long Issue, [in] long Settlement, [in] double Rate, [in] any Value, [in] any Base )
365            raises( com::sun::star::lang::IllegalArgumentException );
366
367        /// received.
368        double getReceived(
369                    [in] com::sun::star::beans::XPropertySet xOptions,
370                    [in] long Settlement, [in] long Maturity, [in] double Investment, [in] double Discount,
371                    [in] any Base )
372            raises( com::sun::star::lang::IllegalArgumentException );
373
374        /// disc.
375        double getDisc(
376                    [in] com::sun::star::beans::XPropertySet xOptions,
377                    [in] long Settlement, [in] long Maturity, [in] double Price, [in] double Redemption,
378                    [in] any Base )
379            raises( com::sun::star::lang::IllegalArgumentException );
380
381        /// duration.
382        double getDuration(
383                    [in] com::sun::star::beans::XPropertySet xOptions,
384                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Yield,
385                    [in] long Frequncy, [in] any Base )
386            raises( com::sun::star::lang::IllegalArgumentException );
387
388        /// effect.
389        double getEffect( [in] double Nomial, [in] long NumOfPeriods )
390            raises( com::sun::star::lang::IllegalArgumentException );
391
392        /// cumprinc.
393        double getCumprinc(
394                    [in] double Rate, [in] long NumOfPeriods, [in] double Val, [in] long StartPeriode,
395                    [in] long EndPeriode, [in] long PayType )
396            raises( com::sun::star::lang::IllegalArgumentException );
397
398        /// cumipmt.
399        double getCumipmt(
400                    [in] double Rate, [in] long NumOfPeriods, [in] double Val, [in] long StartPeriode,
401                    [in] long EndPeriode, [in] long PayType )
402            raises( com::sun::star::lang::IllegalArgumentException );
403
404        /// price.
405        double getPrice(
406                    [in] com::sun::star::beans::XPropertySet xOptions,
407                    [in] long Settlement, [in] long Maturity, [in] double Rate, [in] double Yield,
408                    [in] double Redemption, [in] long Frequncy, [in] any Base )
409            raises( com::sun::star::lang::IllegalArgumentException );
410
411        /// pricedisc.
412        double getPricedisc(
413                    [in] com::sun::star::beans::XPropertySet xOptions,
414                    [in] long Settlement, [in] long Maturity, [in] double Discont, [in] double Redemption,
415                    [in] any Base )
416            raises( com::sun::star::lang::IllegalArgumentException );
417
418        /// pricemat.
419        double getPricemat(
420                    [in] com::sun::star::beans::XPropertySet xOptions,
421                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] double Rate, [in] double Yield,
422                    [in] any Base )
423            raises( com::sun::star::lang::IllegalArgumentException );
424
425        /// mduration.
426        double getMduration(
427                    [in] com::sun::star::beans::XPropertySet xOptions,
428                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Yield,
429                    [in] long Frequency, [in] any Base )
430            raises( com::sun::star::lang::IllegalArgumentException );
431
432        /// nominal.
433        double getNominal( [in] double Rate, [in] long NumOfPeriods )
434            raises( com::sun::star::lang::IllegalArgumentException );
435
436        /// dollarfr.
437        double getDollarfr( [in] double DollarDecimal, [in] long Fraction )
438            raises( com::sun::star::lang::IllegalArgumentException );
439
440        /// dollarde.
441        double getDollarde( [in] double DollarFractional, [in] long Fraction )
442            raises( com::sun::star::lang::IllegalArgumentException );
443
444        /// yield.
445        double getYield(
446                    [in] com::sun::star::beans::XPropertySet xOptions,
447                    [in] long Settlement, [in] long Maturity, [in] double Coupon, [in] double Price,
448                    [in] double Redemption, [in] long Frequency, [in] any Base )
449            raises( com::sun::star::lang::IllegalArgumentException );
450
451        /// yielddisc.
452        double getYielddisc(
453                    [in] com::sun::star::beans::XPropertySet xOptions,
454                    [in] long Settlement, [in] long Maturity, [in] double Price,
455                    [in] double Redemption, [in] any Base )
456            raises( com::sun::star::lang::IllegalArgumentException );
457
458        /// yieldmat.
459        double getYieldmat(
460                    [in] com::sun::star::beans::XPropertySet xOptions,
461                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] double Rate,
462                    [in] double Price, [in] any Base )
463            raises( com::sun::star::lang::IllegalArgumentException );
464
465        /// tbilleq.
466        double getTbilleq(
467                    [in] com::sun::star::beans::XPropertySet xOptions,
468                    [in] long Settlement, [in] long Maturity, [in] double Discont )
469            raises( com::sun::star::lang::IllegalArgumentException );
470
471        /// tbillprice.
472        double getTbillprice(
473                    [in] com::sun::star::beans::XPropertySet xOptions,
474                    [in] long Settlement, [in] long Maturity, [in] double Discont )
475            raises( com::sun::star::lang::IllegalArgumentException );
476
477        /// tbillyield.
478        double getTbillyield(
479                    [in] com::sun::star::beans::XPropertySet xOptions,
480                    [in] long Settlement, [in] long Maturity, [in] double Price )
481            raises( com::sun::star::lang::IllegalArgumentException );
482
483        /// oddfprice.
484        double getOddfprice(
485                    [in] com::sun::star::beans::XPropertySet xOptions,
486                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] long FirstCouponDate,
487                    [in] double Rate, [in] double Yield, [in] double Redemption,
488                    [in] long Frequency, [in] any Base )
489            raises( com::sun::star::lang::IllegalArgumentException );
490
491        /// oddfyield.
492        double getOddfyield(
493                    [in] com::sun::star::beans::XPropertySet xOptions,
494                    [in] long Settlement, [in] long Maturity, [in] long Issue, [in] long FirstCouponDate,
495                    [in] double Rate, [in] double Price, [in] double Redemption,
496                    [in] long Frequency, [in] any Base )
497            raises( com::sun::star::lang::IllegalArgumentException );
498
499        /// oddlprice.
500        double getOddlprice(
501                    [in] com::sun::star::beans::XPropertySet xOptions,
502                    [in] long Settlement, [in] long Maturity, [in] long LastInterest,
503                    [in] double Rate, [in] double Yield, [in] double Redemption,
504                    [in] long Frequency, [in] any Base )
505            raises( com::sun::star::lang::IllegalArgumentException );
506
507        /// oddlyield.
508        double getOddlyield(
509                    [in] com::sun::star::beans::XPropertySet xOptions,
510                    [in] long Settlement, [in] long Maturity, [in] long LastInterest,
511                    [in] double Rate, [in] double Price, [in] double Redemption,
512                    [in] long Frequency, [in] any Base )
513            raises( com::sun::star::lang::IllegalArgumentException );
514
515        /// xirr.
516        double getXirr(
517                    [in] com::sun::star::beans::XPropertySet xOptions,
518                    [in] sequence< sequence< double > > Values,
519                    [in] sequence< sequence< long > > Dates, [in] any Guess )
520            raises( com::sun::star::lang::IllegalArgumentException );
521
522        /// xnpv.
523        double getXnpv(
524                    [in] double Rate,
525                    [in] sequence< sequence< double > > Values,
526                    [in] sequence< sequence< long > > Dates )
527            raises( com::sun::star::lang::IllegalArgumentException );
528
529        /// intrate.
530        double getIntrate(
531                    [in] com::sun::star::beans::XPropertySet xOptions,
532                    [in] long Settlement, [in] long Maturity,
533                    [in] double Investment, [in] double Redemption, [in] any Base )
534            raises( com::sun::star::lang::IllegalArgumentException );
535
536        /// coupncd.
537        double getCoupncd(
538                    [in] com::sun::star::beans::XPropertySet xOptions,
539                    [in] long Settlement, [in] long Maturity,
540                    [in] long Frequency, [in] any Base )
541            raises( com::sun::star::lang::IllegalArgumentException );
542
543        /// coupdays.
544        double getCoupdays(
545                    [in] com::sun::star::beans::XPropertySet xOptions,
546                    [in] long Settlement, [in] long Maturity,
547                    [in] long Frequency, [in] any Base )
548            raises( com::sun::star::lang::IllegalArgumentException );
549
550
551        /// coupdaysnc.
552        double getCoupdaysnc(
553                    [in] com::sun::star::beans::XPropertySet xOptions,
554                    [in] long Settlement, [in] long Maturity,
555                    [in] long Frequency, [in] any Base )
556            raises( com::sun::star::lang::IllegalArgumentException );
557
558        /// coupdaybs.
559        double getCoupdaybs(
560                    [in] com::sun::star::beans::XPropertySet xOptions,
561                    [in] long Settlement, [in] long Maturity,
562                    [in] long Frequency, [in] any Base )
563            raises( com::sun::star::lang::IllegalArgumentException );
564
565        /// couppcd.
566        double getCouppcd(
567                    [in] com::sun::star::beans::XPropertySet xOptions,
568                    [in] long Settlement, [in] long Maturity,
569                    [in] long Frequency, [in] any Base )
570            raises( com::sun::star::lang::IllegalArgumentException );
571
572        /// coupnum.
573        double getCoupnum(
574                    [in] com::sun::star::beans::XPropertySet xOptions,
575                    [in] long Settlement, [in] long Maturity,
576                    [in] long Frequency, [in] any Base )
577            raises( com::sun::star::lang::IllegalArgumentException );
578
579        /// fvschedule.
580        double getFvschedule( [in] double Principal, [in] sequence< sequence< double > > Schedule )
581            raises( com::sun::star::lang::IllegalArgumentException );
582    };
583
584    service Analysis
585    {
586        // exported interfaces:
587        interface XCompatibilityNames;
588        interface XAnalysis;
589    };
590};
591};
592};
593};
594};
595
596