1export enum FormulaName {
  2  /**
  3   * Math.
  4   */
  5  ABS = "ABS",
  6  ACOS = "ACOS",
  7  ACOSH = "ACOSH",
  8  ACOT = "ACOT",
  9  ACOTH = "ACOTH",
 10  ADD = "ADD",
 11  ASIN = "ASIN",
 12  ASINH = "ASINH",
 13  ATAN = "ATAN",
 14  ATAN2 = "ATAN2",
 15  ATANH = "ATANH",
 16  COS = "COS",
 17  COSH = "COSH",
 18  COT = "COT",
 19  DIVIDE = "DIVIDE",
 20  EVEN = "EVEN",
 21  INT = "INT",
 22  ISEVEN = "ISEVEN",
 23  ISODD = "ISODD",
 24  LN = "LN",
 25  LOG = "LOG",
 26  LOG10 = "LOG10",
 27  MINUS = "MINUS",
 28  MOD = "MOD",
 29  MULTIPLY = "MULTIPLY",
 30  ODD = "ODD",
 31  PI = "PI",
 32  POW = "POW",
 33  POWER = "POWER",
 34  PRODUCT = "PRODUCT",
 35  QUOTIENT = "QUOTIENT",
 36  RAND = "RAND",
 37  RANDBETWEEN = "RANDBETWEEN",
 38  ROUND = "ROUND",
 39  FLOOR = "FLOOR",
 40  ROUNDDOWN = "ROUNDDOWN",
 41  ROUNDUP = "ROUNDUP",
 42  SIGN = "SIGN",
 43  SIN = "SIN",
 44  SINH = "SINH",
 45  SQRT = "SQRT",
 46  SQRTPI = "SQRTPI",
 47  SUM = "SUM",
 48  TAN = "TAN",
 49  TANH = "TANH",
 50  UMINUS = "UMINUS",
 51  UPLUS = "UPLUS",
 52  UNARY_PERCENT = "UNARY_PERCENT",
 53  /**
 54   * Statistical.
 55   */
 56  AVEDEV = "AVEDEV",
 57  AVERAGE = "AVERAGE",
 58  AVERAGEA = "AVERAGEA",
 59  AVERAGEIF = "AVERAGEIF",
 60  COUNT = "COUNT",
 61  COUNTA = "COUNTA",
 62  COUNTBLANK = "COUNTBLANK",
 63  MAX = "MAX",
 64  MAXA = "MAXA",
 65  MIN = "MIN",
 66  MINA = "MINA",
 67  STDEV = "STDEV",
 68  /**
 69   * Info.
 70   */
 71  ERRORTYPE = "ERRORTYPE",
 72  ISBLANK = "ISBLANK",
 73  ISERR = "ISERR",
 74  ISERROR = "ISERROR",
 75  ISLOGICAL = "ISLOGICAL",
 76  ISNA = "ISNA",
 77  ISNONTEXT = "ISNONTEXT",
 78  ISNUMBER = "ISNUMBER",
 79  ISTEXT = "ISTEXT",
 80  N = "N",
 81  NA = "NA",
 82  TYPE = "TYPE",
 83  /**
 84   * Text.
 85   */
 86  CONCAT = "CONCAT",
 87  CONCATENATE = "CONCATENATE",
 88  LEN = "LEN",
 89  T = "T",
 90  /**
 91   * Engineering.
 92   */
 93  BIN2DEC = "BIN2DEC",
 94  BIN2HEX = "BIN2HEX",
 95  DELTA = "DELTA",
 96  /**
 97   * Parser.
 98   */
 99  TO_PERCENT = "TO_PERCENT",
100  TO_TEXT = "TO_TEXT",
101  /**
102   * Lookup.
103   */
104  CHOOSE = "CHOOSE",
105  /**
106   * Logical
107   */
108  AND = "AND",
109  EQ = "EQ",
110  EXACT = "EXACT",
111  FALSE = "FALSE",
112  GT = "GT",
113  GTE = "GTE",
114  IF = "IF",
115  IFERROR = "IFERROR",
116  IFNA = "IFNA",
117  LT = "LT",
118  LTE = "LTE",
119  NE = "NE",
120  NOT = "NOT",
121  OR = "OR",
122  TRUE = "TRUE",
123  XOR = "XOR",
124  /**
125   * Unknown. For testing only.
126   */
127  UNKNOWN = "UNKNOWN",
128}
129
130export const AllFormulaNames = new Set([
131  FormulaName.ABS,
132  FormulaName.ACOS,
133  FormulaName.ACOSH,
134  FormulaName.ACOT,
135  FormulaName.ACOTH,
136  FormulaName.ADD,
137  FormulaName.ASIN,
138  FormulaName.ASINH,
139  FormulaName.ATAN,
140  FormulaName.ATAN2,
141  FormulaName.ATANH,
142  FormulaName.COS,
143  FormulaName.COSH,
144  FormulaName.COT,
145  FormulaName.DIVIDE,
146  FormulaName.EVEN,
147  FormulaName.INT,
148  FormulaName.ISEVEN,
149  FormulaName.ISODD,
150  FormulaName.LN,
151  FormulaName.LOG,
152  FormulaName.LOG10,
153  FormulaName.MINUS,
154  FormulaName.MOD,
155  FormulaName.MULTIPLY,
156  FormulaName.ODD,
157  FormulaName.PI,
158  FormulaName.POW,
159  FormulaName.POWER,
160  FormulaName.PRODUCT,
161  FormulaName.QUOTIENT,
162  FormulaName.RAND,
163  FormulaName.RANDBETWEEN,
164  FormulaName.ROUND,
165  FormulaName.ROUNDDOWN,
166  FormulaName.ROUNDUP,
167  FormulaName.SIGN,
168  FormulaName.SIN,
169  FormulaName.SINH,
170  FormulaName.SQRT,
171  FormulaName.SQRTPI,
172  FormulaName.SUM,
173  FormulaName.TAN,
174  FormulaName.TANH,
175  FormulaName.UMINUS,
176  FormulaName.UPLUS,
177  FormulaName.UNARY_PERCENT,
178  FormulaName.AVEDEV,
179  FormulaName.AVERAGE,
180  FormulaName.AVERAGEA,
181  FormulaName.COUNT,
182  FormulaName.COUNTA,
183  FormulaName.COUNTBLANK,
184  FormulaName.MAX,
185  FormulaName.MAXA,
186  FormulaName.MIN,
187  FormulaName.MINA,
188  FormulaName.STDEV,
189  FormulaName.ERRORTYPE,
190  FormulaName.ISBLANK,
191  FormulaName.ISERR,
192  FormulaName.ISERROR,
193  FormulaName.ISLOGICAL,
194  FormulaName.ISNA,
195  FormulaName.ISNONTEXT,
196  FormulaName.ISNUMBER,
197  FormulaName.ISTEXT,
198  FormulaName.N,
199  FormulaName.NA,
200  FormulaName.TYPE,
201  FormulaName.CONCAT,
202  FormulaName.CONCATENATE,
203  FormulaName.LEN,
204  FormulaName.T,
205  FormulaName.TO_PERCENT,
206  FormulaName.TO_TEXT,
207  FormulaName.CHOOSE,
208  FormulaName.AND,
209  FormulaName.EQ,
210  FormulaName.EXACT,
211  FormulaName.FALSE,
212  FormulaName.GT,
213  FormulaName.GTE,
214  FormulaName.IF,
215  FormulaName.IFERROR,
216  FormulaName.IFNA,
217  FormulaName.LT,
218  FormulaName.LTE,
219  FormulaName.NE,
220  FormulaName.NOT,
221  FormulaName.OR,
222  FormulaName.TRUE,
223  FormulaName.XOR,
224  FormulaName.BIN2DEC,
225  FormulaName.BIN2HEX,
226  FormulaName.XOR,
227  FormulaName.UNKNOWN,
228  FormulaName.FLOOR,
229  FormulaName.DELTA,
230]);