public class EscherGraphics extends Graphics
Important:
One important concept worth considering is that of font size. One of the difficulties in converting Graphics calls into escher drawing calls is that Excel does not have the concept of absolute pixel positions. It measures it's cell widths in 'characters' and the cell heights in points. Unfortunately it's not defined exactly what a type of character it's measuring. Presumably this is due to the fact that the Excel will be using different fonts on different platforms or even within the same platform.Because of this constraint we've had to calculate the verticalPointsPerPixel. This the amount the font should be scaled by when you issue commands such as drawString(). A good way to calculate this is to use the follow formula:
multipler = groupHeightInPoints / heightOfGroupThe height of the group is calculated fairly simply by calculating the difference between the y coordinates of the bounding box of the shape. The height of the group can be calculated by using a convenience called
HSSFClientAnchor.getAnchorHeightInPoints().
| Modifier and Type | Field and Description |
|---|---|
private Color |
background |
private HSSFShapeGroup |
escherGroup |
private Font |
font |
private Color |
foreground |
private static POILogger |
logger |
private float |
verticalPixelsPerPoint |
private float |
verticalPointsPerPixel |
private HSSFWorkbook |
workbook |
| Constructor and Description |
|---|
EscherGraphics(HSSFShapeGroup escherGroup,
HSSFWorkbook workbook,
Color forecolor,
float verticalPointsPerPixel)
Construct an escher graphics object.
|
EscherGraphics(HSSFShapeGroup escherGroup,
HSSFWorkbook workbook,
Color foreground,
Font font,
float verticalPointsPerPixel)
Constructs an escher graphics object.
|
| Modifier and Type | Method and Description |
|---|---|
private int[] |
addToAll(int[] values,
int amount) |
void |
clearRect(int x,
int y,
int width,
int height) |
void |
clipRect(int x,
int y,
int width,
int height) |
void |
copyArea(int x,
int y,
int width,
int height,
int dx,
int dy) |
Graphics |
create() |
void |
dispose() |
void |
drawArc(int x,
int y,
int width,
int height,
int startAngle,
int arcAngle) |
boolean |
drawImage(Image image,
int i,
int j,
Color color,
ImageObserver imageobserver) |
boolean |
drawImage(Image image,
int i,
int j,
ImageObserver imageobserver) |
boolean |
drawImage(Image image,
int i,
int j,
int k,
int l,
Color color,
ImageObserver imageobserver) |
boolean |
drawImage(Image image,
int i,
int j,
int k,
int l,
ImageObserver imageobserver) |
boolean |
drawImage(Image img,
int dx1,
int dy1,
int dx2,
int dy2,
int sx1,
int sy1,
int sx2,
int sy2,
Color bgcolor,
ImageObserver observer) |
boolean |
drawImage(Image img,
int dx1,
int dy1,
int dx2,
int dy2,
int sx1,
int sy1,
int sx2,
int sy2,
ImageObserver observer) |
void |
drawLine(int x1,
int y1,
int x2,
int y2) |
void |
drawLine(int x1,
int y1,
int x2,
int y2,
int width) |
void |
drawOval(int x,
int y,
int width,
int height) |
void |
drawPolygon(int[] xPoints,
int[] yPoints,
int nPoints) |
void |
drawPolyline(int[] xPoints,
int[] yPoints,
int nPoints) |
void |
drawRect(int x,
int y,
int width,
int height) |
void |
drawRoundRect(int x,
int y,
int width,
int height,
int arcWidth,
int arcHeight) |
void |
drawString(AttributedCharacterIterator iterator,
int x,
int y) |
void |
drawString(String str,
int x,
int y) |
void |
fillArc(int x,
int y,
int width,
int height,
int startAngle,
int arcAngle) |
void |
fillOval(int x,
int y,
int width,
int height) |
void |
fillPolygon(int[] xPoints,
int[] yPoints,
int nPoints)
Fills a (closed) polygon, as defined by a pair of arrays, which
hold the x and y coordinates.
|
void |
fillRect(int x,
int y,
int width,
int height) |
void |
fillRoundRect(int x,
int y,
int width,
int height,
int arcWidth,
int arcHeight) |
private int |
findBiggest(int[] values) |
private int |
findSmallest(int[] values) |
Color |
getBackground() |
Shape |
getClip() |
Rectangle |
getClipBounds() |
Rectangle |
getClipRect() |
Color |
getColor() |
(package private) HSSFShapeGroup |
getEscherGraphics() |
Font |
getFont() |
FontMetrics |
getFontMetrics(Font f) |
private HSSFFont |
matchFont(Font font) |
void |
setBackground(Color background) |
void |
setClip(int x,
int y,
int width,
int height) |
void |
setClip(Shape shape) |
void |
setColor(Color color) |
void |
setFont(Font f) |
void |
setPaintMode() |
void |
setXORMode(Color color) |
void |
translate(int x,
int y) |
create, draw3DRect, drawBytes, drawChars, drawPolygon, fill3DRect, fillPolygon, finalize, getClipBounds, getFontMetrics, hitClip, toStringprivate HSSFShapeGroup escherGroup
private HSSFWorkbook workbook
private float verticalPointsPerPixel
private float verticalPixelsPerPoint
private Color foreground
private Color background
private Font font
private static POILogger logger
public EscherGraphics(HSSFShapeGroup escherGroup, HSSFWorkbook workbook, Color forecolor, float verticalPointsPerPixel)
escherGroup - The escher group to write the graphics calls into.workbook - The workbook we are using.forecolor - The foreground color to use as default.verticalPointsPerPixel - The font multiplier. (See class description for information on how this works.).EscherGraphics(HSSFShapeGroup escherGroup, HSSFWorkbook workbook, Color foreground, Font font, float verticalPointsPerPixel)
escherGroup - The escher group to write the graphics calls into.workbook - The workbook we are using.foreground - The foreground color to use as default.verticalPointsPerPixel - The font multiplier. (See class description for information on how this works.).font - The font to use.public void clearRect(int x,
int y,
int width,
int height)
public void clipRect(int x,
int y,
int width,
int height)
public void copyArea(int x,
int y,
int width,
int height,
int dx,
int dy)
public void drawArc(int x,
int y,
int width,
int height,
int startAngle,
int arcAngle)
public boolean drawImage(Image img, int dx1, int dy1, int dx2, int dy2, int sx1, int sy1, int sx2, int sy2, Color bgcolor, ImageObserver observer)
public boolean drawImage(Image img, int dx1, int dy1, int dx2, int dy2, int sx1, int sy1, int sx2, int sy2, ImageObserver observer)
public boolean drawImage(Image image, int i, int j, int k, int l, Color color, ImageObserver imageobserver)
public boolean drawImage(Image image, int i, int j, int k, int l, ImageObserver imageobserver)
public boolean drawImage(Image image, int i, int j, Color color, ImageObserver imageobserver)
public boolean drawImage(Image image, int i, int j, ImageObserver imageobserver)
public void drawLine(int x1,
int y1,
int x2,
int y2)
public void drawLine(int x1,
int y1,
int x2,
int y2,
int width)
public void drawOval(int x,
int y,
int width,
int height)
public void drawPolygon(int[] xPoints,
int[] yPoints,
int nPoints)
drawPolygon in class Graphicsprivate int[] addToAll(int[] values,
int amount)
public void drawPolyline(int[] xPoints,
int[] yPoints,
int nPoints)
drawPolyline in class Graphicspublic void drawRect(int x,
int y,
int width,
int height)
public void drawRoundRect(int x,
int y,
int width,
int height,
int arcWidth,
int arcHeight)
drawRoundRect in class Graphicspublic void drawString(String str, int x, int y)
drawString in class Graphicspublic void drawString(AttributedCharacterIterator iterator, int x, int y)
drawString in class Graphicspublic void fillArc(int x,
int y,
int width,
int height,
int startAngle,
int arcAngle)
public void fillOval(int x,
int y,
int width,
int height)
public void fillPolygon(int[] xPoints,
int[] yPoints,
int nPoints)
This draws the polygon, with nPoint line segments.
The first nPoint - 1 line segments are
drawn between sequential points
(xPoints[i],yPoints[i],xPoints[i+1],yPoints[i+1]).
The final line segment is a closing one, from the last point to
the first (assuming they are different).
The area inside of the polygon is defined by using an even-odd fill rule (also known as the alternating rule), and the area inside of it is filled.
fillPolygon in class GraphicsxPoints - array of the x coordinates.yPoints - array of the y coordinates.nPoints - the total number of points in the polygon.Graphics.drawPolygon(int[], int[], int)private int findBiggest(int[] values)
private int findSmallest(int[] values)
public void fillRect(int x,
int y,
int width,
int height)
public void fillRoundRect(int x,
int y,
int width,
int height,
int arcWidth,
int arcHeight)
fillRoundRect in class Graphicspublic Rectangle getClipBounds()
getClipBounds in class Graphicspublic Rectangle getClipRect()
getClipRect in class Graphicspublic FontMetrics getFontMetrics(Font f)
getFontMetrics in class Graphicspublic void setClip(int x,
int y,
int width,
int height)
public void setPaintMode()
setPaintMode in class Graphicspublic void setXORMode(Color color)
setXORMode in class Graphicspublic Color getBackground()
public void setBackground(Color background)
HSSFShapeGroup getEscherGraphics()
Copyright © 2016 Open Microscopy Environment