Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.ClientAnchor

982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
      final int dx1 = (int) (1023 * ((cb.getX() - cell1xPos) / (double) cell1width));
      final int dy1 = (int) (255 * ((cb.getY() - cell1yPos) / (double) cell1height));
      final int dx2 = (int) (1023 * ((cb.getX() + cb.getWidth() - cell2xPos) / (double) cell2width));
      final int dy2 = (int) (255 * ((cb.getY() + cb.getHeight() - cell2yPos) / (double) cell2height));

      final ClientAnchor anchor = workbook.getCreationHelper().createClientAnchor();
      anchor.setDx1(dx1);
      anchor.setDy1(dy1);
      anchor.setDx2(dx2);
      anchor.setDy2(dy2);
      anchor.setCol1((short) cell1x);
      anchor.setRow1(cell1y);
      anchor.setCol2((short) cell2x);
      anchor.setRow2(cell2y);
      anchor.setAnchorType(ClientAnchor.MOVE_DONT_RESIZE); // Move, but don't size
      if (patriarch == null)
      {
        patriarch = sheet.createDrawingPatriarch();
      }
      final Picture picture = patriarch.createPicture(anchor, pictureId);
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
  {
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(100), StrictGeomUtility.toInternalValue(100),
        StrictGeomUtility.toInternalValue(400), StrictGeomUtility.toInternalValue(400));
    ClientAnchor clientAnchor = imageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(0, clientAnchor.getDx1());
    Assert.assertEquals(1023, clientAnchor.getDx2());
    Assert.assertEquals(0, clientAnchor.getDy1());
    Assert.assertEquals(255, clientAnchor.getDy2());
  }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(100), StrictGeomUtility.toInternalValue(100),
        StrictGeomUtility.toInternalValue(300), StrictGeomUtility.toInternalValue(300));

    ClientAnchor clientAnchor = imageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(0, clientAnchor.getDx1());
    Assert.assertEquals(1023 * 3 / 4, clientAnchor.getDx2());
    Assert.assertEquals(0, clientAnchor.getDy1());
    Assert.assertEquals(255 * 3 / 4, clientAnchor.getDy2());
  }
View Full Code Here
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(200), StrictGeomUtility.toInternalValue(200),
        StrictGeomUtility.toInternalValue(200), StrictGeomUtility.toInternalValue(200));

    ClientAnchor clientAnchor = imageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(255, clientAnchor.getDx1());
    Assert.assertEquals(1023 * 3 / 4, clientAnchor.getDx2());
    Assert.assertEquals(63, clientAnchor.getDy1());
    Assert.assertEquals(255 * 3 / 4, clientAnchor.getDy2());
  }
View Full Code Here
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
  {
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(100), StrictGeomUtility.toInternalValue(100),
        StrictGeomUtility.toInternalValue(400), StrictGeomUtility.toInternalValue(400));
    ClientAnchor clientAnchor = xlsxImageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(0, clientAnchor.getDx1());
    Assert.assertEquals(400 * XSSFShape.EMU_PER_POINT, clientAnchor.getDx2());
    Assert.assertEquals(0, clientAnchor.getDy1());
    Assert.assertEquals(400 * XSSFShape.EMU_PER_POINT, clientAnchor.getDy2());
  }
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(100), StrictGeomUtility.toInternalValue(100),
        StrictGeomUtility.toInternalValue(300), StrictGeomUtility.toInternalValue(300));

    ClientAnchor clientAnchor = xlsxImageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(0, clientAnchor.getDx1());
    Assert.assertEquals(300 * XSSFShape.EMU_PER_POINT, clientAnchor.getDx2());
    Assert.assertEquals(0, clientAnchor.getDy1());
    Assert.assertEquals(300 * XSSFShape.EMU_PER_POINT, clientAnchor.getDy2());
  }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
    TableRectangle rect = new TableRectangle();
    rect.setRect(1, 1, 2, 2);
    StrictBounds b = new StrictBounds(StrictGeomUtility.toInternalValue(200), StrictGeomUtility.toInternalValue(200),
        StrictGeomUtility.toInternalValue(200), StrictGeomUtility.toInternalValue(200));

    ClientAnchor clientAnchor = xlsxImageHandler.computeClientAnchor(sheetLayout, rect, b);
    Assert.assertEquals(1, clientAnchor.getCol1());
    Assert.assertEquals(1, clientAnchor.getCol2());
    Assert.assertEquals(1, clientAnchor.getRow1());
    Assert.assertEquals(1, clientAnchor.getRow2());

    Assert.assertEquals(100 * XSSFShape.EMU_PER_POINT, clientAnchor.getDx1());
    Assert.assertEquals(300 * XSSFShape.EMU_PER_POINT, clientAnchor.getDx2());
    Assert.assertEquals(100 * XSSFShape.EMU_PER_POINT, clientAnchor.getDy1());
    Assert.assertEquals(300 * XSSFShape.EMU_PER_POINT, clientAnchor.getDy2());
  }
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
        // should not happen, as PNG is always supported.
        logger.warn("Assertation-Failure: PNG encoding failed.", uee);  // NON-NLS
        return;
      }

      final ClientAnchor anchor = computeClientAnchor(currentLayout, rectangle, cb);

      Drawing patriarch = printerBase.getDrawingPatriarch();

      final Picture picture = patriarch.createPicture(anchor, pictureId);
      logger.info(String.format("Created image: %d => %s", pictureId, picture));  // NON-NLS
