poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <avik.sengu...@itellix.com>
Subject Re: Difference between an "area ref" and a "mem area ref"
Date Wed, 12 Jul 2006 20:26:14 GMT
as I'm sure you've guessed, nobody here knows the answer :(

If excel creates that, the best we can do is implement it in read. For 
writing, i suppose we create an area ref when such a formula is created by 
POI? And if excel reads that fine, I think we are ok. There are various 
places where excel creates certain optimisations while writing, but is 
perfectly happy to read other stuff. 


On Tuesday 11 July 2006 07:43, Daniel Noll wrote:
> Hi.
> As the subject suggests, I'm confused.  What is the actual difference
> between an "area ref" (Ptg 0x25) and a "mem area ref" (Ptg 0x26)?
> I've noticed that for example, if I create a formula which has a union
> of two areas, that uses Ptg 0x25.  However, if I create a formula which
> has an intersection of two areas, that uses Ptg 0x26 instead.  (However,
> POI doesn't currently implement 0x26, so it makes the entire document
> break.)
> Daniel

To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

View raw message