📄 xlsfunctionnames.inc

📁 TMS Component Pack V5.0包含了超过 280 个为 Delphi 以及 C++Builder 设计的 TMS 生产控件
💻 INC
📖 第 1 页 / 共 3 页
字号:
12 3 下一页
//************************************************************************************//
//  File created automatically by Generatefunctions.cs                                 //
//  Do not modify by hand                                                             //
//************************************************************************************//

FuncNameArray: array[0.. 367] of TCellFunctionData=(
  (Index:  0 ; Name: 'COUNT'; MinArgCount: 0 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  1 ; Name: 'IF'; MinArgCount: 2 ; MaxArgCount: 3; Volatile: False; ReturnType: fmRef; ParamType:'VRR'),
  (Index:  2 ; Name: 'ISNA'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  3 ; Name: 'ISERROR'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  4 ; Name: 'SUM'; MinArgCount: 0 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  5 ; Name: 'AVERAGE'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  6 ; Name: 'MIN'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  7 ; Name: 'MAX'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  8 ; Name: 'ROW'; MinArgCount: 0 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  9 ; Name: 'COLUMN'; MinArgCount: 0 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  10 ; Name: 'NA'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:'-'),
  (Index:  11 ; Name: 'NPV'; MinArgCount: 2 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'VR'),
  (Index:  12 ; Name: 'STDEV'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  13 ; Name: 'DOLLAR'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  14 ; Name: 'FIXED'; MinArgCount: 1 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VVV'),
  (Index:  15 ; Name: 'SIN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  16 ; Name: 'COS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  17 ; Name: 'TAN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  18 ; Name: 'ATAN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  19 ; Name: 'PI'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:'-'),
  (Index:  20 ; Name: 'SQRT'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  21 ; Name: 'EXP'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  22 ; Name: 'LN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  23 ; Name: 'LOG10'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  24 ; Name: 'ABS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  25 ; Name: 'INT'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  26 ; Name: 'SIGN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  27 ; Name: 'ROUND'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  28 ; Name: 'LOOKUP'; MinArgCount: 2 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VRR'),
  (Index:  29 ; Name: 'INDEX'; MinArgCount: 2 ; MaxArgCount: 4; Volatile: False; ReturnType: fmRef; ParamType:'RVVV'),
  (Index:  30 ; Name: 'REPT'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  31 ; Name: 'MID'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VVV'),
  (Index:  32 ; Name: 'LEN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  33 ; Name: 'VALUE'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  34 ; Name: 'TRUE'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:'-'),
  (Index:  35 ; Name: 'FALSE'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:'-'),
  (Index:  36 ; Name: 'AND'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  37 ; Name: 'OR'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  38 ; Name: 'NOT'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  39 ; Name: 'MOD'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  40 ; Name: 'DCOUNT'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  41 ; Name: 'DSUM'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  42 ; Name: 'DAVERAGE'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  43 ; Name: 'DMIN'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  44 ; Name: 'DMAX'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  45 ; Name: 'DSTDEV'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  46 ; Name: 'VAR'; MinArgCount: 1 ; MaxArgCount: 30; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  47 ; Name: 'DVAR'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RRR'),
  (Index:  48 ; Name: 'TEXT'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  49 ; Name: 'LINEST'; MinArgCount: 1 ; MaxArgCount: 4; Volatile: False; ReturnType: fmArray; ParamType:'RRVV'),
  (Index:  50 ; Name: 'TREND'; MinArgCount: 1 ; MaxArgCount: 4; Volatile: False; ReturnType: fmArray; ParamType:'RRRV'),
  (Index:  51 ; Name: 'LOGEST'; MinArgCount: 1 ; MaxArgCount: 4; Volatile: False; ReturnType: fmArray; ParamType:'RRVV'),
  (Index:  52 ; Name: 'GROWTH'; MinArgCount: 1 ; MaxArgCount: 4; Volatile: False; ReturnType: fmArray; ParamType:'RRRV'),
  (Index:  53 ; Name: 'NotAFunction53'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  54 ; Name: 'NotAFunction54'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  55 ; Name: 'NotAFunction55'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  56 ; Name: 'PV'; MinArgCount: 3 ; MaxArgCount: 5; Volatile: False; ReturnType: fmValue; ParamType:'VVVVV'),
  (Index:  57 ; Name: 'FV'; MinArgCount: 3 ; MaxArgCount: 5; Volatile: False; ReturnType: fmValue; ParamType:'VVVVV'),
  (Index:  58 ; Name: 'NPER'; MinArgCount: 3 ; MaxArgCount: 5; Volatile: False; ReturnType: fmValue; ParamType:'VVVVV'),
  (Index:  59 ; Name: 'PMT'; MinArgCount: 3 ; MaxArgCount: 5; Volatile: False; ReturnType: fmValue; ParamType:'VVVVV'),
  (Index:  60 ; Name: 'RATE'; MinArgCount: 3 ; MaxArgCount: 6; Volatile: False; ReturnType: fmValue; ParamType:'VVVVVV'),
  (Index:  61 ; Name: 'MIRR'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'RVV'),
  (Index:  62 ; Name: 'IRR'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'RV'),
  (Index:  63 ; Name: 'RAND'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: True; ReturnType: fmValue; ParamType:'-'),
  (Index:  64 ; Name: 'MATCH'; MinArgCount: 2 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VRR'),
  (Index:  65 ; Name: 'DATE'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VVV'),
  (Index:  66 ; Name: 'TIME'; MinArgCount: 3 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VVV'),
  (Index:  67 ; Name: 'DAY'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  68 ; Name: 'MONTH'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  69 ; Name: 'YEAR'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  70 ; Name: 'WEEKDAY'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  71 ; Name: 'HOUR'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  72 ; Name: 'MINUTE'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  73 ; Name: 'SECOND'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  74 ; Name: 'NOW'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: True; ReturnType: fmValue; ParamType:'-'),
  (Index:  75 ; Name: 'AREAS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  76 ; Name: 'ROWS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  77 ; Name: 'COLUMNS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  78 ; Name: 'OFFSET'; MinArgCount: 3 ; MaxArgCount: 5; Volatile: True; ReturnType: fmRef; ParamType:'RVVVV'),
  (Index:  79 ; Name: 'NotAFunction79'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  80 ; Name: 'NotAFunction80'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  81 ; Name: 'NotAFunction81'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  82 ; Name: 'SEARCH'; MinArgCount: 2 ; MaxArgCount: 3; Volatile: False; ReturnType: fmValue; ParamType:'VVV'),
  (Index:  83 ; Name: 'TRANSPOSE'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmArray; ParamType:'A'),
  (Index:  84 ; Name: 'NotAFunction84'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  85 ; Name: 'NotAFunction85'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  86 ; Name: 'TYPE'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  87 ; Name: 'NotAFunction87'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  88 ; Name: 'NotAFunction88'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  89 ; Name: 'NotAFunction89'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  90 ; Name: 'NotAFunction90'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  91 ; Name: 'NotAFunction91'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  92 ; Name: 'NotAFunction92'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  93 ; Name: 'NotAFunction93'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  94 ; Name: 'NotAFunction94'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  95 ; Name: 'NotAFunction95'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  96 ; Name: 'NotAFunction96'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  97 ; Name: 'ATAN2'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  98 ; Name: 'ASIN'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  99 ; Name: 'ACOS'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  100 ; Name: 'CHOOSE'; MinArgCount: 2 ; MaxArgCount: 30; Volatile: False; ReturnType: fmRef; ParamType:'VR'),
  (Index:  101 ; Name: 'HLOOKUP'; MinArgCount: 3 ; MaxArgCount: 4; Volatile: False; ReturnType: fmValue; ParamType:'VRRV'),
  (Index:  102 ; Name: 'VLOOKUP'; MinArgCount: 3 ; MaxArgCount: 4; Volatile: False; ReturnType: fmValue; ParamType:'VRRV'),
  (Index:  103 ; Name: 'NotAFunction103'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  104 ; Name: 'NotAFunction104'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  105 ; Name: 'ISREF'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'R'),
  (Index:  106 ; Name: 'NotAFunction106'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  107 ; Name: 'NotAFunction107'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  108 ; Name: 'NotAFunction108'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  109 ; Name: 'LOG'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  110 ; Name: 'NotAFunction110'; MinArgCount: 0 ; MaxArgCount: 0; Volatile: False; ReturnType: fmValue; ParamType:''),
  (Index:  111 ; Name: 'CHAR'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  112 ; Name: 'LOWER'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  113 ; Name: 'UPPER'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  114 ; Name: 'PROPER'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
  (Index:  115 ; Name: 'LEFT'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  116 ; Name: 'RIGHT'; MinArgCount: 1 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  117 ; Name: 'EXACT'; MinArgCount: 2 ; MaxArgCount: 2; Volatile: False; ReturnType: fmValue; ParamType:'VV'),
  (Index:  118 ; Name: 'TRIM'; MinArgCount: 1 ; MaxArgCount: 1; Volatile: False; ReturnType: fmValue; ParamType:'V'),
12 3 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -