Package org.formulacompiler.spreadsheet.Spreadsheet

Examples of org.formulacompiler.spreadsheet.Spreadsheet.Cell

78
79
80
81
82
83
84
85
86
87
88
    final Map<String, Spreadsheet.Range> result = New.map();
    final SpreadsheetBinder binder = getBinder();
    for (Map.Entry<String, Spreadsheet.Range> def : defs.entrySet()) {
      final Spreadsheet.Range range = def.getValue();
      if (range instanceof Cell) {
        final Cell cell = (Cell) range;
        if (!binder.isInputCell( cell ) && !binder.isOutputCell( cell )) {
          result.put( def.getKey(), range );
        }
      }
    }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    }

    private void bindThisMethodToNamedCell( Method _m, String _cellNamePrefix ) throws CompilerException
    {
      final String fullCellName = (_cellNamePrefix + _m.getName());
      Cell cell = null;
      try {
        cell = getSpreadsheet().getCell( fullCellName );
      }
      catch (SpreadsheetException.NameNotFound e) {
        final String baseCellName = (_cellNamePrefix + getPlainCellNameFor( _m ));
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
      final String prefix = (null != _prefix) ? _prefix.toUpperCase() : null;
      final Map<String, Spreadsheet.Range> defs = getSpreadsheet().getRangeNames();
      for (Map.Entry<String, Spreadsheet.Range> def : defs.entrySet()) {
        final Spreadsheet.Range range = def.getValue();
        if (range instanceof Cell) {
          final Cell cell = (Cell) range;
          if (canBind( cell )) {
            final String name = def.getKey().toUpperCase();
            if (null == prefix) {
              bindThisNamedCellToMethod( cell, name );
            }
View Full Code Here
232
233
234
235
236
237
238
239
240
241
242
    {
      final Map<String, Spreadsheet.Range> defs = getBinder().getSpreadsheet().getRangeNames();
      for (Map.Entry<String, Spreadsheet.Range> def : defs.entrySet()) {
        final Spreadsheet.Range range = def.getValue();
        if (range instanceof Cell) {
          final Cell cell = (Cell) range;
          final String name = def.getKey();
          if (name.toUpperCase().startsWith( _prefix )) {
            if (!isBound( cell )) {
              throw new SpreadsheetException.NameNotFound( "There is no "
                  + bindingTypeName() + " method named " + name + "() or get" + name + "() to bind the cell "
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
  public void createCellNamesFromRowTitles()
  {
    for (Spreadsheet.Row row : this.sheet.getRows()) {
      final Cell[] cells = row.getCells();
      if (cells.length >= 2) {
        final Cell titleCell = cells[ 0 ];
        if (null != titleCell) {
          final Object titleValue = titleCell.getConstantValue();
          if (titleValue instanceof String) {
            this.spreadsheet.defineAdditionalRangeName( sanitize( (String) titleValue ), cells[ 1 ] );
          }
        }
      }
View Full Code Here
TOP

Related Classes of org.formulacompiler.spreadsheet.Spreadsheet.Cell

  • org.formulacompiler.spreadsheet.internal.util.SpreadsheetByNameBinderImpl
  • org.formulacompiler.spreadsheet.internal.util.SpreadsheetByNameBinderImpl$CellBinderImpl
  • org.formulacompiler.spreadsheet.internal.util.SpreadsheetNameCreatorImpl
    • 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.