jxl.write
Class WritableCellFormat

java.lang.Object
  |
  +--jxl.biff.RecordData
        |
        +--jxl.biff.WritableRecordData
              |
              +--jxl.biff.XFRecord
                    |
                    +--jxl.write.biff.CellXFRecord
                          |
                          +--jxl.write.WritableCellFormat
All Implemented Interfaces:
ByteData, CellFormat

public class WritableCellFormat
extends CellXFRecord

A user specified cell format, which may be reused across many cells. The constructors takes parameters, such as font details and the numerical date formats, which specify to Excel how cells with this format should be displayed. Once a CellFormat has been added to a Cell which has been added to a sheet, then the CellFormat becomes immutable (to prevent unforeseen effects on other cells which share the same format). Attempts to call the various set... functions on a WritableCellFormat after this time will result in a runtime exception.


Inner classes inherited from class jxl.biff.XFRecord
XFRecord.BiffType
 
Fields inherited from class jxl.biff.XFRecord
align, backgroundColour, biff7, biff8, biffType, bottomBorder, copied, date, dateFormat, dateFormats, excelFormat, font, fontIndex, format, formatIndex, formatInfoInitialized, formattingRecords, hidden, initialized, javaDateFormats, javaNumberFormats, leftBorder, locked, number, numberFormat, numberFormats, options, orientation, pattern, read, rightBorder, topBorder, valign, wrap, xfIndex
 
Fields inherited from class jxl.biff.RecordData
code, record
 
Constructor Summary
WritableCellFormat()
          A default constructor, which uses the default font and format.
WritableCellFormat(DisplayFormat format)
          A constructor which specifies a date/number format for Cells which use this format object
WritableCellFormat(WritableFont font)
          A CellFormat which specifies the font for cells with this format
WritableCellFormat(WritableFont font, DisplayFormat format)
          A constructor which specifies the font and date/number format for cells which wish to use this format
 
Method Summary
 void setAlignment(Alignment a)
          Sets the horizontal alignment for this format
 void setBackground(Colour c)
          Sets the background colour for this cell format
 void setBackground(Colour c, Pattern p)
          Sets the background colour and pattern for this cell format
 void setBorder(Border b, BorderLineStyle ls)
          Sets the specified border for this format
 void setOrientation(Orientation o)
          Sets the text orientation for this format
 void setVerticalAlignment(VerticalAlignment va)
          Sets the vertical alignment for this format
 void setWrap(boolean w)
          Sets the wrap indicator for this format.
 
Methods inherited from class jxl.write.biff.CellXFRecord
getData
 
Methods inherited from class jxl.biff.XFRecord
equals, getAlignment, getBackgroundColour, getBorder, getDateFormat, getFont, getFormat, getFormatRecord, getHidden, getLocked, getNumberFormat, getOrientation, getPattern, getVerticalAlignment, getWrap, getXFIndex, hasBorders, initialize, initializeFormatInformation, isDate, isInitialized, isNumber, isRead, setLocked, setXFAlignment, setXFBackground, setXFBorder, setXFCellOptions, setXFOrientation, setXFVerticalAlignment, setXFWrap, uninitialize
 
Methods inherited from class jxl.biff.WritableRecordData
getBytes
 
Methods inherited from class jxl.biff.RecordData
getCode, getRecord
 
Methods inherited from class java.lang.Object
, clone, finalize, getClass, hashCode, notify, notifyAll, registerNatives, toString, wait, wait, wait
 

Constructor Detail

WritableCellFormat

public WritableCellFormat()
A default constructor, which uses the default font and format. This constructor should be used in conjunction with the more advanced two-phase methods setAlignment, setBorder etc.

WritableCellFormat

public WritableCellFormat(WritableFont font)
A CellFormat which specifies the font for cells with this format
Parameters:
font - the font

WritableCellFormat

public WritableCellFormat(DisplayFormat format)
A constructor which specifies a date/number format for Cells which use this format object
Parameters:
format - the format

WritableCellFormat

public WritableCellFormat(WritableFont font,
                          DisplayFormat format)
A constructor which specifies the font and date/number format for cells which wish to use this format
Parameters:
font - the font
format - the date/number format
Method Detail

setAlignment

public void setAlignment(Alignment a)
                  throws WriteException
Sets the horizontal alignment for this format
Overrides:
setAlignment in class CellXFRecord
Parameters:
a -  
Throws:
WriteException -  

setVerticalAlignment

public void setVerticalAlignment(VerticalAlignment va)
                          throws WriteException
Sets the vertical alignment for this format
Overrides:
setVerticalAlignment in class CellXFRecord
Parameters:
va -  
Throws:
WriteException -  

setOrientation

public void setOrientation(Orientation o)
                    throws WriteException
Sets the text orientation for this format
Overrides:
setOrientation in class CellXFRecord
Parameters:
o -  
Throws:
WriteException -  

setWrap

public void setWrap(boolean w)
             throws WriteException
Sets the wrap indicator for this format. If the wrap is set to TRUE, then Excel will wrap data in cells with this format so that it fits within the cell boundaries
Overrides:
setWrap in class CellXFRecord
Parameters:
w -  
Throws:
WriteException -  

setBorder

public void setBorder(Border b,
                      BorderLineStyle ls)
               throws WriteException
Sets the specified border for this format
Overrides:
setBorder in class CellXFRecord
Parameters:
b -  
ls -  
Throws:
WriteException -  

setBackground

public void setBackground(Colour c)
                   throws WriteException
Sets the background colour for this cell format
Parameters:
c -  
Throws:
WriteException -  

setBackground

public void setBackground(Colour c,
                          Pattern p)
                   throws WriteException
Sets the background colour and pattern for this cell format
Overrides:
setBackground in class CellXFRecord
Parameters:
c - the colour
p - the pattern
Throws:
WriteException -