poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Riley, Cameron" <CRi...@ekmail.com>
Subject IF Formulas and the ',' delimiter
Date Fri, 24 Jan 2003 13:44:51 GMT
The IF formulas in HSSF currently dont write to the "," components of a
formula. A Formula that is set as "IF(A1>8,12,11)" is written by HSSF as
"(A1>8 12 11)". The bytes from an xls file for the sequence after the A1
are;

15 1E 08 00 0D 19 02 07 00 1E 0C 00 19 08 0A 00 1E 0B 00 19 08 03

The where the third byte is 08 is 8 in the formula, 0D is the > and  0C is
12 and 0B is 11. The sequence to the 12 is;

  19 02 07 00 1E 0C 00 
 
where 07 appears to be the length and 1E the token identifier 00 0C or 12.
The sequence to 11 is;

  19 08 0A 00 1E 0B 00 19 08 03

where 0A appears to be the length and 1E the token identifier for 00 OB or
11. There are two sequences though;

  19 02 for the first comma 
  19 08 for the second comma 
  19 08 to end the IF statement. 

If anyone has mroe insight into how the ',' in an IF statement work I would
be interested.



Cameron Riley 


Mime
View raw message