Vba (Mondrian OLAP Server, version 3.0.2.10775)

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

mondrian.olap.fun.vba
Class Vba

java.lang.Object
  mondrian.olap.fun.vba.Vba

public class Vba
extends Object
extends Object

Implementations of functions in the Visual Basic for Applications (VBA) specification.

Since:

Dec 31, 2007

Author:

jhyde

Constructor Summary
`Vba()`

Method Summary
`static double`	`abs(double number)`
`static int`	`asc(String string)`
`static int`	`ascB(String string)`
`static int`	`ascW(String string)`
`static double`	`atn(double number)`
`static boolean`	`cBool(Object expression)`
`static byte`	`cByte(Object expression)`
`static Date`	`cDate(Object expression)`
`static double`	`cDbl(Object expression)`
`static String`	`chr(int charCode)`
`static String`	`chrB(int charCode)`
`static String`	`chrW(int charCode)`
`static int`	`cInt(Object expression)`
`static double`	`cos(double number)`
`static Date`	`date()`
`static Date`	`dateAdd(String intervalName, double number, Date date)`
`static long`	`dateDiff(String interval, Date date1, Date date2)`
`static long`	`dateDiff(String interval, Date date1, Date date2, int firstDayOfWeek)`
`static long`	`dateDiff(String interval, Date date1, Date date2, int firstDayOfWeek, int firstWeekOfYear)`
`static int`	`datePart(String interval, Date date)`
`static int`	`datePart(String interval, Date date, int firstDayOfWeek)`
`static int`	`datePart(String interval, Date date, int firstDayOfWeek, int firstWeekOfYear)`
`static Date`	`dateSerial(int year, int month, int day)`
`static Date`	`dateValue(Date date)`
`static int`	`day(Date date)`
`static double`	`dDB(double cost, double salvage, double life, double period)`
`static double`	`dDB(double cost, double salvage, double life, double period, double factor)`
`static double`	`exp(double number)`
`static int`	`fix(Object number)`
`static String`	`formatCurrency(Object expression)`
`static String`	`formatCurrency(Object expression, int numDigitsAfterDecimal)`
`static String`	`formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)`
`static String`	`formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)`
`static String`	`formatCurrency(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)`
`static String`	`formatDateTime(Date date)`
`static String`	`formatDateTime(Date date, int namedFormat)`
`static String`	`formatNumber(Object expression)`
`static String`	`formatNumber(Object expression, int numDigitsAfterDecimal)`
`static String`	`formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)`
`static String`	`formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)`
`static String`	`formatNumber(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)`
`static String`	`formatPercent(Object expression)`
`static String`	`formatPercent(Object expression, int numDigitsAfterDecimal)`
`static String`	`formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit)`
`static String`	`formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers)`
`static String`	`formatPercent(Object expression, int numDigitsAfterDecimal, int includeLeadingDigit, int useParensForNegativeNumbers, int groupDigits)`
`static double`	`fV(double rate, double nPer, double pmt)`
`static double`	`fV(double rate, double nPer, double pmt, double pv)`
`static double`	`fV(double rate, double nPer, double pmt, double pv, boolean type)`
`static String`	`hex(Object number)`
`static int`	`hour(Date time)`

mondrian.olap.fun.vba Class Vba

mondrian.olap.fun.vba
Class Vba