📄 function.java
字号:
// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name: Function.java
package jxl.biff.formula;
import common.Logger;
import jxl.WorkbookSettings;
// Referenced classes of package jxl.biff.formula:
// FunctionNames
final class Function
{
private static Logger logger;
private final int code;
private final String name;
private final int numArgs;
private static Function functions[] = new Function[0];
public static final Function COUNT = new Function(0, "count", 255);
public static final Function ATTRIBUTE = new Function(1, "", 255);
public static final Function ISNA = new Function(2, "isna", 1);
public static final Function ISERROR = new Function(3, "iserror", 1);
public static final Function SUM = new Function(4, "sum", 255);
public static final Function AVERAGE = new Function(5, "average", 255);
public static final Function MIN = new Function(6, "min", 255);
public static final Function MAX = new Function(7, "max", 255);
public static final Function ROW = new Function(8, "row", 255);
public static final Function COLUMN = new Function(9, "column", 255);
public static final Function NA = new Function(10, "na", 0);
public static final Function NPV = new Function(11, "npv", 255);
public static final Function STDEV = new Function(12, "stdev", 255);
public static final Function DOLLAR = new Function(13, "dollar", 2);
public static final Function FIXED = new Function(14, "fixed", 255);
public static final Function SIN = new Function(15, "sin", 1);
public static final Function COS = new Function(16, "cos", 1);
public static final Function TAN = new Function(17, "tan", 1);
public static final Function ATAN = new Function(18, "atan", 1);
public static final Function PI = new Function(19, "pi", 0);
public static final Function SQRT = new Function(20, "sqrt", 1);
public static final Function EXP = new Function(21, "exp", 1);
public static final Function LN = new Function(22, "ln", 1);
public static final Function LOG10 = new Function(23, "log10", 1);
public static final Function ABS = new Function(24, "abs", 1);
public static final Function INT = new Function(25, "int", 1);
public static final Function SIGN = new Function(26, "sign", 1);
public static final Function ROUND = new Function(27, "round", 2);
public static final Function LOOKUP = new Function(28, "lookup", 2);
public static final Function INDEX = new Function(29, "index", 3);
public static final Function REPT = new Function(30, "rept", 2);
public static final Function MID = new Function(31, "mid", 3);
public static final Function LEN = new Function(32, "len", 1);
public static final Function VALUE = new Function(33, "value", 1);
public static final Function TRUE = new Function(34, "true", 0);
public static final Function FALSE = new Function(35, "false", 0);
public static final Function AND = new Function(36, "and", 255);
public static final Function OR = new Function(37, "or", 255);
public static final Function NOT = new Function(38, "not", 1);
public static final Function MOD = new Function(39, "mod", 2);
public static final Function DCOUNT = new Function(40, "dcount", 3);
public static final Function DSUM = new Function(41, "dsum", 3);
public static final Function DAVERAGE = new Function(42, "daverage", 3);
public static final Function DMIN = new Function(43, "dmin", 3);
public static final Function DMAX = new Function(44, "dmax", 3);
public static final Function DSTDEV = new Function(45, "dstdev", 3);
public static final Function VAR = new Function(46, "var", 255);
public static final Function DVAR = new Function(47, "dvar", 3);
public static final Function TEXT = new Function(48, "text", 2);
public static final Function LINEST = new Function(49, "linest", 255);
public static final Function TREND = new Function(50, "trend", 255);
public static final Function LOGEST = new Function(51, "logest", 255);
public static final Function GROWTH = new Function(52, "growth", 255);
public static final Function PV = new Function(56, "pv", 255);
public static final Function FV = new Function(57, "fv", 255);
public static final Function NPER = new Function(58, "nper", 255);
public static final Function PMT = new Function(59, "pmt", 255);
public static final Function RATE = new Function(60, "rate", 255);
public static final Function RAND = new Function(63, "rand", 0);
public static final Function MATCH = new Function(64, "match", 3);
public static final Function DATE = new Function(65, "date", 3);
public static final Function TIME = new Function(66, "time", 3);
public static final Function DAY = new Function(67, "day", 1);
public static final Function MONTH = new Function(68, "month", 1);
public static final Function YEAR = new Function(69, "year", 1);
public static final Function WEEKDAY = new Function(70, "weekday", 2);
public static final Function HOUR = new Function(71, "hour", 1);
public static final Function MINUTE = new Function(72, "minute", 1);
public static final Function SECOND = new Function(73, "second", 1);
public static final Function NOW = new Function(74, "now", 0);
public static final Function AREAS = new Function(75, "areas", 255);
public static final Function ROWS = new Function(76, "rows", 1);
public static final Function COLUMNS = new Function(77, "columns", 255);
public static final Function OFFSET = new Function(78, "offset", 255);
public static final Function SEARCH = new Function(82, "search", 255);
public static final Function TRANSPOSE = new Function(83, "transpose", 255);
public static final Function ERROR = new Function(84, "error", 1);
public static final Function TYPE = new Function(86, "type", 1);
public static final Function ATAN2 = new Function(97, "atan2", 1);
public static final Function ASIN = new Function(98, "asin", 1);
public static final Function ACOS = new Function(99, "acos", 1);
public static final Function CHOOSE = new Function(100, "choose", 255);
public static final Function HLOOKUP = new Function(101, "hlookup", 255);
public static final Function VLOOKUP = new Function(102, "vlookup", 255);
public static final Function ISREF = new Function(105, "isref", 1);
public static final Function LOG = new Function(109, "log", 255);
public static final Function CHAR = new Function(111, "char", 1);
public static final Function LOWER = new Function(112, "lower", 1);
public static final Function UPPER = new Function(113, "upper", 1);
public static final Function PROPER = new Function(114, "proper", 1);
public static final Function LEFT = new Function(115, "left", 255);
public static final Function RIGHT = new Function(116, "right", 255);
public static final Function EXACT = new Function(117, "exact", 2);
public static final Function TRIM = new Function(118, "trim", 1);
public static final Function REPLACE = new Function(119, "replace", 4);
public static final Function SUBSTITUTE = new Function(120, "substitute", 255);
public static final Function CODE = new Function(121, "code", 1);
public static final Function FIND = new Function(124, "find", 255);
public static final Function CELL = new Function(125, "cell", 2);
public static final Function ISERR = new Function(126, "iserr", 1);
public static final Function ISTEXT = new Function(127, "istext", 1);
public static final Function ISNUMBER = new Function(128, "isnumber", 1);
public static final Function ISBLANK = new Function(129, "isblank", 1);
public static final Function T = new Function(130, "t", 1);
public static final Function N = new Function(131, "n", 1);
public static final Function DATEVALUE = new Function(140, "datevalue", 1);
public static final Function TIMEVALUE = new Function(141, "timevalue", 1);
public static final Function SLN = new Function(142, "sln", 3);
public static final Function SYD = new Function(143, "syd", 3);
public static final Function DDB = new Function(144, "ddb", 255);
public static final Function INDIRECT = new Function(148, "indirect", 255);
public static final Function CLEAN = new Function(162, "clean", 1);
public static final Function MDETERM = new Function(163, "mdeterm", 255);
public static final Function MINVERSE = new Function(164, "minverse", 255);
public static final Function MMULT = new Function(165, "mmult", 255);
public static final Function IPMT = new Function(167, "ipmt", 255);
public static final Function PPMT = new Function(168, "ppmt", 255);
public static final Function COUNTA = new Function(169, "counta", 255);
public static final Function PRODUCT = new Function(183, "product", 255);
public static final Function FACT = new Function(184, "fact", 1);
public static final Function DPRODUCT = new Function(189, "dproduct", 3);
public static final Function ISNONTEXT = new Function(190, "isnontext", 1);
public static final Function STDEVP = new Function(193, "stdevp", 255);
public static final Function VARP = new Function(194, "varp", 255);
public static final Function DSTDEVP = new Function(195, "dstdevp", 255);
public static final Function DVARP = new Function(196, "dvarp", 255);
public static final Function TRUNC = new Function(197, "trunc", 255);
public static final Function ISLOGICAL = new Function(198, "islogical", 1);
public static final Function DCOUNTA = new Function(199, "dcounta", 255);
public static final Function FINDB = new Function(205, "findb", 255);
public static final Function SEARCHB = new Function(206, "searchb", 3);
public static final Function REPLACEB = new Function(207, "replaceb", 4);
public static final Function LEFTB = new Function(208, "leftb", 255);
public static final Function RIGHTB = new Function(209, "rightb", 255);
public static final Function MIDB = new Function(210, "midb", 3);
public static final Function LENB = new Function(211, "lenb", 1);
public static final Function ROUNDUP = new Function(212, "roundup", 2);
public static final Function ROUNDDOWN = new Function(213, "rounddown", 2);
public static final Function RANK = new Function(216, "rank", 255);
public static final Function ADDRESS = new Function(219, "address", 255);
public static final Function AYS360 = new Function(220, "days360", 255);
public static final Function ODAY = new Function(221, "today", 0);
public static final Function VDB = new Function(222, "vdb", 255);
public static final Function MEDIAN = new Function(227, "median", 255);
public static final Function SUMPRODUCT = new Function(228, "sumproduct", 255);
public static final Function SINH = new Function(229, "sinh", 1);
public static final Function COSH = new Function(230, "cosh", 1);
public static final Function TANH = new Function(231, "tanh", 1);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -