Package org.zkoss.zss.engine.xel

Examples of org.zkoss.zss.engine.xel.SSErrorXelException

323
324
325
326
327
328
329
330
331
332
333
334
335
   */
  public static Object mathFloor(Object[] args, XelContext ctx){
    final double number = CommonFns.toNumber(args[0]).doubleValue();
    double significance = CommonFns.toNumber(args[1]).doubleValue();
    if(significance == 0) {
      throw new SSErrorXelException(SSError.DIV0);
    } else if(number*significance < 0) {
      throw new SSErrorXelException(SSError.NUM);
    } else {
      double result = significance*Math.floor(number/significance);
      return new Double(result);
    }
  }
View Full Code Here
350
351
352
353
354
355
356
357
358
   * @param n - number 2
   * @return the greatest common divisor
   */
  public static int gcd(int m, int n) {
    if(m < 0 || n < 0) {
      throw new SSErrorXelException(SSError.NUM);
    }
    return MathUtils.gcd(m, n);
    }
View Full Code Here
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
  public static Object mathMdeterm(Object[] args, XelContext ctx){
    double[][] d = UtilFns.toDoubleMatrix(args);
    //not a valid square matrix, return #VALUE!
    if(d.length != d[0].length) 
    {
      throw new SSErrorXelException(SSError.VALUE);
    }
    else
    {
      RealMatrix m = new RealMatrixImpl(d);
      try{
        double result = m.getDeterminant();
        return UtilFns.toDouble15(result, BigDecimal.ROUND_HALF_UP);
      }
      //shouldn't happen to run into this exception. because we already check the matrix if it is square.
      catch(InvalidMatrixException e)
      {
        throw new SSErrorXelException(SSError.VALUE);
      }
    }
  }
View Full Code Here
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
  public static Object mathMinverse(Object[] args, XelContext ctx){
    double array[][] = UtilFns.toDoubleMatrix(args);
    // we don't process non-square matrix.
    if (array.length != array[0].length)
    {
      throw new SSErrorXelException(SSError.VALUE);
    }
    else
    { 
      RealMatrix m = new RealMatrixImpl(array);
      try{
        RealMatrix invM = m.inverse();
        Double result[][] = new Double[invM.getRowDimension()][invM.getColumnDimension()];
        for(int row =0; row < invM.getRowDimension(); row++)
        {
          for(int column =0; column < invM.getColumnDimension(); column++)
          {
            // put the answer to return matrix and use toDouble15() to get around the floating-point arithm conversion problem. 
            result[row][column] = UtilFns.toDouble15(invM.getEntry(row, column), BigDecimal.ROUND_HALF_UP);
          }
        }
        return result;
      }
      // non-invertible square matrix
      catch (InvalidMatrixException e){
        throw new SSErrorXelException(SSError.NUM);
      }
    }
  }
View Full Code Here
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
    double array2[][] = UtilFns.toDoubleMatrix(args[1]);
   
    //if array dimension mismatch, can't do anymore, return #VALUE! error
    if (array1[0].length != array2.length)
    {
      throw new SSErrorXelException(SSError.VALUE);
    }
    else
    {
      RealMatrix m1 = new RealMatrixImpl(array1);
      RealMatrix m2 = new RealMatrixImpl(array2);

      try{
        //now do the really matrix multiplication.
        RealMatrix mmultResult = m1.multiply(m2);
        Double result[][] = new Double[mmultResult.getRowDimension()][mmultResult.getColumnDimension()];
 
        for(int row =0; row < mmultResult.getRowDimension(); row++)
        {
          for(int column =0; column < mmultResult.getColumnDimension(); column++)
          {
            // put the answer to return matrix and use toDouble15() to get around the floating-point arithm conversion problem. 
            result[row][column] = UtilFns.toDouble15(mmultResult.getEntry(row, column), BigDecimal.ROUND_HALF_UP);
          }
        }
        return result;
      }
      //shouldn't happen to run into this exception. because the dimensions had been checked above.
      catch(IllegalArgumentException e){
        throw new SSErrorXelException(SSError.VALUE);
      }
    }
  }
View Full Code Here
536
537
538
539
540
541
542
543
544
545
546
     */
    int n = CommonFns.toNumber(args[0]).intValue();
    int d = CommonFns.toNumber(args[1]).intValue();
   
    if(n == 0)
      throw new SSErrorXelException(SSError.DIV0);
    else{
      int r = Math.abs(n % d);
      if(d>0)
        return UtilFns.validateNumber(r);
      else
View Full Code Here
559
560
561
562
563
564
565
566
567
568
569
    double number = CommonFns.toNumber(args[0]).doubleValue();
    double multiple = CommonFns.toNumber(args[1]).doubleValue();
    //if number and multiple have different sign, MROUND returns #NUM! error.
    if((number > 0 && multiple < 0) || (number < 0 && multiple > 0))
    {
      throw new SSErrorXelException(SSError.NUM);
    }
    else
    {
      if(multiple == 0)//weird result for MSFT Excel compatible.
      {
View Full Code Here
587
588
589
590
591
592
593
594
595
596
597
    int[] number = UtilFns.toIntArray(args);
    int sum = 0;
    int product = 1;
    for(int i = 0; i < number.length; ++i) {
      if(number[i] < 0 || number[i] >= 255) {
        throw new SSErrorXelException(SSError.NUM);
      }
      sum += number[i];
      product *= factorial(number[i]);
    }
    return new Double(factorial(sum)/product);
View Full Code Here
655
656
657
658
659
660
661
662
663
664
   */
  public static Object mathQuotient(Object[] args, XelContext ctx){
    //if denominator is 0, return #DIV/0! for MSFT Excel compatibility.
    if(CommonFns.toNumber(args[1]).doubleValue() == 0)
    {
      throw new SSErrorXelException(SSError.DIV0);
    }
    else
      return new Double(Math.rint(CommonFns.toNumber(args[0]).doubleValue()/CommonFns.toNumber(args[1]).doubleValue()));
  }
View Full Code Here
692
693
694
695
696
697
698
699
700
701
   */
  public static Object mathRandbetween(Object[] args, XelContext ctx){
    double bottom = CommonFns.toNumber(args[0]).doubleValue();
    double top = CommonFns.toNumber(args[1]).doubleValue();
    if(bottom > top) {
      throw new SSErrorXelException(SSError.NUM);
    } else {
      return new Double(Math.floor(bottom + Math.random()*(top - bottom)));     
    }
  }
View Full Code Here
TOP

Related Classes of org.zkoss.zss.engine.xel.SSErrorXelException

  • org.zkoss.zss.engine.fn.DateTimeFns
  • org.zkoss.zss.engine.fn.EngineeringFns
  • org.zkoss.zss.engine.fn.FinancialFns
  • org.zkoss.zss.engine.fn.MathFns
  • org.zkoss.zss.engine.fn.StatFns
  • org.zkoss.zss.engine.fn.TextDataFns
  • org.zkoss.zss.engine.fn.UtilFns
  • org.zkoss.zss.model.impl.AbstractRange
  • org.zkoss.zss.model.impl.RangeRef
  • org.zkoss.zss.model.impl.RangeRefError
    • 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.