You are here

ReferenceHelperTest.php in Loft Data Grids 6.2

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/ReferenceHelperTest.php
View source
<?php

class ReferenceHelperTest extends PHPUnit_Framework_TestCase {
  public function setUp() {
    if (!defined('PHPEXCEL_ROOT')) {
      define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
    }
    require_once PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php';
  }
  public function testColumnSort() {
    $columnBase = $columnExpectedResult = array(
      'A',
      'B',
      'Z',
      'AA',
      'AB',
      'AZ',
      'BA',
      'BB',
      'BZ',
      'ZA',
      'ZB',
      'ZZ',
      'AAA',
      'AAB',
      'AAZ',
      'ABA',
      'ABB',
      'ABZ',
      'AZA',
      'AZB',
      'AZZ',
      'BAA',
      'BAB',
      'BAZ',
      'BBA',
      'BBB',
      'BBZ',
      'BZA',
      'BZB',
      'BZZ',
    );
    shuffle($columnBase);
    usort($columnBase, array(
      'PHPExcel_ReferenceHelper',
      'columnSort',
    ));
    foreach ($columnBase as $key => $value) {
      $this
        ->assertEquals($columnExpectedResult[$key], $value);
    }
  }
  public function testColumnReverseSort() {
    $columnBase = $columnExpectedResult = array(
      'A',
      'B',
      'Z',
      'AA',
      'AB',
      'AZ',
      'BA',
      'BB',
      'BZ',
      'ZA',
      'ZB',
      'ZZ',
      'AAA',
      'AAB',
      'AAZ',
      'ABA',
      'ABB',
      'ABZ',
      'AZA',
      'AZB',
      'AZZ',
      'BAA',
      'BAB',
      'BAZ',
      'BBA',
      'BBB',
      'BBZ',
      'BZA',
      'BZB',
      'BZZ',
    );
    shuffle($columnBase);
    $columnExpectedResult = array_reverse($columnExpectedResult);
    usort($columnBase, array(
      'PHPExcel_ReferenceHelper',
      'columnReverseSort',
    ));
    foreach ($columnBase as $key => $value) {
      $this
        ->assertEquals($columnExpectedResult[$key], $value);
    }
  }

}

Classes