1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 24 package org.openoffice.xmerge.converter.xml.sxc.pexcel.records.formula; 25 26 public interface TokenConstants { 27 28 // Unary Operator Tokens 29 public static final int TUPLUS = 0x12; 30 public static final int TUMINUS = 0x13; 31 public static final int TPERCENT = 0x14; 32 public static final int TPAREN = 0x15; 33 // Binary Operator Tokens 34 public static final int TADD = 0x03; 35 public static final int TSUB = 0x04; 36 public static final int TMUL = 0x05; 37 public static final int TDIV = 0x06; 38 public static final int TPOWER = 0x07; 39 public static final int TCONCAT = 0x08; 40 41 //Logical operators 42 public static final int TLESS = 0x09; 43 public static final int TLESSEQUALS = 0x0A; 44 public static final int TEQUALS = 0x0B; 45 public static final int TGTEQUALS = 0x0C; 46 public static final int TGREATER = 0x0D; 47 public static final int TNEQUALS = 0x0E; 48 49 // Function Operator Tokens 50 public static final int TFUNC = 0x41; 51 public static final int TFUNCVAR = 0x42; 52 53 // Constant Operand Tokens 54 public static final int TSTRING = 0x17; 55 public static final int TINT = 0x1E; 56 public static final int TNUM = 0x1F; 57 // Operand Tokens 58 public static final int TREF = 0x44; 59 public static final int TAREA = 0x25; 60 public static final int TNAME = 0x23; 61 public static final int TREF3D = 0x3A; 62 public static final int TAREA3D = 0x3B; 63 64 // 65 public static final int TARGSEP = 0x1001; 66 public static final int TCLOSEPAREN = 0x1002; 67 68 // Variable argument Functions 69 // Math and Trig 70 public static final int TSUM = 0x04; 71 public static final int TPRODUCT = 0xB7; 72 public static final int TSUMIF = 0x0159; 73 public static final int TLOG = 0x6D; 74 public static final int TRUNC = 0xC5; 75 // Financial 76 public static final int TDDB = 0x90; 77 public static final int TFV = 0x39; 78 public static final int TIRR = 0x3E; 79 public static final int TNPER = 0x3A; 80 public static final int TNPV = 0x0B; 81 public static final int TPMT = 0x3B; 82 public static final int TPV = 0x38; 83 public static final int TRATE = 0x3C; 84 // Statistical 85 public static final int TAVERAGE = 0x05; 86 public static final int TCOUNT = 0x00; 87 public static final int TCOUNTA = 0xA9; 88 public static final int TMAX = 0x07; 89 public static final int TMIN = 0x06; 90 public static final int TSTDEV = 0x0C; 91 public static final int TSTDEVP = 0xC1; 92 public static final int TVAR = 0x2E; 93 public static final int TVARP = 0xC2; 94 // Lookup 95 public static final int TCHOOSE = 0x64; 96 public static final int THLOOKUP = 0x65; 97 public static final int TINDEX = 0x1D; 98 public static final int TMATCH = 0x40; 99 public static final int TVLOOKUP = 0x66; 100 // Text 101 public static final int TRIGHT = 0x74; 102 public static final int TSUBSTITUTE = 0x78; 103 public static final int TFIND = 0x7c; 104 public static final int TLEFT = 0x73; 105 // Logical 106 public static final int TAND = 0x24; // 42 107 public static final int TIF = 0x01; // 42 108 public static final int TOR = 0x25; // 42 109 110 // Fixed argument Functions 111 // Math and Trig 112 public static final int TABS = 0x18; 113 public static final int TACOS = 0x63; 114 public static final int TASIN = 0x62; 115 public static final int TATAN = 0x12; 116 public static final int TATAN2 = 0x61; 117 public static final int TCOS = 0x10; 118 public static final int TSIN = 0x0F; 119 120 public static final int TCOUNTIF = 0x015A; 121 public static final int TDEGREES = 0x0157; 122 public static final int TEXP = 0x15; 123 public static final int TFACT = 0xB8; 124 public static final int TINTE = 0x19; 125 public static final int TLN = 0x16; 126 127 public static final int TLOG10 = 0x17; 128 public static final int TMOD = 0x27; 129 public static final int TPI = 0x13; 130 131 public static final int TPOWERF = 0x0151; 132 public static final int TRADIANS = 0x0156; 133 public static final int TRAND = 0x3F; 134 public static final int TROUND = 0x1B; 135 public static final int TSQRT = 0x14; 136 public static final int TTAN = 0x11; 137 138 public static final int TSLN = 0x8E; 139 public static final int TSYD = 0x8F; 140 141 // Date and Time 142 public static final int TDATE = 0x41; 143 public static final int TDATEVALUE = 0x8C; 144 public static final int TDAY = 0x43; 145 public static final int THOUR = 0x47; 146 public static final int TMINUTE = 0x48; 147 public static final int TMONTH = 0x44; 148 public static final int TNOW = 0x4A; 149 public static final int TSECOND = 0x49; 150 public static final int TTIME = 0x42; 151 public static final int TTIMEVALUE = 0x8D; 152 public static final int TYEAR = 0x45; 153 // Statistical 154 public static final int TCOUNTBLANK = 0x015B ; 155 // lookup 156 public static final int TCOLUMNS = 0x4D; 157 public static final int TROWS = 0x4C; 158 // Database 159 public static final int TDAVAERAGE = 0x2A; 160 public static final int TDCOUNT = 0x28; 161 public static final int TDCOUNTA = 0xC7; 162 public static final int TDGET = 0xEB; 163 public static final int TDMAX = 0x2C; 164 public static final int TDMIN = 0x2B; 165 public static final int TDPRODUCT = 0xBD; 166 public static final int TDSTDEV = 0x2D; 167 public static final int TDSTDEVP = 0xC3; 168 public static final int TDSUM = 0x29; 169 public static final int TDVAR = 0x2F; 170 public static final int TDVARP = 0xC4; 171 // Text 172 public static final int TEXACT = 0x75; 173 public static final int TLEN = 0x20; 174 public static final int TLOWER = 0x70; 175 public static final int TMID = 0x1F; // ?????? 176 public static final int TPROPER = 0x72; 177 public static final int TREPLACE = 0x77; 178 public static final int TREPT = 0x1E; 179 public static final int TT = 0x82; 180 public static final int TRIM = 0x76; 181 public static final int TUPPER = 0x71; 182 public static final int TVALUE = 0x21; 183 // Logical 184 public static final int TFALSE = 0x23; 185 public static final int TNOT = 0x26; 186 public static final int TTRUE = 0x22; 187 // Informational 188 public static final int TERRORTYPE = 0x05; 189 public static final int TISBLANK = 0x81; 190 public static final int TISERR = 0x7E; 191 public static final int TISERROR = 0x03; 192 public static final int TISLOGICAL = 0xC6; 193 public static final int TISNA = 0x02; 194 public static final int TISNONTEXT = 0xBE; 195 public static final int TISNUMBER = 0x80; 196 public static final int TISTEXT = 0x7F; 197 public static final int TN = 0x83; 198 public static final int TNA = 0x0A; 199 } 200