Hi Oliver,
I have played around this sheet for 2 days and found :
There is are record which sid is 4BCh. I haven't found any documentation
about him. I called him Formula Drag Record.
You can see him when you create a formula and drags it on the spreadsheet.
This record will be placed just after the formula record which was the
source of the drag operation.
For now POI doesn't know to read and to deal with it , so POI doesn't write
it back to the xls file, which leads to a broken formula expression in the
spreadsheet (the drag) :)))
P.S You can create the spreadsheet by your self , only that you have to drag
the formula :)))
Libin Roman
----- Original Message -----
From: "Andrew C. Oliver" <[EMAIL PROTECTED]>
To: "POI Development" <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 2:20 AM
Subject: Re: Formula Problem
> How odd. Can you send me a sheet with that? I'd like to play with it.
>
> On Mon, 2002-04-29 at 07:14, Libin Roman wrote:
> > Hi,
> >
> > I found some interesting behavior of formula and string record.
> > Maybe someone can help me :)) I hope.
> >
> > As you know if formula returns a string value, we got a string record
after the formula string. I found that in some cases the string record isn't
there,
> > there a record 4BCh which acts like a string record with rich text
format.
> >
> > Have any one have a clue ?
> >
> >
> > Waiting for help :))
> > Libin Roman
> --
> http://www.superlinksoftware.com
> http://jakarta.apache.org/poi - port of Excel/Word/OLE 2 Compound
> Document
> format to java
> http://developer.java.sun.com/developer/bugParade/bugs/4487555.html
> - fix java generics!
> The avalanche has already started. It is too late for the pebbles to
> vote.
> -Ambassador Kosh
>
