Uses of Annotation Interface
mondrian.olap.fun.JavaFunDef.Signature
Package
Description
Implements the set of functions defined by the Visual Basic for Applications
(VBA) specification.
-
Uses of JavaFunDef.Signature in mondrian.olap.fun.vba
Modifier and TypeMethodDescriptionstatic double
Vba.abs
(double number) static double
Excel.acos
(double number) static double
Excel.acosh
(double x) static int
static int
static int
static double
Excel.asin
(double number) static double
Excel.asinh
(double x) static double
Excel.atan2
(double y, double x) static double
Excel.atanh
(double x) static double
Vba.atn
(double number) static boolean
static byte
static Date
static double
static String
Vba.chr
(int charCode) static String
Vba.chrB
(int charCode) static String
Vba.chrW
(int charCode) static int
static double
Vba.cos
(double number) static Date
Vba.date()
static Date
static long
static long
static long
static int
static int
static int
static Date
Vba.dateSerial
(int year, int month, int day) static Date
static int
static double
Vba.dDB
(double cost, double salvage, double life, double period) static double
Vba.dDB
(double cost, double salvage, double life, double period, double factor) static double
Vba.exp
(double number) static int
static String
Vba.formatCurrency
(Object expression) static String
Vba.formatCurrency
(Object expression, int numDigitsAfterDecimal) static String
Vba.formatCurrency
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit) static String
Vba.formatCurrency
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers) static String
Vba.formatCurrency
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits) static String
Vba.formatDateTime
(Date date) static String
Vba.formatDateTime
(Date date, int namedFormat) static String
Vba.formatNumber
(Object expression) static String
Vba.formatNumber
(Object expression, int numDigitsAfterDecimal) static String
Vba.formatNumber
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit) static String
Vba.formatNumber
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers) static String
Vba.formatNumber
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits) static String
Vba.formatPercent
(Object expression) static String
Vba.formatPercent
(Object expression, int numDigitsAfterDecimal) static String
Vba.formatPercent
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit) static String
Vba.formatPercent
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers) static String
Vba.formatPercent
(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits) static double
Vba.fV
(double rate, double nPer, double pmt) static double
Vba.fV
(double rate, double nPer, double pmt, double pv) static double
Vba.fV
(double rate, double nPer, double pmt, double pv, boolean type) static String
static int
static int
static int
static int
static int
static int
static int
static int
static double
Vba.iPmt
(double rate, double per, double nPer, double PV) static double
Vba.iPmt
(double rate, double per, double nPer, double PV, double fv) static double
Vba.iPmt
(double rate, double per, double nPer, double PV, double fv, boolean due) static double
Vba.IRR
(double[] valueArray) static double
Vba.IRR
(double[] valueArray, double guess) boolean
static boolean
boolean
boolean
boolean
boolean
boolean
static String
static String
static double
Vba.log
(double number) static String
static String
static String
static int
static double
Vba.MIRR
(double[] valueArray, double financeRate, double reinvestRate) static double
The MOD function.static int
static String
Vba.monthName
(int month, boolean abbreviate) static Date
Vba.now()
static double
Vba.nPer
(double rate, double pmt, double pv, double fv, boolean due) static double
Vba.nPV
(double r, double[] cfs) static String
static double
Vba.pmt
(double rate, double nPer, double pv, double fv, boolean due) static double
Vba.pPmt
(double rate, double per, double nPer, double PV) static double
Vba.pPmt
(double rate, double per, double nPer, double PV, double fv) static double
Vba.pPmt
(double rate, double per, double nPer, double PV, double fv, boolean due) static double
Vba.pV
(double rate, double nper, double pmt, double fv, boolean due) static double
Vba.rate
(double nPer, double pmt, double PV) static double
Vba.rate
(double nPer, double pmt, double PV, double fv) static double
Vba.rate
(double nPer, double pmt, double PV, double fv, boolean type) static double
Vba.rate
(double nPer, double pmt, double PV, double fv, boolean due, double guess) static String
static String
static String
static String
static String
static double
Vba.round
(double number) static double
Vba.round
(double number, int numDigitsAfterDecimal) static String
static int
static int
Vba.sgn
(double number) static double
Vba.sin
(double number) static double
Vba.sLN
(double cost, double salvage, double life) static String
Vba.space
(int number) static double
Vba.sqr
(double number) static String
static int
static int
static String
Vba.string
(int number, char character) static String
Vba.strReverse
(String expression) static double
Vba.sYD
(double cost, double salvage, double life, double period) static double
Vba.tan
(double number) static Date
Vba.time()
static float
Vba.timer()
static Date
Vba.timeSerial
(int hour, int minute, int second) static Date
static String
static String
static double
static int
static int
static String
Vba.weekdayName
(int weekday, boolean abbreviate, int firstDayOfWeek) static int