Package org.apache.poi.ss.formula.PlainCellCache

Examples of org.apache.poi.ss.formula.PlainCellCache.Loc

45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        PlainCellCache cache = new PlainCellCache();
        for (int bookIndex = 0; bookIndex < 0x1000; bookIndex += 0x100) {
            for (int sheetIndex = 0; sheetIndex < 0x1000; sheetIndex += 0x100) {
                for (int rowIndex = 0; rowIndex < 0x100000; rowIndex += 0x1000) {
                    for (int columnIndex = 0; columnIndex < 0x4000; columnIndex += 0x100) {
                        Loc loc = new Loc(bookIndex, sheetIndex, rowIndex, columnIndex);
                        assertEquals(bookIndex, loc.getBookIndex());
                        assertEquals(sheetIndex, loc.getSheetIndex());
                        assertEquals(rowIndex, loc.getRowIndex());
                        assertEquals(columnIndex, loc.getColumnIndex());

                        Loc sameLoc = new Loc(bookIndex, sheetIndex, rowIndex, columnIndex);
                        assertEquals(loc.hashCode(), sameLoc.hashCode());
                        assertTrue(loc.equals(sameLoc));

                        assertNull(cache.get(loc));
                        PlainValueCellCacheEntry entry = new PlainValueCellCacheEntry(new NumberEval(0));
                        cache.put(loc, entry);
View Full Code Here
100
101
102
103
104
105
106
107
108
    }
    public void onCacheHit(int sheetIndex, int rowIndex, int columnIndex, ValueEval result) {
      log("hit", rowIndex, columnIndex, result);
    }
    public void onReadPlainValue(int sheetIndex, int rowIndex, int columnIndex, ICacheEntry entry) {
      Loc loc = new Loc(0, sheetIndex, rowIndex, columnIndex);
      _plainCellLocsByCacheEntry.put(entry, loc);
      log("value", rowIndex, columnIndex, entry.getValue());
    }
View Full Code Here
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
    public void onClearCachedValue(ICacheEntry entry) {
      int rowIndex;
      int columnIndex;
      EvaluationCell cell = (EvaluationCell) _formulaCellsByCacheEntry.get(entry);
      if (cell == null) {
        Loc loc = (Loc)_plainCellLocsByCacheEntry.get(entry);
        if (loc == null) {
          throw new IllegalStateException("can't find cell or location");
        }
        rowIndex = loc.getRowIndex();
        columnIndex = loc.getColumnIndex();
      } else {
        rowIndex = cell.getRowIndex();
        columnIndex = cell.getColumnIndex();
      }
      log("clear", rowIndex, columnIndex, entry.getValue());
View Full Code Here
144
145
146
147
148
149
150
151
152
      log("changeFromBlank", rowIndex, columnIndex, entry.getValue());
      if (entry.getValue() == null) { // hack to tell the difference between formula and plain value
        // perhaps the API could be improved: onChangeFromBlankToValue, onChangeFromBlankToFormula
        _formulaCellsByCacheEntry.put(entry, cell);
      } else {
        Loc loc = new Loc(0, sheetIndex, rowIndex, columnIndex);
        _plainCellLocsByCacheEntry.put(entry, loc);
      }
    }
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  public void notifyUpdateCell(int bookIndex, int sheetIndex, EvaluationCell cell) {
    FormulaCellCacheEntry fcce = _formulaCellCache.get(cell);

    int rowIndex = cell.getRowIndex();
    int columnIndex = cell.getColumnIndex();
    Loc loc = new Loc(bookIndex, sheetIndex, rowIndex, columnIndex);
    PlainValueCellCacheEntry pcce = _plainCellCache.get(loc);

    if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
      if (fcce == null) {
        fcce = new FormulaCellCacheEntry();
View Full Code Here
129
130
131
132
133
134
135
136
137
138
139
  }

  public PlainValueCellCacheEntry getPlainValueEntry(int bookIndex, int sheetIndex,
      int rowIndex, int columnIndex, ValueEval value) {
   
    Loc loc = new Loc(bookIndex, sheetIndex, rowIndex, columnIndex);
    PlainValueCellCacheEntry result = _plainCellCache.get(loc);
    if (result == null) {
      result = new PlainValueCellCacheEntry(value);
      _plainCellCache.put(loc, result);
      if (_evaluationListener != null) {
View Full Code Here
206
207
208
209
210
211
212
213
214
215
216
      } else {
        fcce.setSensitiveInputCells(null);
        fcce.recurseClearCachedFormulaResults(_evaluationListener);
      }
    } else {
      Loc loc = new Loc(bookIndex, sheetIndex, cell.getRowIndex(), cell.getColumnIndex());
      PlainValueCellCacheEntry pcce = _plainCellCache.get(loc);
     
      if (pcce == null) {
        // cache entry doesn't exist. nothing to do
      } else {
View Full Code Here
101
102
103
104
105
106
107
108
109
    }
    public void onCacheHit(int sheetIndex, int rowIndex, int columnIndex, ValueEval result) {
      log("hit", rowIndex, columnIndex, result);
    }
    public void onReadPlainValue(int sheetIndex, int rowIndex, int columnIndex, ICacheEntry entry) {
      Loc loc = new Loc(0, sheetIndex, rowIndex, columnIndex);
      _plainCellLocsByCacheEntry.put(entry, loc);
      log("value", rowIndex, columnIndex, entry.getValue());
    }
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
    public void onClearCachedValue(ICacheEntry entry) {
      int rowIndex;
      int columnIndex;
      EvaluationCell cell = _formulaCellsByCacheEntry.get(entry);
      if (cell == null) {
        Loc loc = _plainCellLocsByCacheEntry.get(entry);
        if (loc == null) {
          throw new IllegalStateException("can't find cell or location");
        }
        rowIndex = loc.getRowIndex();
        columnIndex = loc.getColumnIndex();
      } else {
        rowIndex = cell.getRowIndex();
        columnIndex = cell.getColumnIndex();
      }
      log("clear", rowIndex, columnIndex, entry.getValue());
View Full Code Here
146
147
148
149
150
151
152
153
154
      log("changeFromBlank", rowIndex, columnIndex, entry.getValue());
      if (entry.getValue() == null) { // hack to tell the difference between formula and plain value
        // perhaps the API could be improved: onChangeFromBlankToValue, onChangeFromBlankToFormula
        _formulaCellsByCacheEntry.put(entry, cell);
      } else {
        Loc loc = new Loc(0, sheetIndex, rowIndex, columnIndex);
        _plainCellLocsByCacheEntry.put(entry, loc);
      }
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.PlainCellCache.Loc

  • org.apache.poi.ss.formula.EvaluationCache
  • org.apache.poi.ss.formula.TestEvaluationCache$EvalListener
  • org.apache.poi.ss.formula.TestPlainCellCache
    • 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.