Peter, The expected behaviour should be that a cell retains the style of the column unless a style is explicitly set. Currently, that is not the case hence possibly a bug (created issue# 35799).
I have a tentative patch (not thoroughly tested) that works so if you are comfortable with building from source and applying a local cvs patch, I can send you the patch file. Regards, ~ amol > -----Original Message----- > From: Peter Dow (DSS) [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 19, 2005 2:11 PM > To: POI Users List > Subject: RE: ColumnInfo records > > > Hi Andy, > > Btw, thanks for all the work you and the other people have > done on this > project! It's a lot of fun using it. > > My intent was to read (only) the ColumnInfoRecords and save the > HSSFCellStyle objects for each column when I initially open > the worksheet. > Later I'd use that information to apply the cell style to a > newly created > HSSFCell object. I assumed I'd need the number of ColumnInfo > records, but > it looks like with the eventmodel I just register a listener for the > ColumnInfo record only (recordsid = 0x7d, right?) and let the > event factory > call me whenever it reads a ColumnInfo record in the stream. > > You are correct that RPG has no concept of objects, but I am > able to perform > methods in Java classes and receive values from them; what > I'm not certain > of is registering a listener. You're probably right in > saying that I'll > have to have some Java wrapper that acts as the listener and > somehow gets > the data back to my RPG program. > > This has me curious though -- how does Excel do this? When an empty > worksheet has column formatting applied to it, and I put a > value in a cell > in one of those columns, the formatting is applied. Is Excel doing > something similar do you suppose? It would be nice if the > createCell method > did this for me. > > Peter Dow > Dow Software Services, Inc. > www.dowsoftware.com > 909 793-9050 voice > 909 793-4480 fax > > -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > > You can't get the ColumnInfoRecordsAggregate. You get the > ColumnInfoRecord. However you shouldn't be programming at this level > generally for non-read only uses. Meaning just use > "usermodel" for all > of your read/write apps and only use the event stuff for read only and > don't worry about the record, eventmodel, etc packages (stay > usermodel). > > I have no knowledge of RPG (came from C and assembler), > however its just > a callback w/interface. Not sure how you call to RPG from > Java or vice > versa, and I imagine RPG has no concept of "objects" and > "interfaces" so > I'd imagine you'd create a small wrapper in Java that called your RPG > program passing the value back. > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: > 7/19/2005 > > > > --------------------------------------------------------------------- > 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/ > --------------------------------------------------------------------- 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/
