public void resize(double scaleX, double scaleY) {HSSFClientAnchor anchor = getClientAnchor();anchor.setAnchorType(AnchorType.MOVE_DONT_RESIZE);HSSFClientAnchor pref = getPreferredSize(scaleX,scaleY);int row2 = anchor.getRow1() + (pref.getRow2() - pref.getRow1());int col2 = anchor.getCol1() + (pref.getCol2() - pref.getCol1());anchor.setCol2((short)col2);anchor.setDx2(pref.getDx2());anchor.setRow2(row2);anchor.setDy2(pref.getDy2());}

public void Resize(double scaleX, double scaleY){HSSFClientAnchor anchor = (HSSFClientAnchor)ClientAnchor;anchor.AnchorType = AnchorType.MoveDontResize;HSSFClientAnchor pref = GetPreferredSize(scaleX, scaleY) as HSSFClientAnchor;int row2 = anchor.Row1 + (pref.Row2 - pref.Row1);int col2 = anchor.Col1 + (pref.Col2 - pref.Col1);anchor.Col2=((short)col2);anchor.Dx2=(pref.Dx2);anchor.Row2 = (row2);anchor.Dy2 = (pref.Dy2);}
