LibreOffice Module scaddins (master) 1
Classes | Typedefs | Enumerations | Functions
sca::analysis Namespace Reference

Classes

class  Complex
 
class  ComplexList
 
class  ConvertData
 
class  ConvertDataLinear
 
class  ConvertDataList
 
struct  FindFuncData
 
class  FuncData
 
struct  FuncDataBase
 
class  ScaAnyConverter
 Helper class for Any->double conversion, using current language settings. More...
 
class  ScaDate
 Helper class for date calculation for various financial functions. More...
 
class  ScaDoubleList
 
class  ScaDoubleListGE0
 stores double values >=0.0, throws exception for double values <0.0 More...
 
class  ScaDoubleListGT0
 stores double values >0.0, throws exception for double values <0.0, does nothing for 0.0 More...
 
class  SortedIndividualInt32List
 sorted list with unique sal_Int32 values More...
 

Typedefs

typedef std::vector< FuncDataFuncDataList
 

Enumerations

enum class  FDCategory {
  DateTime ,
  Finance ,
  Inf ,
  Math ,
  Tech
}
 
enum  ConvertDataClass {
  CDC_Mass ,
  CDC_Length ,
  CDC_Time ,
  CDC_Pressure ,
  CDC_Force ,
  CDC_Energy ,
  CDC_Power ,
  CDC_Magnetism ,
  CDC_Temperature ,
  CDC_Volume ,
  CDC_Area ,
  CDC_Speed ,
  CDC_Information
}
 

Functions

sal_uInt16 DaysInMonth (sal_uInt16 nMonth, sal_uInt16 nYear)
 
sal_Int32 DateToDays (sal_uInt16 nDay, sal_uInt16 nMonth, sal_uInt16 nYear)
 Convert a date to a count of days starting from 01/01/0001. More...
 
void DaysToDate (sal_Int32 nDays, sal_uInt16 &rDay, sal_uInt16 &rMonth, sal_uInt16 &rYear)
 Convert a count of days starting from 01/01/0001 to a date. More...
 
sal_Int32 GetNullDate (const uno::Reference< beans::XPropertySet > &xOpt)
 Get the null date used by the spreadsheet document. More...
 
sal_Int32 GetDiffDate360 (sal_uInt16 nDay1, sal_uInt16 nMonth1, sal_uInt16 nYear1, bool bLeapYear1, sal_uInt16 nDay2, sal_uInt16 nMonth2, sal_uInt16 nYear2, bool bUSAMethod)
 
sal_Int32 GetDiffDate360 (sal_Int32 nNullDate, sal_Int32 nDate1, sal_Int32 nDate2, bool bUSAMethod)
 
sal_Int32 GetDaysInYears (sal_uInt16 nYear1, sal_uInt16 nYear2)
 
sal_Int32 GetDiffDate (sal_Int32 nNullDate, sal_Int32 nStartDate, sal_Int32 nEndDate, sal_Int32 nMode, sal_Int32 *pOptDaysIn1stYear)
 
double GetYearDiff (sal_Int32 nNullDate, sal_Int32 nStartDate, sal_Int32 nEndDate, sal_Int32 nMode)
 
sal_Int32 GetDaysInYear (sal_Int32 nNullDate, sal_Int32 nDate, sal_Int32 nMode)
 
double GetYearFrac (sal_Int32 nNullDate, sal_Int32 nStartDate, sal_Int32 nEndDate, sal_Int32 nMode)
 Function GetYearFrac implements YEARFRAC as defined in: Open Document Format for Office Applications version 1.2 Part 2, par. More...
 
double BinomialCoefficient (double n, double k)
 
double GetGcd (double f1, double f2)
 
double ConvertToDec (const OUString &aStr, sal_uInt16 nBase, sal_uInt16 nCharLim)
 
static char GetMaxChar (sal_uInt16 nBase)
 
