1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

<?php

class CellCollectionTest 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 testCacheLastCell()
    {
        $methods = PHPExcel_CachedObjectStorageFactory::getCacheStorageMethods();
        foreach ($methods as $method) {
            PHPExcel_CachedObjectStorageFactory::initialize($method);
            $workbook = new PHPExcel();
            $cells = array('A1', 'A2');
            $worksheet = $workbook->getActiveSheet();
            $worksheet->setCellValue('A1', 1);
            $worksheet->setCellValue('A2', 2);
            $this->assertEquals($cells, $worksheet->getCellCollection(), "Cache method \"$method\".");
            PHPExcel_CachedObjectStorageFactory::finalize();
        }
    }

}