| 4 | < *Koptekst 3L *OpsomtekenO Swiss h 3 r h 3 r e f d e f L d . A W[Sheet Formula List]Sheet Formula ListAll used formulas are put into this section, and referenced when used. Data Description B Always 02 ? XListE List of Sheet FormulasWhen referenced, the formula number is counted from the tail of the list: the last entry is referenced as 00, the butlast as 02 etc. (X-numbered?).[Sheet Formula][Sheet Formulas]Sheet FormulaA formula is encoded as an SListB. The formula itself is layed out in memory in Reverse Polish Notation (RPN), and consists of Sheet Formula Elements. Formula Lay-out 1-5 1 5 - 1+23 1 2 3 + sin(103)-4 10 3 sin 4 - sum(1,2,3) sum 1 2 3 sum[Sheet Formula Element][Sheet Formula Elements]Sheet Formula ElementsEach formula element is identified by a marker, which is optionally followed by more data (for example, an integer is layed out as the marker 20 followed by the four bytes of a SInt).There are a few special markers. Each formula ends with marker 15. Markers 2A and 2B are used to separate the arguments of the var-arg operators (see below).Marker Data following Args Description 01 2 operator < (less than)02 2 operator <= (less than or equals)03 2 operator > (greater than)04 2 operator >= (greater than or equals)05 2 operator <> (not equals)06 2 operator = (equals)07 2 operator + (addition)08 2 operator - (subtraction)09 2 operator * (multiplication)0A 2 operator / (division)0B 2 operator ^ (power)0C 1 operator + (positive prefix)0D 1 operator - (negative prefix)0E 1 operator NOT0F 2 operator AND10 2 operator OR11 2 operator & (string concatenate)12 1 brackets () 131415 0 end-of-formula161718191A1B1C1D1E1F Float 0 double precision floating point number (8 bytes)20 SInt 0 signed integer number (4 bytes)2122232425 Sheet Variable Reference 0 named variable26 BListB 0 text string27 Sheet Cell Reference 0 single cell reference28 Sheet Cell Block 0 cell block reference29 Sheet Cell Block 0 same as 28, but appears within vararg functions2A 0 operand separator within vararg functions2B 0 vararg operand end marker2C 2D2E2F30313233 0 FALSE34 3 IF35 0 TRUE36 2 CELL37 1 ERROR.TYPE38 1 ISBLANK39 1 ISERR3A 1 ISERROR3B 1 ISLOGICAL3C 1 ISNA3D 1 ISNONTEXT3E 1 ISNUMBER3F 1 ISTEXT40 1 N41 1 TYPE42 2 ADDRESS43 1 COLUMN44 1 COLUMNS45 3 HLOOKUP46 3 INDEX47 1 INDIRECT48 3 LOOKUP49 3 OFFSET4A 1 ROW4B 1 ROWS4C 3 VLOOKUP4D 1 CHAR4E 1 CODE4F 2 EXACT50 3 FIND51 2 LEFT52 1 LEN53 1 LOWER54 3 MID55 1 PROPER56 4 REPLACE57 2 REPT58 2 RIGHT59 2 STRING5A 1 T5B 1 TRIM5C 1 UPPER5D 1 VALUE5E 3 DATE5F 1 DATEVALUE60 1 DAY61 1 HOUR62 1 MINUTE63 1 MONTH64 0 NOW65 1 SECOND66 0 TODAY67 3 TIME68 1 TIMEVALUE69 1 YEAR6A 1 ABS6B 1 ACOS6C 1 ASIN6D 1 ATAN6E 2 ATAN26F 1 COS70 1 DEGREES71 1 EXP72 1 FACT73 1 INT74 1 LN75 1 LOG1076 2 MOD77 0 PI78 1 RADIANS79 0 RAND7A 2 ROUND7B 1 SIGN7C 1 SIN7D 1 SQRT7E 2 SUMPRODUCT7F 1 TAN80 1 TRUNC81 3 CTERM82 4 DDB83 3 FV84 2 IRR85 2 NPV86 3 PMT87 3 PV88 3 RATE89 3 SLN8A 4 SYD8B 3 TERM8C 2 COMBIN8D 2 PERMUT8E Sheet Formula Varargs 0 AVERAGE8F Sheet Formula Varargs 0 CHOOSE90 Sheet Formula Varargs 0 COUNT91 Sheet Formula Varargs 0 COUNTA92 Sheet Formula Varargs 0 COUNTBLANK93 Sheet Formula Varargs 0 MAX94 Sheet Formula Varargs 0 MIN95 Sheet Formula Varargs 0 PRODUCT96 Sheet Formula Varargs 0 STDEVP97 Sheet Formula Varargs 0 STDEV98 Sheet Formula Varargs 0 SUM99 Sheet Formula Varargs 0 SUMSQ9A Sheet Formula Varargs 0 VARP9B Sheet Formula Varargs 0 VARIn the above table, args is the number of elements 'popped' from the stack before the result is 'pushed'. As you can see, funtions with a variable number of arguments are handled specially, and never pop previous values.Sheet Formula VarargsSheet Formula VarargsSome operators have a variable number of operands.Each operand in its turn consists of Sheet Formula Elements . The encoding is quite different from that used for normal operators. After the operator marker, the operands follow as formulas (without the initial length encoding and without the final 15 marker), separated by the 2A marker. The last operand is followed by the 2B marker, and after this the operator marker is repeated, followed by a word with the number of parameters. Schematically: Size Description B Operator marker Operand 1 (Formula Elements) B 2A marker Operand 2 (Formula Elements) .... B 2B marker B Operator marker W Number of operands "Times New Roman " Courier New " Courier New "Times New Roman " Courier New 0 * % 0 ( 3 ' " $ ' * $ ! + + . D 3 0 5 0 K 8 ( ' & % & * # # ' & % # % $ # # # ! @ "Arial "Times New Roman " Courier New " Courier New " Courier New "Times New Roman "Times New Roman " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New "Word.app C " y = |
4 | < *Koptekst 3L *OpsomtekenO Swiss h 3 r h 3 r e f d e f L d . A X[Sheet Formula List]Sheet Formula ListAll used formulas are put into this section, and referenced when used. Data Description B Always 02 ? XListE List of Sheet FormulasWhen referenced, the formula number is counted from the tail of the list: the last entry is referenced as 00, the butlast as 02 etc. (X-numbered?).[Sheet Formula][Sheet Formulas]Sheet FormulaA formula is encoded as an SListB. The formula itself is layed out in memory in Reverse Polish Notation (RPN), and consists of Sheet Formula Elements. Formula Lay-out 1-5 1 5 - 1+23 1 2 3 + sin(103)-4 10 3 sin 4 - sum(1,2,3) sum 1 2 3 sum[Sheet Formula Element][Sheet Formula Elements]Sheet Formula ElementsEach formula element is identified by a marker, which is optionally followed by more data (for example, an integer is layed out as the marker 20 followed by the four bytes of a SInt).There are a few special markers. Each formula ends with marker 15. Markers 2A and 2B are used to separate the arguments of the var-arg operators (see below).Marker Data following Args Description 01 2 operator < (less than)02 2 operator <= (less than or equals)03 2 operator > (greater than)04 2 operator >= (greater than or equals)05 2 operator <> (not equals)06 2 operator = (equals)07 2 operator + (addition)08 2 operator - (subtraction)09 2 operator * (multiplication)0A 2 operator / (division)0B 2 operator ^ (power)0C 1 operator + (positive prefix)0D 1 operator - (negative prefix)0E 1 operator NOT0F 2 operator AND10 2 operator OR11 2 operator & (string concatenate)12 1 brackets () 131415 0 end-of-formula161718191A1B1C1D1E1F Float 0 double precision floating point number (8 bytes)20 SInt 0 signed integer number (4 bytes)2122232425 Sheet Variable Reference 0 named variable26 BListB 0 text string27 Sheet Cell Reference 0 single cell reference28 Sheet Cell Block 0 cell block reference29 Sheet Cell Block 0 same as 28, but appears within vararg functions2A 0 operand separator within vararg functions2B 0 vararg operand end marker2C 2D2E2F30313233 0 FALSE34 3 IF35 0 TRUE36 2 CELL37 1 ERROR.TYPE38 1 ISBLANK39 1 ISERR3A 1 ISERROR3B 1 ISLOGICAL3C 1 ISNA3D 1 ISNONTEXT3E 1 ISNUMBER3F 1 ISTEXT40 1 N41 1 TYPE42 2 ADDRESS43 1 COLUMN44 1 COLUMNS45 3 HLOOKUP46 3 INDEX47 1 INDIRECT48 3 LOOKUP49 3 OFFSET4A 1 ROW4B 1 ROWS4C 3 VLOOKUP4D 1 CHAR4E 1 CODE4F 2 EXACT50 3 FIND51 2 LEFT52 1 LEN53 1 LOWER54 3 MID55 1 PROPER56 4 REPLACE57 2 REPT58 2 RIGHT59 2 STRING5A 1 T5B 1 TRIM5C 1 UPPER5D 1 VALUE5E 3 DATE5F 1 DATEVALUE60 1 DAY61 1 HOUR62 1 MINUTE63 1 MONTH64 0 NOW65 1 SECOND66 0 TODAY67 3 TIME68 1 TIMEVALUE69 1 YEAR6A 1 ABS6B 1 ACOS6C 1 ASIN6D 1 ATAN6E 2 ATAN26F 1 COS70 1 DEGREES71 1 EXP72 1 FACT73 1 INT74 1 LN75 1 LOG1076 2 MOD77 0 PI78 1 RADIANS79 0 RAND7A 2 ROUND7B 1 SIGN7C 1 SIN7D 1 SQRT7E 2 SUMPRODUCT7F 1 TAN80 1 TRUNC81 3 CTERM82 4 DDB83 3 FV84 2 IRR85 2 NPV86 3 PMT87 3 PV88 3 RATE89 3 SLN8A 4 SYD8B 3 TERM8C 2 COMBIN8D 2 PERMUT8E Sheet Formula Varargs 0 AVERAGE8F Sheet Formula Varargs 0 CHOOSE90 Sheet Formula Varargs 0 COUNT91 Sheet Formula Varargs 0 COUNTA92 Sheet Formula Varargs 0 COUNTBLANK93 Sheet Formula Varargs 0 MAX94 Sheet Formula Varargs 0 MIN95 Sheet Formula Varargs 0 PRODUCT96 Sheet Formula Varargs 0 STDEVP97 Sheet Formula Varargs 0 STDEV98 Sheet Formula Varargs 0 SUM99 Sheet Formula Varargs 0 SUMSQ9A Sheet Formula Varargs 0 VARP9B Sheet Formula Varargs 0 VARIn the above table, args is the number of elements 'popped' from the stack before the result is 'pushed'. As you can see, funtions with a variable number of arguments are handled specially, and never pop previous values.[Sheet Formula Varargs]Sheet Formula VarargsSome operators have a variable number of operands.Each operand in its turn consists of Sheet Formula Elements . The encoding is quite different from that used for normal operators. After the operator marker, the operands follow as formulas (without the initial length encoding and without the final 15 marker), separated by the 2A marker. The last operand is followed by the 2B marker, and after this the operator marker is repeated, followed by a word with the number of parameters. Schematically: Size Description B Operator marker Operand 1 (Sheet Formula Elements) B 2A marker Operand 2 (Sheet Formula Elements) .... B 2B marker B Operator marker W Number of operands "Times New Roman " Courier New " Courier New "Times New Roman " Courier New 0 * % 0 ( 3 ' " $ ' * $ ! + + . D 3 . 5 0 K 8 ( ' & % & * # # ' & % # % $ # ) ) ! @ "Arial "Times New Roman " Courier New " Courier New " Courier New "Times New Roman "Times New Roman " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New " Courier New "Word.app C " y G |
Parent Directory
| 
Revision Log
| 
Patch