Examples of CellRangeAddress

com.sun.star.table.CellRangeAddress
org.apache.poi.hssf.util.CellRangeAddress
See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'
Note - {@link SelectionRecord} uses the BIFF5 version of this structure @deprecated use {@link org.apache.poi.ss.util.CellRangeAddress}
org.apache.poi.ss.util.CellRangeAddress
See OOO documentation: excelfileformat.pdf sec 2.5.14 - 'Cell Range Address'

In the Microsoft documentation, this is also known as a Ref8U - see page 831 of version 1.0 of the documentation. Note - {@link SelectionRecord} uses the BIFF5 version of this structure @author Dragos Buleandra (dragos.buleandra@trade2b.ro)
org.zkoss.poi.ss.util.CellRangeAddress

Examples of com.sun.star.table.CellRangeAddress

    * <p>Has <b> OK </b> status if the method successfully returns. <p>
    * @see com.sun.star.table.CellRangeAddress
    */
    public void _setDataArea() {
        int nr = Thread.activeCount();
        setDAddress = new CellRangeAddress((short)1, nr, 1, nr, 8);
        oObj.setDataArea(setDAddress);
        tRes.tested("setDataArea()", true);
    }

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

    * <p>Has <b> OK </b> status if the method successfully returns. <p>
    * @see com.sun.star.table.CellRangeAddress
    */
    public void _setLabelArea() {
        int nr = Thread.activeCount();
        setLAddress = new CellRangeAddress((short)1, nr, 0, nr, 0);
        oObj.setLabelArea(setLAddress);
        tRes.tested("setLabelArea()", true);
    }

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

    *  which the labels are valid</li>
    * </ul>
    */
    public void _getDataArea() {
        requiredMethod("setDataArea()");
        CellRangeAddress gA = oObj.getDataArea();
        tRes.tested("getDataArea()", ValueComparer.equalValue(gA, setDAddress));
    }

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

    *  the labels</li>
    * </ul>
    */
    public void _getLabelArea() {
        requiredMethod("setLabelArea()");
        CellRangeAddress gA1 = oObj.getLabelArea();
        tRes.tested("getLabelArea()",
            ValueComparer.equalValue(gA1, setLAddress));
    }

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

    /**
     * Test calls the method and checks returned value.
     * Has <b> OK </b> status if returned value isn't null. <p>
     */
    public void _getRangeAddress() {
        CellRangeAddress oAddr = oObj.getRangeAddress();
        tRes.tested("getRangeAddress()", oAddr != null);
    }

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

    * Has <b> OK </b> status if all fields of cell range addresses are equal. <p>
    */
    public void _getReferredCells() {
        boolean bResult = true;


        CellRangeAddress oldCRA = (CellRangeAddress)
                                    tEnv.getObjRelation("DATAAREA");
        if (oldCRA == null) throw new StatusException(Status.failed
            ("Relation 'DATAAREA' not found"));


        XCellRange cr = oObj.getReferredCells();
        log.println(cr.toString());


        if (cr == null) {
            log.println("getReferredCells returned NULL.");
            tRes.tested("getReferredCells()", false);
            return;
        }


        XCellRangeAddressable xCRA = (XCellRangeAddressable)
                UnoRuntime.queryInterface(XCellRangeAddressable.class, cr);


        CellRangeAddress objCRA = xCRA.getRangeAddress();


        log.println("The named range was 'ANamedRange A1:B2'");
        log.println("Expected CellRangeAddress: (" + oldCRA.Sheet +
            "," + oldCRA.StartColumn + "," + oldCRA.StartRow + "," +
            oldCRA.EndColumn + "," + objCRA.EndRow + ")");

View Full Code Here

Examples of com.sun.star.table.CellRangeAddress

        // do not execute com::sun::star::sheets::XCellSeries::fillAuto()
        tEnv.addObjRelation("XCELLSERIES_FILLAUTO", new Boolean(false));


        // set the adress ranges of the cells (see values set above): for e.g. XSheetOutline test
        tEnv.addObjRelation("CellRangeAddress", 
            new CellRangeAddress((short)0, 6, 6, 8, 8));
        tEnv.addObjRelation("CellRangeSubAddress", 
            new CellRangeAddress((short)0, 6, 6, 7, 8));
        // pick a cell with a formula for XSheetAuditing, a dependent cell and a precedent cell
        tEnv.addObjRelation("XSheetAuditing.CellAddress", new CellAddress((short)0, 8, 6));
        tEnv.addObjRelation("XSheetAuditing.PrecedentCellAddress", new CellAddress((short)0, 7, 6));
        tEnv.addObjRelation("XSheetAuditing.DependentCellAddress", new CellAddress((short)0, 9, 6));
        
        // add an existing sheet for linking
        tEnv.addObjRelation("XSheetLinkable.LinkSheet", "ScSheetLinksObj.sdc");
        
        //adding Scenario and with that a ScenarioSheet-Relation for Scenario and XScenarioEnhanced
        XScenariosSupplier scene = (XScenariosSupplier) UnoRuntime.queryInterface(
                                           XScenariosSupplier.class, 
                                           tEnv.getTestObject());
        scene.getScenarios()
             .addNewByName("Scenario", 
                           new CellRangeAddress[] {
            new CellRangeAddress((short) 0, 0, 0, 10, 10)
        }, "Comment");


        XSpreadsheet sSheet = null;
        
        try {

View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress

   * @Description: 创建标题行(需合并单元格)
   */
  private static void createTableTitleRow(ExportSetInfo setInfo,
      HSSFSheet[] sheets, int sheetNum)
  {
    CellRangeAddress titleRange = new CellRangeAddress(0, 0, 0, 
        setInfo.getFieldNames().get(sheetNum).length);
    sheets[sheetNum].addMergedRegion(titleRange);
    HSSFRow titleRow = sheets[sheetNum].createRow(0);
    titleRow.setHeight((short) 800);
    HSSFCell titleCell = titleRow.createCell(0);

View Full Code Here

Examples of org.apache.poi.hssf.util.CellRangeAddress

   * @Description: 创建日期行(需合并单元格)
   */
  private static void createTableDateRow(ExportSetInfo setInfo,
      HSSFSheet[] sheets, int sheetNum)
  {
    CellRangeAddress dateRange = new CellRangeAddress(1, 1, 0, 
        setInfo.getFieldNames().get(sheetNum).length);
    sheets[sheetNum].addMergedRegion(dateRange);
    HSSFRow dateRow = sheets[sheetNum].createRow(1);
    dateRow.setHeight((short) 350);
    HSSFCell dateCell = dateRow.createCell(0);

View Full Code Here

Examples of org.apache.poi.ss.util.CellRangeAddress

  {
    final int rowSpan = rectangle.getRowSpan();
    final int columnSpan = rectangle.getColumnSpan();
    if (rowSpan > 1 || columnSpan > 1)
    {
      sheet.addMergedRegion(new CellRangeAddress(row, (row + rowSpan - 1), col, (short) (col + columnSpan - 1)));
      final int rectX = rectangle.getX1();
      final int rectY = rectangle.getY1();


      for (int spannedRow = 0; spannedRow < rowSpan; spannedRow += 1)
      {

View Full Code Here

0 1 2 3 4 5

TOP

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.