OUString ConvertFromDec (double fNum, double fMin, double fMax, sal_uInt16 nBase, sal_Int32 nPlaces, sal_Int32 nMaxPlaces, bool bUsePlaces)
 
double Erf (double x)
 
double Erfc (double x)
 
static bool IsNum (sal_Unicode c)
 
static bool IsComma (sal_Unicode c)
 
static bool IsExpStart (sal_Unicode c)
 
static bool IsImagUnit (sal_Unicode c)
 
static sal_uInt16 GetVal (sal_Unicode c)
 
bool ParseDouble (const sal_Unicode *&rp, double &rRet)
 
OUString GetString (double f, bool bLeadingSign, sal_uInt16 nMaxDig)
 
double GetAmordegrc (sal_Int32 nNullDate, double fCost, sal_Int32 nDate, sal_Int32 nFirstPer, double fRestVal, double fPer, double fRate, sal_Int32 nBase)
 
double GetAmorlinc (sal_Int32 nNullDate, double fCost, sal_Int32 nDate, sal_Int32 nFirstPer, double fRestVal, double fPer, double fRate, sal_Int32 nBase)
 
double GetDuration (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, double fCoup, double fYield, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetYieldmat (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nIssue, double fRate, double fPrice, sal_Int32 nBase)
 
double GetOddfprice (sal_Int32, sal_Int32, sal_Int32, sal_Int32, sal_Int32, double, double, double, sal_Int32, sal_Int32)
 
double getYield_ (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, double fCoup, double fPrice, double fRedemp, sal_Int32 nFreq, sal_Int32 nBase)
 
double getPrice_ (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, double fRate, double fYield, double fRedemp, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetOddfyield (sal_Int32, sal_Int32, sal_Int32, sal_Int32, sal_Int32, double, double, double, sal_Int32, sal_Int32)
 
double GetOddlprice (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nLastCoup, double fRate, double fYield, double fRedemp, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetOddlyield (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nLastCoup, double fRate, double fPrice, double fRedemp, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetPmt (double fRate, double fNper, double fPv, double fFv, sal_Int32 nPayType)
 
double GetFv (double fRate, double fNper, double fPmt, double fPv, sal_Int32 nPayType)
 
static void lcl_GetCouppcd (ScaDate &rDate, const ScaDate &rSettle, const ScaDate &rMat, sal_Int32 nFreq)
 
double GetCouppcd (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
static void lcl_GetCoupncd (ScaDate &rDate, const ScaDate &rSettle, const ScaDate &rMat, sal_Int32 nFreq)
 
double GetCoupncd (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetCoupdaybs (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetCoupdaysnc (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetCoupdays (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
double GetCoupnum (sal_Int32 nNullDate, sal_Int32 nSettle, sal_Int32 nMat, sal_Int32 nFreq, sal_Int32 nBase)
 
void InitFuncDataList (FuncDataList &rList)
 
bool IsLeapYear (sal_uInt16 nYear)
 
sal_Int32 GetNullDate (const css::uno::Reference< css::beans::XPropertySet > &xOptions)
 
sal_Int32 GetDiffDate360 (const css::uno::Reference< css::beans::XPropertySet > &xOpt, sal_Int32 nDate1, sal_Int32 nDate2, bool bUSAMethod)
 
sal_Int16 GetDayOfWeek (sal_Int32 nDate)
 
double GetYearFrac (const css::uno::Reference< css::beans::XPropertySet > &xOpt, sal_Int32 nStartDate, sal_Int32 nEndDate, sal_Int32 nMode)
 
double BesselJ (double x, sal_Int32 n)
 Returns the result for the unmodified BESSEL function of first kind (J), n-th order, at point x. More...
 
double BesselI (double x, sal_Int32 n)
 Returns the result for the modified BESSEL function of first kind (I), n-th order, at point x. More...
 
static double Besselk0 (double fNum)
 
static double Besselk1 (double fNum)
 
double BesselK (double x, sal_Int32 n)
 Returns the result for the modified BESSEL function of second kind (K), n-th order, at point x. More...
 
static double Bessely0 (double fX)
 
static double Bessely1 (double fX)
 
double BesselY (double x, sal_Int32 n)
 Returns the result for the unmodified BESSEL function of second kind (Y), n-th order, at point x. More...
 

Typedef Documentation

◆ FuncDataList

typedef std::vector< FuncData > sca::analysis::FuncDataList

Definition at line 230 of file analysishelper.hxx.

Enumeration Type Documentation

◆ ConvertDataClass

Enumerator
CDC_Mass 
CDC_Length 
CDC_Time 
CDC_Pressure 
CDC_Force 
CDC_Energy 
CDC_Power 
CDC_Magnetism 
CDC_Temperature 
CDC_Volume 
CDC_Area 
CDC_Speed 
CDC_Information 

Definition at line 488 of file analysishelper.hxx.

◆ FDCategory

enum class sca::analysis::FDCategory
strong
Enumerator
DateTime 
Finance 
Inf 
Math 
Tech 

Definition at line 175 of file analysishelper.hxx.

Function Documentation

◆ BesselI()

double sca::analysis::BesselI ( double  x,
sal_Int32  n 
)

Returns the result for the modified BESSEL function of first kind (I), n-th order, at point x.

Exceptions
css::lang::IllegalArgumentException
css::sheet::NoConvergenceException

Definition at line 164 of file bessel.cxx.

References n, and x.

Referenced by Besselk0(), Besselk1(), and AnalysisAddIn::getBesseli().

◆ BesselJ()

double sca::analysis::BesselJ ( double  x,
sal_Int32  n 
)

Returns the result for the unmodified BESSEL function of first kind (J), n-th order, at point x.

Exceptions
css::lang::IllegalArgumentException
css::sheet::NoConvergenceException

Definition at line 53 of file bessel.cxx.

References N, u, and x.

Referenced by AnalysisAddIn::getBesselj().

◆ BesselK()

double sca::analysis::BesselK ( double  x,
sal_Int32  n 
)

Returns the result for the modified BESSEL function of second kind (K), n-th order, at point x.

Exceptions
css::lang::IllegalArgumentException
css::sheet::NoConvergenceException

Definition at line 275 of file bessel.cxx.

References Besselk0(), Besselk1(), and n.

Referenced by AnalysisAddIn::getBesselk().

◆ Besselk0()

static double sca::analysis::Besselk0 ( double  fNum)
static
Exceptions
IllegalArgumentException
NoConvergenceException

Definition at line 221 of file bessel.cxx.

References BesselI(), log, and y.

Referenced by BesselK().

◆ Besselk1()

static double sca::analysis::Besselk1 ( double  fNum)
static
Exceptions
IllegalArgumentException
NoConvergenceException

Definition at line 248 of file bessel.cxx.

References BesselI(), log, and y.

Referenced by BesselK().

◆ BesselY()

double sca::analysis::BesselY ( double  x,
sal_Int32  n 
)

Returns the result for the unmodified BESSEL function of second kind (Y), n-th order, at point x.

Exceptions
css::lang::IllegalArgumentException
css::sheet::NoConvergenceException

Definition at line 426 of file bessel.cxx.

References Bessely0(), Bessely1(), and n.

Referenced by AnalysisAddIn::getBessely().

◆ Bessely0()

static double sca::analysis::Bessely0 ( double  fX)
static
Exceptions
IllegalArgumentException
NoConvergenceException

Definition at line 320 of file bessel.cxx.

References alpha, log, and u.

Referenced by BesselY().

◆ Bessely1()

static double sca::analysis::Bessely1 ( double  fX)
static
Exceptions
IllegalArgumentException
NoConvergenceException

Definition at line 374 of file bessel.cxx.

References alpha, log, and u.

Referenced by BesselY().

◆ BinomialCoefficient()

double sca::analysis::BinomialCoefficient ( double  n,
double  k 
)

Definition at line 588 of file analysishelper.cxx.

References n.

Referenced by AnalysisAddIn::getMultinomial().

◆ ConvertFromDec()

OUString sca::analysis::ConvertFromDec ( double  fNum,
double  fMin,
double  fMax,
sal_uInt16  nBase,
sal_Int32  nPlaces,
sal_Int32  nMaxPlaces,
bool  bUsePlaces 
)

◆ ConvertToDec()

double sca::analysis::ConvertToDec ( const OUString &  rFromNum,
sal_uInt16  nBaseFrom,
sal_uInt16  nCharLim 
)

◆ DateToDays()

sal_Int32 sca::analysis::DateToDays ( sal_uInt16  nDay,
sal_uInt16  nMonth,
sal_uInt16  nYear 
)

Convert a date to a count of days starting from 01/01/0001.

The internal representation of a Date used in this Addin is the number of days between 01/01/0001 and the date this function converts a Day , Month, Year representation to this internal Date value.

Definition at line 182 of file analysishelper.cxx.

References DaysInMonth(), and i.

Referenced by GetNullDate().

◆ DaysInMonth()

sal_uInt16 sca::analysis::DaysInMonth ( sal_uInt16  nMonth,
sal_uInt16  nYear 
)

◆ DaysToDate()

void sca::analysis::DaysToDate ( sal_Int32  nDays,
sal_uInt16 &  rDay,
sal_uInt16 &  rMonth,
sal_uInt16 &  rYear 
)

Convert a count of days starting from 01/01/0001 to a date.

The internal representation of a Date used in this Addin is the number of days between 01/01/0001 and the date this function converts this internal Date value to a Day , Month, Year representation of a Date.

Exceptions
css::lang::IllegalArgumentException

Definition at line 205 of file analysishelper.cxx.

References DaysInMonth(), i, and IsLeapYear().

Referenced by GetDaysInYear(), GetDiffDate(), GetDiffDate360(), GetYearFrac(), and sca::analysis::ScaDate::ScaDate().

◆ Erf()

double sca::analysis::Erf ( double  x)

Definition at line 729 of file analysishelper.cxx.

References x.

Referenced by AnalysisAddIn::getErf().

◆ Erfc()

double sca::analysis::Erfc ( double  x)

Definition at line 734 of file analysishelper.cxx.

References x.

Referenced by AnalysisAddIn::getErfc().

◆ GetAmordegrc()

double sca::analysis::GetAmordegrc ( sal_Int32  nNullDate,
double  fCost,
sal_Int32  nDate,
sal_Int32  nFirstPer,
double  fRestVal,
double  fPer,
double  fRate,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 953 of file analysishelper.cxx.

References GetYearFrac(), and n.

Referenced by AnalysisAddIn::getAmordegrc().

◆ GetAmorlinc()

double sca::analysis::GetAmorlinc ( sal_Int32  nNullDate,
double  fCost,
sal_Int32  nDate,
sal_Int32  nFirstPer,
double  fRestVal,
double  fPer,
double  fRate,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 998 of file analysishelper.cxx.

References GetYearFrac().

Referenced by AnalysisAddIn::getAmorlinc().

◆ GetCoupdaybs()

double sca::analysis::GetCoupdaybs ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1283 of file analysishelper.cxx.

References sca::analysis::ScaDate::getDiff(), isFreqInvalid(), and lcl_GetCouppcd().

Referenced by AnalysisAddIn::getCoupdaybs(), GetCoupdaysnc(), and getPrice_().

◆ GetCoupdays()

double sca::analysis::GetCoupdays ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1311 of file analysishelper.cxx.

References sca::analysis::ScaDate::addMonths(), GetDaysInYear(), sca::analysis::ScaDate::getDiff(), isFreqInvalid(), and lcl_GetCouppcd().

Referenced by AnalysisAddIn::getCoupdays(), GetCoupdaysnc(), and getPrice_().

◆ GetCoupdaysnc()

double sca::analysis::GetCoupdaysnc ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1295 of file analysishelper.cxx.

References GetCoupdaybs(), GetCoupdays(), sca::analysis::ScaDate::getDiff(), isFreqInvalid(), and lcl_GetCoupncd().

Referenced by AnalysisAddIn::getCoupdaysnc(), and getPrice_().

◆ GetCoupncd()

double sca::analysis::GetCoupncd ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1272 of file analysishelper.cxx.

References sca::analysis::ScaDate::getDate(), isFreqInvalid(), and lcl_GetCoupncd().

Referenced by AnalysisAddIn::getCoupncd().

◆ GetCoupnum()

double sca::analysis::GetCoupnum ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1328 of file analysishelper.cxx.

References sca::analysis::ScaDate::getMonth(), sca::analysis::ScaDate::getYear(), isFreqInvalid(), and lcl_GetCouppcd().

Referenced by AnalysisAddIn::getCoupnum(), GetDuration(), and getPrice_().

◆ GetCouppcd()

double sca::analysis::GetCouppcd ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1250 of file analysishelper.cxx.

References sca::analysis::ScaDate::getDate(), isFreqInvalid(), and lcl_GetCouppcd().

Referenced by AnalysisAddIn::getCouppcd().

◆ GetDayOfWeek()

sal_Int16 sca::analysis::GetDayOfWeek ( sal_Int32  nDate)
inline

◆ GetDaysInYear()

sal_Int32 sca::analysis::GetDaysInYear ( sal_Int32  nNullDate,
sal_Int32  nDate,
sal_Int32  nMode 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 421 of file analysishelper.cxx.

References DaysToDate(), and IsLeapYear().

Referenced by GetCoupdays().

◆ GetDaysInYears()

sal_Int32 sca::analysis::GetDaysInYears ( sal_uInt16  nYear1,
sal_uInt16  nYear2 
)

Definition at line 325 of file analysishelper.cxx.

References IsLeapYear(), and n.

Referenced by sca::analysis::ScaDate::getDaysInYearRange().

◆ GetDiffDate()

sal_Int32 sca::analysis::GetDiffDate ( sal_Int32  nNullDate,
sal_Int32  nStartDate,
sal_Int32  nEndDate,
sal_Int32  nMode,
sal_Int32 *  pOptDaysIn1stYear 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 344 of file analysishelper.cxx.

References DaysToDate(), and IsLeapYear().

Referenced by GetYearDiff().

◆ GetDiffDate360() [1/3]

sal_Int32 sca::analysis::GetDiffDate360 ( const css::uno::Reference< css::beans::XPropertySet > &  xOpt,
sal_Int32  nDate1,
sal_Int32  nDate2,
bool  bUSAMethod 
)
inline

Definition at line 575 of file analysishelper.hxx.

References GetDiffDate360(), and GetNullDate().

◆ GetDiffDate360() [2/3]

sal_Int32 sca::analysis::GetDiffDate360 ( sal_Int32  nNullDate,
sal_Int32  nDate1,
sal_Int32  nDate2,
bool  bUSAMethod 
)

Definition at line 311 of file analysishelper.cxx.

References DaysToDate(), GetDiffDate360(), and IsLeapYear().

◆ GetDiffDate360() [3/3]

sal_Int32 sca::analysis::GetDiffDate360 ( sal_uInt16  nDay1,
sal_uInt16  nMonth1,
sal_uInt16  nYear1,
bool  bLeapYear1,
sal_uInt16  nDay2,
sal_uInt16  nMonth2,
sal_uInt16  nYear2,
bool  bUSAMethod 
)

Definition at line 280 of file analysishelper.cxx.

Referenced by GetDiffDate360().

◆ GetDuration()

double sca::analysis::GetDuration ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
double  fCoup,
double  fYield,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1022 of file analysishelper.cxx.

References GetCoupnum(), GetYearFrac(), p, and t.

◆ GetFv()

double sca::analysis::GetFv ( double  fRate,
double  fNper,
double  fPmt,
double  fPv,
sal_Int32  nPayType 
)

Definition at line 1219 of file analysishelper.cxx.

Referenced by AnalysisAddIn::getCumipmt(), and AnalysisAddIn::getCumprinc().

◆ GetGcd()

double sca::analysis::GetGcd ( double  f1,
double  f2 
)

Definition at line 614 of file analysishelper.cxx.

Referenced by AnalysisAddIn::getGcd(), and AnalysisAddIn::getLcm().

◆ GetMaxChar()

static char sca::analysis::GetMaxChar ( sal_uInt16  nBase)
static

Definition at line 684 of file analysishelper.cxx.

Referenced by ConvertFromDec().

◆ GetNullDate() [1/2]

sal_Int32 sca::analysis::GetNullDate ( const css::uno::Reference< css::beans::XPropertySet > &  xOptions)
Exceptions
css::uno::RuntimeException

◆ GetNullDate() [2/2]

sal_Int32 sca::analysis::GetNullDate ( const uno::Reference< beans::XPropertySet > &  xOpt)

Get the null date used by the spreadsheet document.

The internal representation of a Date used in this Addin is the number of days between 01/01/0001 and the date this function returns this internal Date value for the document null date

Definition at line 259 of file analysishelper.cxx.

References DateToDays().

Referenced by GetDiffDate360(), and GetYearFrac().

◆ GetOddfprice()

double sca::analysis::GetOddfprice ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nIssue,
sal_Int32  nFirstCoup,
double  fRate,
double  fYield,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1071 of file analysishelper.cxx.

Referenced by AnalysisAddIn::getOddfprice().

◆ GetOddfyield()

double sca::analysis::GetOddfyield ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nIssue,
sal_Int32  nFirstCoup,
double  fRate,
double  fPrice,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1157 of file analysishelper.cxx.

Referenced by AnalysisAddIn::getOddfyield().

◆ GetOddlprice()

double sca::analysis::GetOddlprice ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nLastInterest,
double  fRate,
double  fYield,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1168 of file analysishelper.cxx.

References GetYearFrac(), and p.

◆ GetOddlyield()

double sca::analysis::GetOddlyield ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nLastInterest,
double  fRate,
double  fPrice,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1184 of file analysishelper.cxx.

References GetYearFrac(), and y.

◆ GetPmt()

double sca::analysis::GetPmt ( double  fRate,
double  fNper,
double  fPv,
double  fFv,
sal_Int32  nPayType 
)

Definition at line 1201 of file analysishelper.cxx.

Referenced by AnalysisAddIn::getCumipmt(), and AnalysisAddIn::getCumprinc().

◆ getPrice_()

double sca::analysis::getPrice_ ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
double  fRate,
double  fYield,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1134 of file analysishelper.cxx.

References GetCoupdaybs(), GetCoupdays(), GetCoupdaysnc(), and GetCoupnum().

Referenced by AnalysisAddIn::getPrice(), and getYield_().

◆ GetString()

OUString sca::analysis::GetString ( double  f,
bool  bLeadingSign,
sal_uInt16  nMaxDig 
)

Definition at line 936 of file analysishelper.cxx.

◆ GetVal()

static sal_uInt16 sca::analysis::GetVal ( sal_Unicode  c)
static

Definition at line 763 of file analysishelper.cxx.

Referenced by ParseDouble().

◆ GetYearDiff()

double sca::analysis::GetYearDiff ( sal_Int32  nNullDate,
sal_Int32  nStartDate,
sal_Int32  nEndDate,
sal_Int32  nMode 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 412 of file analysishelper.cxx.

References GetDiffDate().

◆ GetYearFrac() [1/2]

double sca::analysis::GetYearFrac ( const css::uno::Reference< css::beans::XPropertySet > &  xOpt,
sal_Int32  nStartDate,
sal_Int32  nEndDate,
sal_Int32  nMode 
)
inline
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 587 of file analysishelper.hxx.

References GetNullDate(), and GetYearFrac().

◆ GetYearFrac() [2/2]

double sca::analysis::GetYearFrac ( sal_Int32  nNullDate,
sal_Int32  nStartDate,
sal_Int32  nEndDate,
sal_Int32  nMode 
)

Function GetYearFrac implements YEARFRAC as defined in: Open Document Format for Office Applications version 1.2 Part 2, par.

6.10.24 The calculations are defined in: Open Document Format for Office Applications version 1.2 Part 2, par. 4.11.7

Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 451 of file analysishelper.cxx.

References DaysToDate(), i, and IsLeapYear().

Referenced by GetAmordegrc(), GetAmorlinc(), GetDuration(), GetOddlprice(), GetOddlyield(), GetYearFrac(), and GetYieldmat().

◆ getYield_()

double sca::analysis::getYield_ ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
double  fCoup,
double  fPrice,
double  fRedemp,
sal_Int32  nFreq,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1082 of file analysishelper.cxx.

References getPrice_().

◆ GetYieldmat()

double sca::analysis::GetYieldmat ( sal_Int32  nNullDate,
sal_Int32  nSettle,
sal_Int32  nMat,
sal_Int32  nIssue,
double  fRate,
double  fPrice,
sal_Int32  nBase 
)
Exceptions
css::uno::RuntimeException
css::lang::IllegalArgumentException

Definition at line 1055 of file analysishelper.cxx.

References GetYearFrac(), and y.

◆ InitFuncDataList()

void sca::analysis::InitFuncDataList ( FuncDataList rList)

Definition at line 1368 of file analysishelper.cxx.

References pFuncDatas.

Referenced by AnalysisAddIn::InitData().

◆ IsComma()

static bool sca::analysis::IsComma ( sal_Unicode  c)
static

Definition at line 745 of file analysishelper.cxx.

Referenced by ParseDouble().

◆ IsExpStart()

static bool sca::analysis::IsExpStart ( sal_Unicode  c)
static

Definition at line 751 of file analysishelper.cxx.

Referenced by ParseDouble().

◆ IsImagUnit()

static bool sca::analysis::IsImagUnit ( sal_Unicode  c)
static

Definition at line 757 of file analysishelper.cxx.

Referenced by ParseDouble().

◆ IsLeapYear()

bool sca::analysis::IsLeapYear ( sal_uInt16  nYear)
inline

◆ IsNum()

static bool sca::analysis::IsNum ( sal_Unicode  c)
static

Definition at line 739 of file analysishelper.cxx.

Referenced by ParseDouble().

◆ lcl_GetCoupncd()

static void sca::analysis::lcl_GetCoupncd ( ScaDate rDate,
const ScaDate rSettle,
const ScaDate rMat,
sal_Int32  nFreq 
)
static
Exceptions
css::lang::IllegalArgumentException

Definition at line 1262 of file analysishelper.cxx.

References sca::analysis::ScaDate::addMonths(), sca::analysis::ScaDate::addYears(), sca::analysis::ScaDate::getYear(), and sca::analysis::ScaDate::setYear().

Referenced by GetCoupdaysnc(), and GetCoupncd().

◆ lcl_GetCouppcd()

static void sca::analysis::lcl_GetCouppcd ( ScaDate rDate,
const ScaDate rSettle,
const ScaDate rMat,
sal_Int32  nFreq 
)
static

◆ ParseDouble()

bool sca::analysis::ParseDouble ( const sal_Unicode *&  rp,
double &  rRet 
)

Definition at line 769 of file analysishelper.cxx.

References GetVal(), IsComma(), IsExpStart(), IsImagUnit(), IsNum(), and p.

Referenced by sca::analysis::Complex::ParseString().