Examples of numberOfRows()


Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

  {
    final ArrayDescriptor desc = _range.arrayDescriptor();
    final int iRow = valueToIntOrOne( _rowIndex ) - 1;
    final int iCol = valueToIntOrOne( _colIndex ) - 1;
    int iValue;
    if (iRow < 0 || iRow >= desc.numberOfRows())
      throw new FormulaException( "#VALUE/REF! because row out of range in INDEX" );
    if (iCol < 0 || iCol >= desc.numberOfColumns())
      throw new FormulaException( "#VALUE/REF! because column out of range in INDEX" );
    if (null != _rowIndex && null != _colIndex) {
      iValue = iRow * desc.numberOfColumns() + iCol;
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

  private ExpressionNodeForArrayReference makeVertical( ExpressionNodeForArrayReference _vector )
  {
    final ArrayDescriptor desc = _vector.arrayDescriptor();
    assert desc.numberOfSheets() == 1;
    if (desc.numberOfRows() > 1) {
      assert desc.numberOfColumns() == 1;
      return _vector;
    }
    else {
      assert desc.numberOfRows() == 1;
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

    if (desc.numberOfRows() > 1) {
      assert desc.numberOfColumns() == 1;
      return _vector;
    }
    else {
      assert desc.numberOfRows() == 1;
      final ArrayDescriptor newDesc = new ArrayDescriptor( desc.origin(), new ArrayDescriptor.Point( 1, desc
          .numberOfColumns(), 1 ) );
      final ExpressionNodeForArrayReference newVector = new ExpressionNodeForArrayReference( newDesc );
      newVector.arguments().addAll( _vector.arguments() );
      return newVector;
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

      case CHITEST: {
        if (_fun.cardinality() < 6) {
          final ArrayDescriptor descX = ((ExpressionNodeForArrayReference) _fun.argument( 0 )).arrayDescriptor();
          final int colsX = descX.numberOfColumns();
          final int rowsX = descX.numberOfRows();
          final ArrayDescriptor descY = ((ExpressionNodeForArrayReference) _fun.argument( 1 )).arrayDescriptor();
          final int colsY = descY.numberOfColumns();
          final int rowsY = descY.numberOfRows();
          return fun( CHITEST, _fun.argument( 0 ), _fun.argument( 1 ), cst( colsX, DataType.NUMERIC ), cst( rowsX,
              DataType.NUMERIC ), cst( colsY, DataType.NUMERIC ), cst( rowsY, DataType.NUMERIC ) );
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

          final ArrayDescriptor descX = ((ExpressionNodeForArrayReference) _fun.argument( 0 )).arrayDescriptor();
          final int colsX = descX.numberOfColumns();
          final int rowsX = descX.numberOfRows();
          final ArrayDescriptor descY = ((ExpressionNodeForArrayReference) _fun.argument( 1 )).arrayDescriptor();
          final int colsY = descY.numberOfColumns();
          final int rowsY = descY.numberOfRows();
          return fun( CHITEST, _fun.argument( 0 ), _fun.argument( 1 ), cst( colsX, DataType.NUMERIC ), cst( rowsX,
              DataType.NUMERIC ), cst( colsY, DataType.NUMERIC ), cst( rowsY, DataType.NUMERIC ) );
        }
        break;
      }
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

      }
      case MDETERM: {
        if (_fun.cardinality() < 2) {
          final ArrayDescriptor desc = ((ExpressionNodeForArrayReference) _fun.argument( 0 )).arrayDescriptor();
          final int cols = desc.numberOfColumns();
          final int rows = desc.numberOfRows();
          if (cols != rows) {
            throw new CompilerException.UnsupportedExpression( "MDETERM called with non-square matrix" );
          }
          return fun( MDETERM, _fun.argument( 0 ), cst( cols, DataType.NUMERIC ) );
        }
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

  private ExpressionNode rewriteArrayLookup( ExpressionNodeForFunction _fun )
  {
    final ExpressionNodeForArrayReference array = (ExpressionNodeForArrayReference) _fun.argument( 1 );
    final ArrayDescriptor desc = array.arrayDescriptor();
    final int cols = desc.numberOfColumns();
    final int rows = desc.numberOfRows();
    final Function lookupFun;
    final int index;
    if (cols > rows) {
      lookupFun = HLOOKUP;
      index = rows;
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

      final ExpressionNode matchRefNode = var( matchRefName );
      final ExpressionNode selectorNode = indexNode;
      final ExpressionNode defaultNode = err( "#VALUE/REF! because index is out of range in H/VLOOKUP" );

      final ArrayDescriptor desc = arrayNode.arrayDescriptor();
      final int nArrays = (fun == HLOOKUP) ? desc.numberOfRows() : desc.numberOfColumns();
      final ExpressionNodeForSwitchCase[] caseNodes = new ExpressionNodeForSwitchCase[ nArrays ];
      for (int iArray = 0; iArray < nArrays; iArray++) {
        final ExpressionNode valueArrayNode = getHVLookupSubArray( fun, arrayNode, iArray );
        final ExpressionNode lookupNode = fun( INDEX, valueArrayNode, matchRefNode );
        caseNodes[ iArray ] = new ExpressionNodeForSwitchCase( lookupNode, iArray + 1 );
View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

    if (_fun == HLOOKUP) {
      final int cols = desc.numberOfColumns();
      return _arrayNode.subArray( _index, 1, 0, cols );
    }
    else {
      final int rows = desc.numberOfRows();
      return _arrayNode.subArray( 0, rows, _index, 1 );
    }
  }

View Full Code Here

Examples of org.formulacompiler.compiler.internal.expressions.ArrayDescriptor.numberOfRows()

    final Iterator<ExpressionNode> iElt = _tableElements.iterator();
    final ExpressionNode first = iElt.next();
    if (first instanceof ExpressionNodeForArrayReference) {
      final ExpressionNodeForArrayReference firstArr = (ExpressionNodeForArrayReference) first;
      final ArrayDescriptor firstArrDesc = firstArr.arrayDescriptor();
      final int firstArrRows = firstArrDesc.numberOfRows();
      if (firstArrRows > 1) {
        final ExpressionNodeForArrayReference newFirstArr = new ExpressionNodeForArrayReference(
            new ArrayDescriptor( firstArrDesc, +0, 0, -1, 0 ) );
        stripLabelsFromTableInto( firstArrDesc, firstArr.arguments(), newFirstArr.arguments() );
        _result.add( newFirstArr );
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.