com.aspose.cells.Walls.html Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of aspose-cells Show documentation

Aspose.Cells for Java

There is a newer version: 23.1






Walls





com.aspose.cells

Class Walls
java.lang.Object
  Area
      Floor
          com.aspose.cells.Walls



public class Walls extends Floor





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












Property Getters/Setters Summary



com.aspose.cells.Color getBackgroundColor() → inherited from Area
void setBackgroundColor(com.aspose.cells.Color) 
          
            Gets or sets the background com.aspose.cells.Color of the Area.
            



Line getBorder() → inherited from Floor
void setBorder(Line) 
          
            Gets or sets the border Line.
            



int getCenterX() 
          
            Gets the x coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



int getCenterXPx() 
          
            Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
            



int getCenterY() 
          
            Gets the y coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's height after calls Chart.Calculate() method.
            



int getCenterYPx() 
          
            Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
            



int getDepth() 
          
            Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



int getDepthPx() 
          
            Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
            



FillFormat getFillFormat() → inherited from Area
          
            Represents a  object that contains fill formatting properties for the specified chart or shape.
            



com.aspose.cells.Color getForegroundColor() → inherited from Area
void setForegroundColor(com.aspose.cells.Color) 
          
            Gets or sets the foreground com.aspose.cells.Color.
            



int getFormatting() → inherited from Area
void setFormatting(int) 
          
            Represents the formatting of the area.
            The value of the property is FormattingType integer constant.



int getHeight() 
          
            Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method.
            



int getHeightPx() 
          
            Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
            



boolean getInvertIfNegative() → inherited from Area
void setInvertIfNegative(boolean) 
          
            If the property is true and the value of chart point is a negative number,
            the foreground color and background color will be exchanged.
            



double getTransparency() → inherited from Area
void setTransparency(double) 
          
            Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
            



int getWidth() 
          
            Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



int getWidthPx() 
          
            Gets the width of left to right in units of pixels after calls Chart.Calculate() method.
            

 







Method Summary




int getCubePointCount() 
          
            Gets the number of cube points after calls Chart.Calculate() method.
            




float getCubePointXPx(int index) 
          
            Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
            The number of apex points of walls cube is eight
            




float getCubePointYPx(int index) 
          
            Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
            The number of apex points of walls cube is eight.
            




boolean isAuto() → inherited from Area

          




boolean isVisible() → inherited from Area

          




void setAuto(boolean isAuto) → inherited from Area

          

 








Property Getters/Setters Detail



getCenterX 
public int getCenterX()


            Gets the x coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



getCenterY 
public int getCenterY()


            Gets the y coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's height after calls Chart.Calculate() method.
            



getWidth 
public int getWidth()


            Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



getDepth 
public int getDepth()


            Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.
            



getHeight 
public int getHeight()


            Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method.
            



getCenterXPx 
public int getCenterXPx()


            Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
            



getCenterYPx 
public int getCenterYPx()


            Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
            



getWidthPx 
public int getWidthPx()


            Gets the width of left to right in units of pixels after calls Chart.Calculate() method.
            



getDepthPx 
public int getDepthPx()


            Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
            



getHeightPx 
public int getHeightPx()


            Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
            



getBorder/setBorder → inherited from Floor

public Line getBorder() / public void setBorder(Line value)


            Gets or sets the border Line.
            



setBorder → inherited from Floor

public void setBorder(Line value)


            Gets or sets the border Line.
            




getBackgroundColor/setBackgroundColor → inherited from Area

public com.aspose.cells.Color getBackgroundColor() / public void setBackgroundColor(com.aspose.cells.Color value)


            Gets or sets the background com.aspose.cells.Color of the Area.
            



setBackgroundColor → inherited from Area

public void setBackgroundColor(com.aspose.cells.Color value)


            Gets or sets the background com.aspose.cells.Color of the Area.
            




getForegroundColor/setForegroundColor → inherited from Area

public com.aspose.cells.Color getForegroundColor() / public void setForegroundColor(com.aspose.cells.Color value)


            Gets or sets the foreground com.aspose.cells.Color.
            



setForegroundColor → inherited from Area

public void setForegroundColor(com.aspose.cells.Color value)


            Gets or sets the foreground com.aspose.cells.Color.
            




getFormatting/setFormatting → inherited from Area

public int getFormatting() / public void setFormatting(int value)


            Represents the formatting of the area.
            The value of the property is FormattingType integer constant.



setFormatting → inherited from Area

public void setFormatting(int value)


            Represents the formatting of the area.
            The value of the property is FormattingType integer constant.




getInvertIfNegative/setInvertIfNegative → inherited from Area

public boolean getInvertIfNegative() / 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.
            
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());



setInvertIfNegative → inherited from Area

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.
            
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());




getFillFormat → inherited from Area

public FillFormat getFillFormat()


            Represents a  object that contains fill formatting properties for the specified chart or shape.
            
See Also:
FillFormat



getTransparency/setTransparency → inherited from Area

public double getTransparency() / 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).
            



setTransparency → inherited from Area

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).
            








Method Detail



getCubePointCount 
public int getCubePointCount()

            Gets the number of cube points after calls Chart.Calculate() method.
            




getCubePointXPx 
public float getCubePointXPx(int index)

            Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
            The number of apex points of walls cube is eight
            




getCubePointYPx 
public float getCubePointYPx(int index)

            Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method.
            The number of apex points of walls cube is eight.
            




isAuto → inherited from Area

public boolean isAuto()





isVisible → inherited from Area

public boolean isVisible()





setAuto → inherited from Area

public void setAuto(boolean isAuto)





See Also:


          Aspose.Cells Documentation - the home page for the Aspose.Cells Product Documentation.

          Aspose.Cells Support Forum - our preferred method of support.
