The main question I would have in implementing Sheet.findStyle is that if a style (an extended format record) is found in a ColumnInfoRecord, a RowRecord, a merged region record, etc., that all cover the same cell position, then which one takes precedence? The last one created? If so, then how is the creation order determined?
--Michael -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] Sent: Friday, April 27, 2007 10:40 PM To: POI Users List Subject: Re: how to find style in existing workbook for cell position with That said if someone wanted to implement Sheet.findStyle(row,col) that wouldn't be silly. It would be silly to return HSSFCell however. Andrew C. Oliver wrote: > Guys HSSF is a file format API not a spreadsheet DOM even though > usermodel exhibits some of those features to make things easier. It > doesn't make sense for HSSF to map anything to BlankRecord except > BlankRecord. Besides, you want HSSF to suck down MORE memory be > creating MORE objects? Seriously. > > -Andy > > Levi Strope wrote: >> I believe it can be mapped to a BlankRecord because the cell itself >> still contains cell formatting. >> >> >> -----Original Message----- >> From: Haggerty, Michael [mailto:[EMAIL PROTECTED] Sent: >> Friday, April 27, 2007 10:28 AM >> To: poi-user@jakarta.apache.org >> Subject: how to find style in existing workbook for cell position with >> no cell >> >> When a cell position (some row/column position such as 0,0) in an >> existing workbook contains a cell, then its style can be found with >> HSSFCell.getCellStyle(). When a cell position does not contain a cell >> (HSSFRow.getCell() returns null), how can I find the style that would be >> applied by Excel when a value is set into that cell position? >> >> For example, a column can be formatted to have a specified fill color. >> When working in Excel manually, a value typed into a cell in that column >> will retain that fill color. I want to use HSSF to find that column's >> style, create a new style based on it, and make some changes to it. I >> cannot simply create a new style, because the default style does not >> represent the column formatting, and the fill color is lost. >> >> This question was asked by [EMAIL PROTECTED] on 22 Feb 2006 in this >> mailing list, with the subject of "[Q] Excel -> HSFFCell, loosing style" >> but no response was made. >> >> Possible lead: Will the org.apache.poi.hssf.record.BlankRecord class >> help in this case? An extended format record can be retrieved from >> this, but how can a cell position be mapped to a BlankRecord? >> >> Thank you. >> >> --Michael >> >> >> >> --------------------------------------------------------------------- >> 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/ >> > > > --------------------------------------------------------------------- > 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/ --------------------------------------------------------------------- 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/