View Full Code Here
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
    final int dx1 = (int) (1023 * ((cb.getX() - cell1xPos) / (double) cell1width));
    final int dy1 = (int) (255 * ((cb.getY() - cell1yPos) / (double) cell1height));
    final int dx2 = (int) (1023 * ((cb.getX() + cb.getWidth() - cell2xPos) / (double) cell2width));
    final int dy2 = (int) (255 * ((cb.getY() + cb.getHeight() - cell2yPos) / (double) cell2height));

    final ClientAnchor anchor = printerBase.getWorkbook().getCreationHelper().createClientAnchor();
    anchor.setDx1(dx1);
    anchor.setDy1(dy1);
    anchor.setDx2(dx2);
    anchor.setDy2(dy2);
    anchor.setCol1(cell1x);
    anchor.setRow1(cell1y);
    anchor.setCol2(cell2x);
    anchor.setRow2(cell2y);
    anchor.setAnchorType(ClientAnchor.MOVE_DONT_RESIZE);
    return anchor;
  }
View Full Code Here
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
    final int dx1 = (int) StrictGeomUtility.toExternalValue((cb.getX() - cell1xPos) * XSSFShape.EMU_PER_POINT);
    final int dy1 = (int) StrictGeomUtility.toExternalValue((cb.getY() - cell1yPos) * XSSFShape.EMU_PER_POINT);
    final int dx2 = (int) Math.max(0, StrictGeomUtility.toExternalValue((cb.getX() + cb.getWidth() - cell2xPos) * XSSFShape.EMU_PER_POINT));
    final int dy2 = (int) Math.max(0, StrictGeomUtility.toExternalValue((cb.getY() + cb.getHeight() - cell2yPos)  * XSSFShape.EMU_PER_POINT));

    final ClientAnchor anchor = printerBase.getWorkbook().getCreationHelper().createClientAnchor();
    anchor.setDx1(dx1);
    anchor.setDy1(dy1);
    anchor.setDx2(dx2);
    anchor.setDy2(dy2);
    anchor.setCol1(cell1x);
    anchor.setRow1(cell1y);
    anchor.setCol2(cell2x);
    anchor.setRow2(cell2y);
    anchor.setAnchorType(ClientAnchor.MOVE_DONT_RESIZE);
    return anchor;
  }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.ClientAnchor

  • com.danhaywood.isis.domainservice.excel.impl.CellMarshaller
  • com.haulmont.yarg.formatters.impl.inline.AbstractInliner
  • org.apache.poi.hssf.usermodel.TestHSSFComment
  • org.apache.poi.hssf.usermodel.TestHSSFPicture
  • org.apache.poi.ss.examples.AddDimensionedImage
  • org.apache.poi.ss.util.ImageUtils
  • org.apache.poi.xssf.usermodel.charts.TestXSSFLineChartData
  • org.apache.poi.xssf.usermodel.charts.TestXSSFScatterChartData
  • org.apache.poi.xssf.usermodel.examples.LineChart
  • org.apache.poi.xssf.usermodel.TestXSSFBugs
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.