| |||||||||

PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||

SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |

Interface ClientAnchor

public interface

**ClientAnchor**

A client anchor is attached to an excel worksheet. It anchors against a top-left and bottom-right cell.

Field Summary | |
---|---|

`static int` |
Do Not Move or Resize With Underlying Rows/Columns |

`static int` |
Move and Resize With Anchor Cells |

`static int` |
Move With Cells but Do Not Resize |

Method Summary | |
---|---|

` int` |
Gets the anchor type |

` short` |
Returns the column (0 based) of the first cell. |

` short` |
Returns the column (0 based) of the second cell. |

` int` |
Returns the x coordinate within the first cell. |

` int` |
Returns the x coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` int` |
Returns the y coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` int` |
Sets the y coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` int` |
Returns the row (0 based) of the first cell. |

` int` |
Returns the row (0 based) of the second cell. |

` void` |
Sets the anchor type |

` void` |
Sets the column (0 based) of the first cell. |

` void` |
Returns the column (0 based) of the second cell. |

` void` |
Sets the x coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` void` |
Sets the x coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` void` |
Sets the y coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` void` |
Sets the y coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of `Units.EMU_PER_PIXEL` |

` void` |
Returns the row (0 based) of the first cell. |

` void` |
Returns the row (0 based) of the first cell. |

Field Detail |
---|

static final intMOVE_AND_RESIZE

- Move and Resize With Anchor Cells
Specifies that the current drawing shall move and resize to maintain its row and column anchors (i.e. the object is anchored to the actual from and to row and column)

**See Also:**- Constant Field Values

static final intMOVE_DONT_RESIZE

- Move With Cells but Do Not Resize
Specifies that the current drawing shall move with its row and column (i.e. the object is anchored to the actual from row and column), but that the size shall remain absolute.

If additional rows/columns are added between the from and to locations of the drawing, the drawing shall move its to anchors as needed to maintain this same absolute size.

**See Also:**- Constant Field Values

static final intDONT_MOVE_AND_RESIZE

- Do Not Move or Resize With Underlying Rows/Columns
Specifies that the current start and end positions shall be maintained with respect to the distances from the absolute start point of the worksheet.

If additional rows/columns are added before the drawing, the drawing shall move its anchors as needed to maintain this same absolute position.

**See Also:**- Constant Field Values

Method Detail |
---|

shortgetCol1()

- Returns the column (0 based) of the first cell.
**Returns:**- 0-based column of the first cell.

voidsetCol1(int col1)

- Sets the column (0 based) of the first cell.
**Parameters:**`col1`

- 0-based column of the first cell.

shortgetCol2()

- Returns the column (0 based) of the second cell.
**Returns:**- 0-based column of the second cell.

voidsetCol2(int col2)

- Returns the column (0 based) of the second cell.
**Parameters:**`col2`

- 0-based column of the second cell.

intgetRow1()

- Returns the row (0 based) of the first cell.
**Returns:**- 0-based row of the first cell.

voidsetRow1(int row1)

- Returns the row (0 based) of the first cell.
**Parameters:**`row1`

- 0-based row of the first cell.

intgetRow2()

- Returns the row (0 based) of the second cell.
**Returns:**- 0-based row of the second cell.

voidsetRow2(int row2)

- Returns the row (0 based) of the first cell.
**Parameters:**`row2`

- 0-based row of the first cell.

intgetDx1()

- Returns the x coordinate within the first cell. Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Returns:**- the x coordinate within the first cell

voidsetDx1(int dx1)

- Sets the x coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Parameters:**`dx1`

- the x coordinate within the first cell

intgetDy1()

- Returns the y coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Returns:**- the y coordinate within the first cell

voidsetDy1(int dy1)

- Sets the y coordinate within the first cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Parameters:**`dy1`

- the y coordinate within the first cell

intgetDy2()

- Sets the y coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Returns:**- the y coordinate within the second cell

voidsetDy2(int dy2)

- Sets the y coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Parameters:**`dy2`

- the y coordinate within the second cell

intgetDx2()

- Returns the x coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Returns:**- the x coordinate within the second cell

voidsetDx2(int dx2)

- Sets the x coordinate within the second cell Note - XSSF and HSSF have a slightly different coordinate system, values in XSSF are larger by a factor of
`Units.EMU_PER_PIXEL`

**Parameters:**`dx2`

- the x coordinate within the second cell

voidsetAnchorType(int anchorType)

- Sets the anchor type
0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.

**Parameters:**`anchorType`

- the anchor type**See Also:**`MOVE_AND_RESIZE`

,`MOVE_DONT_RESIZE`

,`DONT_MOVE_AND_RESIZE`

intgetAnchorType()

- Gets the anchor type
0 = Move and size with Cells, 2 = Move but don't size with cells, 3 = Don't move or size with cells.

**Returns:**- the anchor type
**See Also:**`MOVE_AND_RESIZE`

,`MOVE_DONT_RESIZE`

,`DONT_MOVE_AND_RESIZE`

| |||||||||

PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||

SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |

NOTHING

Add the Maven Dependecy to your project: maven dependecy for com.amazonaws : aws-java-sdk :
1.3.14

Launch demo modal