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.
Regards - Avik 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
