public function MathTrigTest::providerSUMIF in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/MathTrigTest.php \MathTrigTest::providerSUMIF()

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/MathTrigTest.php, line 497

Class

MathTrigTest

Code

public function providerSUMIF() {
  return array(
    array(
      array(
        array(
          1,
        ),
        array(
          5,
        ),
        array(
          10,
        ),
      ),
      '>=5',
      15,
    ),
    array(
      array(
        array(
          'text',
        ),
        array(
          2,
        ),
      ),
      '=text',
      array(
        array(
          10,
        ),
        array(
          100,
        ),
      ),
      10,
    ),
    array(
      array(
        array(
          '"text with quotes"',
        ),
        array(
          2,
        ),
      ),
      '="text with quotes"',
      array(
        array(
          10,
        ),
        array(
          100,
        ),
      ),
      10,
    ),
    array(
      array(
        array(
          '"text with quotes"',
        ),
        array(
          '',
        ),
      ),
      '>"',
      // Compare to the single characater " (double quote)
      array(
        array(
          10,
        ),
        array(
          100,
        ),
      ),
      10,
    ),
    array(
      array(
        array(
          '',
        ),
        array(
          'anything',
        ),
      ),
      '>"',
      // Compare to the single characater " (double quote)
      array(
        array(
          10,
        ),
        array(
          100,
        ),
      ),
      100,
    ),
  );
}