Actually, HSSF should write it back to the spreadsheet unchanged. Basically what he'll do is say "here is a record I don't know anything about. I'll leave it where it is." and rewrite it. Now if the order matters a lot it may get hosed, but in general HSSF writes what it doesn't understand relatively near where it found it.
Anyhow, I'll take a look at this once I'm done with straight formulas. You might in the meantime take a look at the OpenOffice.org sources and gnumeric sources (www.gnome.org/gnumeric) and see if those can shed some light on it. (I frequently find out info there myself). Libin Roman wrote: >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 >> > >
