poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: IF Formulas and the ',' delimiter
Date Fri, 24 Jan 2003 09:33:49 GMT
The problem is that the Formula parser is suffering from a leaky 
abstraction or more accurately my inaccurate assumption that 1 token -> 
one PTG and the such.  Here is my insight as to how to correct the problem

http://nagoya.apache.org/wiki/apachewiki.cgi?RefactorAndCompleteFormulaParsing

-Andy

Riley, Cameron wrote:

>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 
>
>
>--
>To unsubscribe, e-mail:   <mailto:poi-dev-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:poi-dev-help@jakarta.apache.org>
>
>
>  
>




Mime
View raw message