Package org.formulacompiler.spreadsheet.internal

Examples of org.formulacompiler.spreadsheet.internal.CellIndex

74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
    return sb.toString();
  }

  private static void appendRangeRef( final StringBuilder _sb, final Range _range, final int _sheetIndex )
  {
    final CellIndex cellFrom = (CellIndex) _range.getTopLeft();
    final CellIndex cellTo = (CellIndex) _range.getBottomRight();
    if (_sheetIndex != cellFrom.getSheetIndex() || _sheetIndex != cellTo.getSheetIndex()) {
      if (cellFrom.getSheetIndex() != cellTo.getSheetIndex()) {
        final String fromSheetName = cellFrom.getSheet().getName();
        final String toSheetName = cellTo.getSheet().getName();
        final boolean quoted = needsQuotes( fromSheetName ) || needsQuotes( toSheetName );
        if (quoted) _sb.append( QUOTE );
        _sb.append( escapeSheetName( fromSheetName ) );
        _sb.append( RANGE_SEPARATOR );
        _sb.append( escapeSheetName( toSheetName ) );
        if (quoted) _sb.append( QUOTE );
      }
      else {
        final String sheetName = cellFrom.getSheet().getName();
        final boolean quoted = needsQuotes( sheetName );
        if (quoted) _sb.append( QUOTE );
        _sb.append( escapeSheetName( sheetName ) );
        if (quoted) _sb.append( QUOTE );
      }
      _sb.append( SHEET_NAME_SEPARATOR );
    }
    CellIndex.appendNameA1ForCellIndex( _sb, cellFrom );
    if (cellFrom.getColumnIndex() != cellTo.getColumnIndex() ||
        cellFrom.getRowIndex() != cellTo.getRowIndex()) {
      _sb.append( RANGE_SEPARATOR );
      CellIndex.appendNameA1ForCellIndex( _sb, cellTo );
    }
  }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
      final String name = expressionNodeForCell.getName();
      if (name != null) {
        _stringBuilder.append( name );
      }
      else {
        final CellIndex cellIndex = expressionNodeForCell.getCellIndex();
        _stringBuilder.append( '[' );
        RefFormatter.append( _stringBuilder, cellIndex, _baseCell );
        _stringBuilder.append( ']' );
      }
    }
View Full Code Here
36
37
38
39
40
41
42
43
  }

  @Override
  protected final Object makeCell( Token _cell, Object _baseCell )
  {
    final CellIndex relativeTo = _baseCell != null ? (CellIndex) _baseCell : this.cellIndex;
    return CellRefParser.R1C1.getCellIndexForCanonicalName( _cell.image, relativeTo );
  }
View Full Code Here
56
57
58
59
60
61
62
  protected SpreadsheetExpressionParser( String _exprText, BaseSpreadsheet _workbook, CellRefFormat _cellRefFormat )
  {
    super( _exprText, _cellRefFormat );
    this.workbook = _workbook;
    this.cellIndex = new CellIndex( _workbook, CellAddressImpl.BROKEN_REF, CellAddressImpl.BROKEN_REF, CellAddressImpl.BROKEN_REF );
  }
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
  protected final ExpressionNode makeNamedRangeRef( Token _name )
  {
    final String name = _name.image;
    final CellRange range = parseNamedRef( name );
    if (range instanceof CellIndex) {
      final CellIndex cell = (CellIndex) range;
      return new ExpressionNodeForCell( cell, name );
    }
    else {
      return new ExpressionNodeForRange( range, name );
    }
View Full Code Here
118
119
120
121
122
123
124
125
126
127
128
  @Override
  protected final ExpressionNode makeNodeForReference( Object _reference )
  {
    if (_reference instanceof CellIndex) {
      final CellIndex cell = (CellIndex) _reference;
      return new ExpressionNodeForCell( cell );
    }
    else if (_reference instanceof CellRange) {
      final CellRange range = (CellRange) _reference;
      return new ExpressionNodeForRange( range );
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
    }
    else if (!_allowRanges && node instanceof ExpressionNodeForRange) {
      try {
        final ExpressionNodeForRange nodeForRange = (ExpressionNodeForRange) node;
        final CellRange range = nodeForRange.getRange();
        final CellIndex cell = range.getCellIndexRelativeTo( this.cellIndex );
        _nodeSource.setExpressionNode( new ExpressionNodeForCell( cell, nodeForRange.getName() ) );
      } catch (SpreadsheetException e) {
        throw new InnerParserException( e );
      }
    }
View Full Code Here
42
43
44
45
46
47
48
49
  }

  @Override
  protected Object makeCell( final Token _cell, final Object _baseCell )
  {
    final CellIndex relativeTo = _baseCell != null ? (CellIndex) _baseCell : this.cellIndex;
    return CellRefParser.A1.parseCellA1ODF( _cell.image, relativeTo );
  }
View Full Code Here
255
256
257
258
259
260
261
262
263
264
265
    else if (_exprDef instanceof ExpressionNodeForConstantValue) {
      final ExpressionNodeForConstantValue cst = (ExpressionNodeForConstantValue) _exprDef;
      return new ExpressionNodeForConstantValue( adjustConstantValue( cst.value() ) );
    }
    else if (_exprDef instanceof ExpressionNodeForCell) {
      final CellIndex cell = ((ExpressionNodeForCell) _exprDef).getCellIndex();
      return buildExpressionModelForCell( cell );
    }
    else if (_exprDef instanceof ExpressionNodeForRangeShape) {
      final ExpressionNode expressionNode = _exprDef.arguments().get( 0 );
      final CellRange range;
View Full Code Here
351
352
353
354
355
356
357
358
359
360
361
      super();
      this.parent = _parent;
      this.range = _range;
      this.shaped = _shaped;
      this.stepOutOnly = _stepOutOnly;
      final CellIndex from = range.getFrom();
      final CellIndex to = range.getTo();
      this.sheets = to.getSheetIndex() - from.getSheetIndex() + 1;
      this.rows = to.getRowIndex() - from.getRowIndex() + 1;
      this.cols = to.getColumnIndex() - from.getColumnIndex() + 1;
    }
View Full Code Here
TOP

Related Classes of org.formulacompiler.spreadsheet.internal.CellIndex

  • org.formulacompiler.runtime.internal.spreadsheet.CellAddressImpl
  • org.formulacompiler.spreadsheet.internal.binding.SectionBinding
  • org.formulacompiler.spreadsheet.internal.builder.SpreadsheetBuilderImpl
  • org.formulacompiler.spreadsheet.internal.compiler.SectionModelCompiler
  • org.formulacompiler.spreadsheet.internal.compiler.SectionModelCompiler$RangeExpressionBuilder
  • org.formulacompiler.spreadsheet.internal.compiler.SpreadsheetToModelCompiler
  • org.formulacompiler.spreadsheet.internal.excel.xls.loader.ExcelXLSLoader
  • org.formulacompiler.spreadsheet.internal.excel.xls.saver.ExcelXLSSaver
  • org.formulacompiler.spreadsheet.internal.excel.xlsx.loader.WorksheetParser
  • org.formulacompiler.spreadsheet.internal.excel.xlsx.saver.ExpressionFormatter
    • 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.