We guarantee a prompt response to any inquiry!
© 2003-2022 Aspose Pty Ltd. All rights reserved.

Property Getters/Setters Summary
`com.aspose.cells.Color`	`getBackgroundColor()`	`→ inherited from Area`
`void`	`setBackgroundColor(com.aspose.cells.Color)`
	Gets or sets the background `com.aspose.cells.Color` of the Area.
`Line`	`getBorder()`	`→ inherited from Floor`
`void`	`setBorder(Line)`
	Gets or sets the border Line.
`int`	`getCenterX()`
	Gets the x coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's width after calls Chart.Calculate() method.
`int`	`getCenterXPx()`
	Gets the x coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
`int`	`getCenterY()`
	Gets the y coordinate of the left-bottom corner of Wall center in units of 1/4000 of chart's height after calls Chart.Calculate() method.
`int`	`getCenterYPx()`
	Gets the y coordinate of the left-bottom corner of Wall center in units of pixels after calls Chart.Calculate() method.
`int`	`getDepth()`
	Gets the depth front to back in units of 1/4000 of chart's width after calls Chart.Calculate() method.
`int`	`getDepthPx()`
	Gets the depth front to back in units of pixels after calls Chart.Calculate() method.
`FillFormat`	`getFillFormat()`	`→ inherited from Area`
	Represents a object that contains fill formatting properties for the specified chart or shape.
`com.aspose.cells.Color`	`getForegroundColor()`	`→ inherited from Area`
`void`	`setForegroundColor(com.aspose.cells.Color)`
	Gets or sets the foreground `com.aspose.cells.Color`.
`int`	`getFormatting()`	`→ inherited from Area`
`void`	`setFormatting(int)`
	Represents the formatting of the area. The value of the property is FormattingType integer constant.
`int`	`getHeight()`
	Gets the height of top to bottom in units of 1/4000 of chart's height after calls Chart.Calculate() method.
`int`	`getHeightPx()`
	Gets the height of top to bottom in units of pixels after calls Chart.Calculate() method.
`boolean`	`getInvertIfNegative()`	`→ inherited from Area`
`void`	`setInvertIfNegative(boolean)`
	If the property is true and the value of chart point is a negative number, the foreground color and background color will be exchanged.
`double`	`getTransparency()`	`→ inherited from Area`
`void`	`setTransparency(double)`
	Returns or sets the degree of transparency of the area as a value from 0.0 (opaque) through 1.0 (clear).
`int`	`getWidth()`
	Gets the width of left to right in units of 1/4000 of chart's width after calls Chart.Calculate() method.
`int`	`getWidthPx()`
	Gets the width of left to right in units of pixels after calls Chart.Calculate() method.

Method Summary
`int`	`getCubePointCount()`
`int`	Gets the number of cube points after calls Chart.Calculate() method.
`float`	`getCubePointXPx(int index)`
`float`	Gets x-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight
`float`	`getCubePointYPx(int index)`
`float`	Gets y-coordinate of the apex point of walls cube after calls Chart.Calculate() method. The number of apex points of walls cube is eight.
`boolean`	`isAuto()`	`→ inherited from Area`
`boolean`
`boolean`	`isVisible()`	`→ inherited from Area`
`boolean`
`void`	`setAuto(boolean isAuto)`	`→ inherited from Area`
`void`

getBorder/setBorder	`→ inherited from Floor`
public Line getBorder() / public void setBorder(Line value)

setBorder	`→ inherited from Floor`
public void setBorder(Line value)

getBackgroundColor/setBackgroundColor	`→ inherited from Area`
public com.aspose.cells.Color getBackgroundColor() / public void setBackgroundColor(com.aspose.cells.Color value)

setBackgroundColor	`→ inherited from Area`
public void setBackgroundColor(com.aspose.cells.Color value)

getForegroundColor/setForegroundColor	`→ inherited from Area`
public com.aspose.cells.Color getForegroundColor() / public void setForegroundColor(com.aspose.cells.Color value)

setForegroundColor	`→ inherited from Area`
public void setForegroundColor(com.aspose.cells.Color value)

getFormatting/setFormatting	`→ inherited from Area`
public int getFormatting() / public void setFormatting(int value)

setFormatting	`→ inherited from Area`
public void setFormatting(int value)

getInvertIfNegative/setInvertIfNegative	`→ inherited from Area`
public boolean getInvertIfNegative() / public void setInvertIfNegative(boolean value)

setInvertIfNegative	`→ inherited from Area`
public void setInvertIfNegative(boolean value)

getFillFormat	`→ inherited from Area`
public FillFormat getFillFormat()

getTransparency/setTransparency	`→ inherited from Area`
public double getTransparency() / public void setTransparency(double value)

setTransparency	`→ inherited from Area`
public void setTransparency(double value)

isVisible	`→ inherited from Area`
public boolean isVisible()

setAuto	`→ inherited from Area`
public void setAuto(boolean isAuto)

com.aspose.cells.Walls.html Maven / Gradle / Ivy

com.aspose.cells Class Walls

getCenterX

getCenterY

getWidth

getDepth

getHeight

getCenterXPx

getCenterYPx

getWidthPx

getDepthPx

getHeightPx

getBorder/setBorder

setBorder

getBackgroundColor/setBackgroundColor

setBackgroundColor

getForegroundColor/setForegroundColor

setForegroundColor

getFormatting/setFormatting

setFormatting

getInvertIfNegative/setInvertIfNegative

setInvertIfNegative

getFillFormat

getTransparency/setTransparency

setTransparency

getCubePointCount

getCubePointXPx

getCubePointYPx

isAuto

isVisible

setAuto

com.aspose.cells
Class Walls