com.aspose.cells
Class Font

java.lang.Object
    extended by com.aspose.cells.Font

public class Font 
extends java.lang.Object

Encapsulates the font object used in a spreadsheet.

Example:

//Instantiating a Workbook object
Workbook workbook = new Workbook();

//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.getWorksheets().get(0);

//Accessing the "A1" cell from the worksheet
Cell cell = worksheet.getCells().get("A1");

//Adding some value to the "A1" cell
cell.putValue("Hello Aspose!");

Font font = cell.getStyle().getFont();

//Setting the font name to "Times New Roman"
font.setName("Times New Roman");

//Setting font size to 14
font.setSize(14);

//setting font color as Red
font.setColor(com.aspose.cells.Color.getRed());

//Saving the Excel file
workbook.save("d:\\dest.xls");

Property Getters/Setters Summary
intgetCapsType()
voidsetCapsType(int value)
           Gets and sets the text caps type. The value of the property is TextCapsType integer constant.
com.aspose.cells.ColorgetColor()
voidsetColor(com.aspose.cells.Color value)
           Gets or sets the com.aspose.cells.Color of the font.
doublegetDoubleSize()
voidsetDoubleSize(double value)
           Gets and sets the double size of the font.
booleanisBold()
voidsetBold(boolean value)
           Gets or sets a value indicating whether the font is bold.
booleanisItalic()
voidsetItalic(boolean value)
           Gets or sets a value indicating whether the font is italic.
booleanisNormalizeHeights()
voidsetNormalizeHeights(boolean value)
           Indicates whether the normalization of height that is to be applied to the text run.
booleanisStrikeout()
voidsetStrikeout(boolean value)
           Gets or sets a value indicating whether the font is single strikeout.
booleanisSubscript()
voidsetSubscript(boolean value)
           Gets or sets a value indicating whether the font is subscript.
booleanisSuperscript()
voidsetSuperscript(boolean value)
           Gets or sets a value indicating whether the font is super script.
java.lang.StringgetName()
voidsetName(java.lang.String value)
           Gets or sets the name of the Font.
doublegetScriptOffset()
voidsetScriptOffset(double value)
           Gets and sets the sript offset,in unit of percentage
intgetSize()
voidsetSize(int value)
           Gets or sets the size of the font.
intgetStrikeType()
voidsetStrikeType(int value)
           Gets the strike type of the text. The value of the property is TextStrikeType integer constant.
ThemeColorgetThemeColor()
voidsetThemeColor(ThemeColor value)
           Gets and sets the theme color.
intgetUnderline()
voidsetUnderline(int value)
           Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.
 
Method Summary
booleanequals(Font font)
           Checks if two fonts are equals.
java.lang.StringtoString()
           Returns a string represents the current Cell object.
 

Property Getters/Setters Detail

isItalic/setItalic

public boolean isItalic() / public void setItalic(boolean value)
Gets or sets a value indicating whether the font is italic.

isBold/setBold

public boolean isBold() / public void setBold(boolean value)
Gets or sets a value indicating whether the font is bold.

getCapsType/setCapsType

public int getCapsType() / public void setCapsType(int value)
Gets and sets the text caps type. The value of the property is TextCapsType integer constant.

getStrikeType/setStrikeType

public int getStrikeType() / public void setStrikeType(int value)
Gets the strike type of the text. The value of the property is TextStrikeType integer constant.

isStrikeout/setStrikeout

public boolean isStrikeout() / public void setStrikeout(boolean value)
Gets or sets a value indicating whether the font is single strikeout.

getScriptOffset/setScriptOffset

public double getScriptOffset() / public void setScriptOffset(double value)
Gets and sets the sript offset,in unit of percentage

isSuperscript/setSuperscript

public boolean isSuperscript() / public void setSuperscript(boolean value)
Gets or sets a value indicating whether the font is super script.

isSubscript/setSubscript

public boolean isSubscript() / public void setSubscript(boolean value)
Gets or sets a value indicating whether the font is subscript.

getUnderline/setUnderline

public int getUnderline() / public void setUnderline(int value)
Gets or sets the font underline type. The value of the property is FontUnderlineType integer constant.

getName/setName

public java.lang.String getName() / public void setName(java.lang.String value)
Gets or sets the name of the Font.

Example:

Font font = style.getFont();
font.setName("Times New Roman");

getDoubleSize/setDoubleSize

public double getDoubleSize() / public void setDoubleSize(double value)
Gets and sets the double size of the font.

getSize/setSize

public int getSize() / public void setSize(int value)
Gets or sets the size of the font.

getThemeColor/setThemeColor

public ThemeColor getThemeColor() / public void setThemeColor(ThemeColor value)
Gets and sets the theme color. If the font color is not a theme color, NULL will be returned.

getColor/setColor

public com.aspose.cells.Color getColor() / public void setColor(com.aspose.cells.Color value)
Gets or sets the com.aspose.cells.Color of the font.

isNormalizeHeights/setNormalizeHeights

public boolean isNormalizeHeights() / public void setNormalizeHeights(boolean value)
Indicates whether the normalization of height that is to be applied to the text run.

Method Detail

equals

public boolean equals(Font font)
Checks if two fonts are equals.
Parameters:
font - Compared font object.
Returns:
True if equal to the compared font object.

toString

public java.lang.String toString()
Returns a string represents the current Cell object.
Returns:

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.