iliaal / php_excel

PHP Extension interface to the Excel writing/reading library
http://ilia.ws
534 stars 131 forks source link

make test: 1 Fail (FAIL New range related functions [tests/062.phpt) #190

Closed alberttriasmansilla closed 3 years ago

alberttriasmansilla commented 7 years ago

Hi,

I have this test failing; although in the "expect" of the file 062.phpt there are the same values than I run the file 062.php. (EDIT: I see that it is not the same, the second array the hidden is true instead of false)

Content of the file 062.phpt:

--TEST--
New range related functions
--SKIPIF--
<?php if (!extension_loaded("excel")) print "skip"; ?>
--FILE--
<?php
        $x = new ExcelBook();
        $s = $x->addSheet("Sheet 1");

        var_dump($s->setNamedRange("test", 1, 1, 10, 10));
        var_dump($s->setNamedRange("test2", 20, 20, 30, 30));

        var_dump($s->getNamedRange("test"));
        var_dump($s->getNamedRange("nothing"));

        var_dump($s->getIndexRange(1));
        var_dump($s->getIndexRange(100));

        var_dump($s->namedRangeSize());

        var_dump($s->delNamedRange("test"));
        var_dump($s->delNamedRange("test2"));

        echo "OK\n";
?>
--EXPECT--
bool(true)
bool(true)
array(5) {
  ["row_first"]=>
  int(1)
  ["row_last"]=>
  int(1)
  ["col_first"]=>
  int(10)
  ["col_last"]=>
  int(10)
  ["hidden"]=>
  bool(false)
}
bool(false)
array(6) {
  ["row_first"]=>
  int(20)
  ["row_last"]=>
  int(20)
  ["col_first"]=>
  int(30)
  ["col_last"]=>
  int(30)
  ["hidden"]=>
  bool(false)
  ["scope"]=>
  int(-1)
}
bool(false)
int(2)
bool(true)
bool(true)
OK

And my manual execution:

bool(true)
bool(true)
array(5) {
  ["row_first"]=>
  int(1)
  ["row_last"]=>
  int(1)
  ["col_first"]=>
  int(10)
  ["col_last"]=>
  int(10)
  ["hidden"]=>
  bool(false)
}
bool(false)
array(6) {
  ["row_first"]=>
  int(20)
  ["row_last"]=>
  int(20)
  ["col_first"]=>
  int(30)
  ["col_last"]=>
  int(30)
  ["hidden"]=>
  bool(true)
  ["scope"]=>
  int(-1)
}
bool(false)
int(2)
bool(true)
bool(true)
OK

Thank you very much

johmue commented 7 years ago

Can not reproduce with latest libXL 3.8.0 on PHP 7.1 / Win.