Examples of Cell

Examples of org.uguess.birt.report.engine.spreadsheet.model.Cell

644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
        if (removeEmptyRow) {
            // check blank rows.
            for (int i = 0; i < rowCount; i++) {
                for (int j = 0; j < columnCount; j++) {
                    Cell cell = modelSheet.getCell(i, j, false);

                    if (cell != null && isEffectiveCell(cell)) {
                        nonBlankRow[i] = true;
                        break;
                    }
                }
            }
        }

        double width = 0;

        for (short i = 1; i < columnCount + 1; i++) {
            if (!modelSheet.isColumnEmpty(i - 1)) {

                width = modelSheet.getColumnWidth(i - 1) / (1000 * baseCharWidth);
                width *= XLSRenderOption.ADJUST_FACTOR;//Adjust width
                if (resizeEmptyColumn) {
                    xlsSheet.setColumnWidth((i - 1), (int) (width * 256));
                } else {
                    if (!modelSheet.isColumnEmpty(i - 1)) {
                        xlsSheet.setColumnWidth((i - 1), (int) (width * 256));
                    }
                }
            }

        }

        HSSFCellStyle emptyCellStyle = processor.getEmptyCellStyle();
        HSSFCell emptyCell = null;
        boolean fitPageHeight = false;
        int printAreaColumnStart = -1;
        int printAreaColumnEnd = 0;
        int printAreaRowStart = -1;
        int printAreaRowEnd = 0;
        for (short y = 1; y < rowCount; y++) {
            if (!removeEmptyRow || nonBlankRow[y]) {
                HSSFRow xlsRow = xlsSheet.createRow(y);
                double height = modelSheet.getRowHeight(y) / 1000d;// + 2;
                logger.log(Level.FINER, "row height " + y + ": " + height);

                if (!modelSheet.isRowEmpty((y))) {
                    xlsRow.setHeightInPoints(Math.max((float) (height),2f));
                }

                if (printAreaRowStart == -1) {
                    printAreaRowStart = y;
                }
                printAreaRowEnd = y;
                for (short x = 0; x < columnCount; x++) {
                    if (resizeEmptyColumn || ((!resizeEmptyColumn) && !modelSheet.isColumnEmpty(x))) {
                        emptyCell = xlsRow.createCell(x);
                        emptyCell.setCellStyle(emptyCellStyle);
                        if (printAreaColumnStart == -1) {
                            printAreaColumnStart = x;
                        }
                        printAreaColumnEnd = x;
                        Cell element = modelSheet.getCell(y, x, false);
                        if (element != null) {
                            exportCell(element,
                                    x,
                                    y,
                                    xlsSheet,
View Full Code Here

Examples of org.xlsx4j.sml.Cell

53
54
55
56
57
58
59
60
61
62
63
64
          // Minimal content already present
          SheetData sheetData = sheet.getContents().getSheetData();

          // Now add
          Row row = Context.getsmlObjectFactory().createRow();
          Cell cell = Context.getsmlObjectFactory().createCell();
          cell.setV("1234");
          row.getC().add(cell);


          row.getC().add(createCell("hello world!"));
          sheetData.getRow().add(row);
View Full Code Here

Examples of org.zkoss.poi.ss.usermodel.Cell

59
60
61
62
63
64
65
66
67
68
69
    Worksheet sheet = ((Spreadsheet) comp).getSelectedSheet();
    if (!Utils.getSheetUuid(sheet).equals(sheetId))
      return;
   
    Cell cell = Utils.getCell(sheet, row, col);
    // You can call getEditText(), setEditText(), getText().

    //TODO, Utils.getRichEditText(cell)?
    String editText = cell == null ? "" : Utils.getEditText(cell);
   
View Full Code Here

Examples of org.zkoss.test.zss.Cell

120
121
122
123
124
125
126
127
128
129
130
131
    int rCol = 9;
    keyboardDirector.ctrlFontBold(tRow, lCol, bRow, rCol);
   
    Iterator<Cell> i = iterator(tRow, lCol, bRow, rCol);
    while (i.hasNext()) {
      Cell c = i.next();
      if (!c.isFontBold()) {
        System.out.println(c);
      }
      Assert.assertTrue(c.isFontBold());
    }
  }
View Full Code Here

Examples of org.zkoss.zss.model.Cell

62
63
64
65
66
67
68
69
70
71
72
73
74
75
    Sheet sheet = ((Spreadsheet)comp).getSelectedSheet();
    if(!Utils.getId(sheet).equals(sheetId)){
      return;
    }
   
    Cell cell = sheet.getCell(row,col);
    //You can call getEditText(), setEditText(), getText().
   
    String text = cell==null?"":cell.getEditText();
   
    StartEditingEvent event = new StartEditingEvent(org.zkoss.zss.ui.event.Events.ON_START_EDITING, comp, sheet,row,col,text,clienttxt);
    Events.postEvent(event);
    Events.postEvent(new Event("onStartEditingImpl", comp, new Object[]{token,event}));
  }
View Full Code Here

Examples of org.zkoss.zul.Cell

271
272
273
274
275
276
277
278
279
280
281
282
283
    if (!StringUtils.isEmpty(String.valueOf(recCount))) {
      this.lfTotalCount.setLabel(String.valueOf(recCount));
    } else
      this.lfTotalCount.setLabel("0");

    Cell cell = new Cell();
    cell.setWidth("33%");
    cell.setStyle("padding: 0px;");
    cell.setHflex("1");
    cell.appendChild(div);

    return cell;
  }
View Full Code Here

Examples of pl.michalostruszka.gameoflife.cell.Cell

47
48
49
50
51
52
53
54
55
        return nextBoard;
    }

    private void evolveCellNeighbours(Board nextBoard, Set<Position> neighbours) {
        for (Position neighbourPosition: neighbours) {
            Cell nextNeighbourState = determineCellAt(neighbourPosition).evolveIntoNewState(this);
            nextNeighbourState.attachToBoard(nextBoard);
        }
    }
View Full Code Here

Examples of realcix20.classes.basic.Cell

54
55
56
57
58
59
60
61
62
63
64
65
        public void setCurrentUser(Row currentUser) {
           
                //will be modified
                DAO dao = DAO.getInstance();
                dao.update(Resources.UPDATE_GLOBALVAR_TABLE_SQL);
                Cell userCell = ObjectUtil.findNewCell(currentUser, "LOGINENTRY", "RUSER");               
                dao.setObject(1, userCell.getColumnValue());
                dao.setObject(2, "loginuser");
                dao.executeUpdate();

                this.currentUser = currentUser;
        }
View Full Code Here

Examples of rex.metadata.resultelements.Cell

94
95
96
97
98
99
100
101
102
103
104
105
106
107
  public void testExecute() {
    try
    {
      // Result of following Query should be 266773.
      // SELECT NON EMPTY {[Measures].[Unit Sales]} ON COLUMNS, NON EMPTY {[Time].[1997]} ON ROWS FROM [Sales]
      Assert.assertEquals("266773",(new Cell((((port1.execute(mdxQuerySales,execPropFoodMart)).getElementsByTagName("CellData")).item(0).getChildNodes()).item(1))).getCellValue());
      // Result of following Query should be 66984555.
      // SELECT NON EMPTY {[Measures].[nQuantity]} ON COLUMNS, NON EMPTY {[Time].[2006]} ON ROWS FROM [Inventory]
      Assert.assertEquals("66984555",(new Cell((((port1.execute(mdxQueryInv,execPropInventory)).getElementsByTagName("CellData")).item(0).getChildNodes()).item(1))).getCellValue());     
    }
    catch(Exception exc)
    {
      System.out.println("From TestExecute Exception");
      System.out.println("Exception Error"+exc.getMessage());
View Full Code Here

Examples of vsv.Cell

132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
    Vector<Double> resultsTranscripts = new Vector<Double>();
    Vector<Double> resultsProteins = new Vector<Double>();
    Vector<Double> time = new Vector<Double>();
   
    // Initialize Cell Amounts
    Cell cell = new Cell();
    cell.templates.initialize(new Item("Template", templates, 0.0));
    cell.proteins.initialize(new Item("Rib", ribosomes, 0.0));
    cell.proteins.initialize(new Item("Pol", polymerases, 0.0));
   
    Vector<Reaction> rxns = new Vector<Reaction>();
   
    // Add reactions
    TestPolymeraseRxn transcription = new TestPolymeraseRxn(cell.templates, "Template", cell.proteins, "Pol", kms, transcriptDelay, cell.transcripts);
    TestPolymeraseRxn translation = new TestPolymeraseRxn(cell.transcripts, "Template", cell.proteins, "Rib", ksp, proteinDelay, cell.proteins);
    rxns.add(transcription);
    rxns.add(translation);
    LSVList reactions = new LSVList();
    reactions.add("Reactions");
    for (Reaction r : rxns)
    {
      reactions.add(r.toString());
    }
    Recorder.log(reactions.toString(), "Tester");
   
    double t = 0;
    while (t <= tf)
    {
      // Add matured items to the pool
      cell.mature(t);
     
      if(t % dtRecord == 0)
      {
        resultsTranscripts.add(cell.transcripts.getCount("Template"));
        resultsProteins.add(cell.proteins.getCount("Template"));
        time.add(t);
      }
     
      // calculate rates based on each reaction in the simulation
      for (Reaction rxn : rxns)
      {
        rxn.calculateBaseRate();
        rxn.applyStoichAndRate();
      }
      cell.simpleLinearIntegrate(dt, t, 1);
     
      t = t + dt;
    }
   
    if(plot)
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.