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< FuncData >	FuncDataList

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

enum sca::analysis::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
	)

Exceptions

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

Definition at line 691 of file analysishelper.cxx.

References GetMaxChar(), and p.

Referenced by AnalysisAddIn::getBin2Hex(), AnalysisAddIn::getBin2Oct(), AnalysisAddIn::getDec2Bin(), AnalysisAddIn::getDec2Hex(), AnalysisAddIn::getDec2Oct(), AnalysisAddIn::getHex2Bin(), AnalysisAddIn::getHex2Oct(), AnalysisAddIn::getOct2Bin(), and AnalysisAddIn::getOct2Hex().

ConvertToDec()

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

Exceptions

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

Definition at line 628 of file analysishelper.cxx.

References aStr, n, and p.

Referenced by AnalysisAddIn::getBin2Dec(), AnalysisAddIn::getBin2Hex(), AnalysisAddIn::getBin2Oct(), AnalysisAddIn::getHex2Bin(), AnalysisAddIn::getHex2Dec(), AnalysisAddIn::getHex2Oct(), AnalysisAddIn::getOct2Bin(), AnalysisAddIn::getOct2Dec(), and AnalysisAddIn::getOct2Hex().

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
	)

Definition at line 163 of file analysishelper.cxx.

References IsLeapYear().

Referenced by DateToDays(), DaysToDate(), sca::analysis::ScaDate::getDate(), sca::analysis::ScaDate::getDaysInMonth(), sca::analysis::ScaDate::getDiff(), sca::analysis::ScaDate::ScaDate(), and sca::analysis::ScaDate::setDay().

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

Definition at line 581 of file analysishelper.hxx.

References n.

Referenced by AnalysisAddIn::getNetworkdays(), AnalysisAddIn::getWeeknum(), AnalysisAddIn::getWorkday(), and sca::analysis::SortedIndividualInt32List::Insert().

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

Definition at line 569 of file analysishelper.hxx.

References n.

Referenced by DaysInMonth(), DaysToDate(), GetDaysInYear(), GetDaysInYears(), GetDiffDate(), GetDiffDate360(), and GetYearFrac().

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

Exceptions

css::lang::IllegalArgumentException

Definition at line 1240 of file analysishelper.cxx.

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

Referenced by GetCoupdaybs(), GetCoupdays(), GetCoupnum(), and GetCouppcd().

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().