Floor

Inheritance: java.lang.Object, com.aspose.cells.Area

public class Floor extends Area

Encapsulates the object that represents the floor of a 3-D chart.

Example

         //Instantiate the License class
         License license = new License();
 
         //Pass only the name of the license file embedded in the assembly
         license.setLicense("Aspose.Cells.lic");
 
         //Instantiate the workbook object
         Workbook workbook = new Workbook();
 
         //Get cells collection
         Cells cells = workbook.getWorksheets().get(0).getCells();
 
         //Put values in cells
         cells.get("A1").putValue(1);
 
         cells.get("A2").putValue(2);
 
         cells.get("A3").putValue(3);
 
         //get charts colletion
         ChartCollection charts = workbook.getWorksheets().get(0).getCharts();
 
         //add a new chart 
         int index = charts.add(ChartType.COLUMN_3_D_STACKED, 5, 0, 15, 5);
 
         //get the newly added chart
         Chart chart = charts.get(index);
 
         //set charts nseries
         chart.getNSeries().add("A1:A3", true);
 
         //Show data labels
         chart.getNSeries().get(0).getDataLabels().setShowValue(true);
 
         //Get chart's floor
         Floor floor = chart.getFloor();
 
         //set floor's border as red
         floor.getBorder().setColor(com.aspose.cells.Color.getRed());
 
         //set fill format
         floor.getFillFormat().setPresetColorGradient(GradientPresetType.CALM_WATER, GradientStyleType.DIAGONAL_DOWN, 2); 
 
         //save the file
         workbook.save("dest.xls");

Methods

MethodDescription
equals(Object arg0)
getBackgroundColor()Gets the background Color of the Area.
getBorder()Gets the border Line.
getClass()
getFillFormat()Represents a getFillFormat() object that contains fill formatting properties for the specified chart or shape.
getForegroundColor()Gets the foreground Color.
getFormatting()Represents the formatting of the area.
getInvertIfNegative()If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.
getTransparency()Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
hashCode()
notify()
notifyAll()
setBackgroundColor(Color value)Sets the background Color of the Area.
setBorder(Line value)Sets the border Line.
setForegroundColor(Color value)Sets the foreground Color.
setFormatting(int value)Represents the formatting of the area.
setInvertIfNegative(boolean value)If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.
setTransparency(double value)Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getBackgroundColor()

public Color getBackgroundColor()

Gets the background Color of the Area.

Returns: Color

getBorder()

public Line getBorder()

Gets the border Line.

Returns: Line

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

getFillFormat()

public FillFormat getFillFormat()

Represents a getFillFormat() object that contains fill formatting properties for the specified chart or shape.

Returns: FillFormat

getForegroundColor()

public Color getForegroundColor()

Gets the foreground Color.

Returns: Color

getFormatting()

public int getFormatting()

Represents the formatting of the area.

See FormattingType.

Returns: int

getInvertIfNegative()

public boolean getInvertIfNegative()

If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.

Example

         //Instantiating a Workbook object
         Workbook workbook = new Workbook();
         //Adding a new worksheet to the Workbook object
         int sheetIndex = workbook.getWorksheets().add();
         //Obtaining the reference of the newly added worksheet by passing its sheet index
         Worksheet worksheet = workbook.getWorksheets().get(sheetIndex);
         //Adding a sample value to "A1" cell
         worksheet.getCells().get("A1").putValue(50);
         //Adding a sample value to "A2" cell
         worksheet.getCells().get("A2").putValue(-100);
         //Adding a sample value to "A3" cell
         worksheet.getCells().get("A3").putValue(150);
         //Adding a chart to the worksheet
         int chartIndex = worksheet.getCharts().add(ChartType.COLUMN, 5, 0, 15, 5);
         //Accessing the instance of the newly added chart
         Chart chart = worksheet.getCharts().get(chartIndex);
         //Adding NSeries (chart data source) to the chart ranging from "A1" cell to "A3"
         chart.getNSeries().add("A1:A3", true);
         chart.getNSeries().get(0).getArea().setInvertIfNegative(true);
         //Setting the foreground color of the 1st NSeries area
         chart.getNSeries().get(0).getArea().setForegroundColor(Color.getRed());
         //Setting the background color of the 1st NSeries area.
         //The displayed area color of second chart point will be the background color.
         chart.getNSeries().get(0).getArea().setBackgroundColor(Color.getYellow());
         //Saving the Excel file
         workbook.save("book1.xls");

Returns: boolean

getTransparency()

public double getTransparency()

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

Returns: double

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

setBackgroundColor(Color value)

public void setBackgroundColor(Color value)

Sets the background Color of the Area.

Parameters:

ParameterTypeDescription
valueColor

setBorder(Line value)

public void setBorder(Line value)

Sets the border Line.

Parameters:

ParameterTypeDescription
valueLine

setForegroundColor(Color value)

public void setForegroundColor(Color value)

Sets the foreground Color.

Parameters:

ParameterTypeDescription
valueColor

setFormatting(int value)

public void setFormatting(int value)

Represents the formatting of the area.

See FormattingType.

Parameters:

ParameterTypeDescription
valueint

setInvertIfNegative(boolean value)

public void setInvertIfNegative(boolean value)

If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.

Parameters:

ParameterTypeDescription
valueboolean

setTransparency(double value)

public void setTransparency(double value)

Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).

Parameters:

ParameterTypeDescription
valuedouble

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int