title: Apache POI HSSF: How to add shape which would not resize along with corresponding cell?
body: <p>I need to add shape (specifically circle) to xls-document using POI. So, I wrote following code:</p>
  
  <pre><code>private void drawLabel(HSSFSheet sheet, HSSFCell cell) {
      final short columnIndex = (short) cell.getColumnIndex();
      final int rowIndex = cell.getRowIndex();
      HSSFClientAnchor anchor = new HSSFClientAnchor(60, 60, 200, 200, columnIndex, rowIndex, columnIndex, rowIndex);
      anchor.setAnchorType(ClientAnchor.MOVE_DONT_RESIZE);
      HSSFSimpleShape shape = sheet.getDrawingPatriarch().createSimpleShape(anchor);
      shape.setShapeType(HSSFSimpleShape.OBJECT_TYPE_OVAL);
      ...
  }
  </code></pre>
  
  <p>It works. But if I try to change column width programmatically (e.g. <code>sheet.setColumnWidth(0, 5 * 256);</code> (suppose that shape has been added to cell with column index == 0)), circle distorts and becomes like an oval (although anchor's type is set to <code>MOVE_DONT_RESIZE</code>).
  What is wrong in my approach and is there a way to draw a shape which would not resize along with corresponding cell?</p>