mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-08-23 21:08:29 +00:00
Adrien Crivelli
ec4098c8fd
While we might never be able to have 100% of our code strict, we can at the very least do it for all of our tests. This ensures that our tests are using our API with the types as intended by the test author, and not silently be cast to what our API requires.
115 lines
4.4 KiB
PHP
115 lines
4.4 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
|
|
|
|
return [
|
|
[365, '2016-01-01', '2016-12-31', 'YD'],
|
|
[364, '2015-01-01', '2015-12-31', 'YD'],
|
|
[364, '2015-01-01', '2016-12-31', 'YD'],
|
|
[365, '2016-01-01', '2017-12-31', 'YD'],
|
|
[364, '2017-01-01', '2018-12-31', 'YD'],
|
|
[ExcelError::VALUE(), 'ABC', '2007-1-10', 'Y'],
|
|
[ExcelError::VALUE(), '2007-1-1', 'DEF', 'Y'],
|
|
[ExcelError::VALUE(), '2007-1-1', '2007-1-10', 'XYZ'],
|
|
[ExcelError::NAN(), '2007-1-10', '2007-1-1', 'Y'],
|
|
[0, '2007-12-31', '2008-1-10', 'Y'],
|
|
[0, '2007-1-1', '2007-1-10', 'Y'],
|
|
[0, '2007-1-1', '2007-1-10', 'M'],
|
|
[9, '2007-1-1', '2007-1-10', 'D'],
|
|
[0, '2007-1-1', '2007-1-10', 'YM'],
|
|
[9, '2007-1-1', '2007-1-10', 'YD'],
|
|
[9, '2007-1-1', '2007-1-10', 'MD'],
|
|
[0, '2007-1-1', '2007-12-31', 'Y'],
|
|
[11, '2007-1-1', '2007-12-31', 'M'],
|
|
[364, '2007-1-1', '2007-12-31', 'D'],
|
|
[11, '2007-1-1', '2007-12-31', 'YM'],
|
|
[364, '2007-1-1', '2007-12-31', 'YD'],
|
|
[30, '2007-1-1', '2007-12-31', 'MD'],
|
|
[1, '2007-1-1', '2008-7-1', 'Y'],
|
|
[18, '2007-1-1', '2008-7-1', 'M'],
|
|
[547, '2007-1-1', '2008-7-1', 'D'],
|
|
[6, '2007-1-1', '2008-7-1', 'YM'],
|
|
[181, '2007-1-1', '2008-7-1', 'YD'],
|
|
[0, '2007-1-1', '2008-7-1', 'MD'],
|
|
[0, '2007-1-1', '2007-1-31', 'Y'],
|
|
[0, '2007-1-1', '2007-1-31', 'M'],
|
|
[30, '2007-1-1', '2007-1-31', 'D'],
|
|
[0, '2007-1-1', '2007-1-31', 'YM'],
|
|
[30, '2007-1-1', '2007-1-31', 'YD'],
|
|
[30, '2007-1-1', '2007-1-31', 'MD'],
|
|
[0, '2007-1-1', '2007-2-1', 'Y'],
|
|
[1, '2007-1-1', '2007-2-1', 'M'],
|
|
[31, '2007-1-1', '2007-2-1', 'D'],
|
|
[1, '2007-1-1', '2007-2-1', 'YM'],
|
|
[31, '2007-1-1', '2007-2-1', 'YD'],
|
|
[0, '2007-1-1', '2007-2-1', 'MD'],
|
|
[0, '2007-1-1', '2007-2-28', 'Y'],
|
|
[1, '2007-1-1', '2007-2-28', 'M'],
|
|
[58, '2007-1-1', '2007-2-28', 'D'],
|
|
[1, '2007-1-1', '2007-2-28', 'YM'],
|
|
[58, '2007-1-1', '2007-2-28', 'YD'],
|
|
[27, '2007-1-1', '2007-2-28', 'MD'],
|
|
[0, '2007-1-31', '2007-2-1', 'Y'],
|
|
[0, '2007-1-31', '2007-2-1', 'M'],
|
|
[1, '2007-1-31', '2007-2-1', 'D'],
|
|
[0, '2007-1-31', '2007-2-1', 'YM'],
|
|
[1, '2007-1-31', '2007-2-1', 'YD'],
|
|
[1, '2007-1-31', '2007-2-1', 'MD'],
|
|
[0, '2007-1-31', '2007-3-1', 'Y'],
|
|
[1, '2007-1-31', '2007-3-1', 'M'],
|
|
[29, '2007-1-31', '2007-3-1', 'D'],
|
|
[1, '2007-1-31', '2007-3-1', 'YM'],
|
|
[29, '2007-1-31', '2007-3-1', 'YD'],
|
|
[-2, '2007-1-31', '2007-3-1', 'MD'],
|
|
[0, '2007-1-31', '2007-3-31', 'Y'],
|
|
[2, '2007-1-31', '2007-3-31', 'M'],
|
|
[59, '2007-1-31', '2007-3-31', 'D'],
|
|
[2, '2007-1-31', '2007-3-31', 'YM'],
|
|
[59, '2007-1-31', '2007-3-31', 'YD'],
|
|
[0, '2007-1-31', '2007-3-31', 'MD'],
|
|
[0, '2008-1-1', '2008-9-1', 'Y'],
|
|
[8, '2008-1-1', '2008-9-1', 'M'],
|
|
[244, '2008-1-1', '2008-9-1', 'D'],
|
|
[8, '2008-1-1', '2008-9-1', 'YM'],
|
|
[244, '2008-1-1', '2008-9-1', 'YD'],
|
|
[0, '2008-1-1', '2008-9-1', 'MD'],
|
|
[1, '2007-2-1', '2008-4-1', 'Y'],
|
|
[14, '2007-2-1', '2008-4-1', 'M'],
|
|
[425, '2007-2-1', '2008-4-1', 'D'],
|
|
[2, '2007-2-1', '2008-4-1', 'YM'],
|
|
[59, '2007-2-1', '2008-4-1', 'YD'],
|
|
[0, '2007-2-1', '2008-4-1', 'MD'],
|
|
[47, '1960-12-19', '2008-6-28', 'Y'],
|
|
[570, '1960-12-19', '2008-6-28', 'M'],
|
|
[17358, '1960-12-19', '2008-6-28', 'D'],
|
|
[6, '1960-12-19', '2008-6-28', 'YM'],
|
|
[191, '1960-12-19', '2008-6-28', 'YD'],
|
|
[9, '1960-12-19', '2008-6-28', 'MD'],
|
|
[25, '1982-12-7', '2008-6-28', 'Y'],
|
|
[306, '1982-12-7', '2008-6-28', 'M'],
|
|
[9335, '1982-12-7', '2008-6-28', 'D'],
|
|
[6, '1982-12-7', '2008-6-28', 'YM'],
|
|
[203, '1982-12-7', '2008-6-28', 'YD'],
|
|
[21, '1982-12-7', '2008-6-28', 'MD'],
|
|
[2, '2007-12-25', '2010-3-17', 'Y'],
|
|
[26, '2007-12-25', '2010-3-17', 'M'],
|
|
[813, '2007-12-25', '2010-3-17', 'D'],
|
|
[2, '2007-12-25', '2010-3-17', 'YM'],
|
|
[82, '2007-12-25', '2010-3-17', 'YD'],
|
|
[20, '2007-12-25', '2010-3-17', 'MD'],
|
|
[51, '19-12-1960', '26-01-2012', 'Y'],
|
|
[613, '19-12-1960', '26-01-2012', 'M'],
|
|
[18665, '19-12-1960', '26-01-2012', 'D'],
|
|
[1, '19-12-1960', '26-01-2012', 'YM'],
|
|
[11, '19-12-1960', '26-11-1962', 'YM'],
|
|
[38, '19-12-1960', '26-01-2012', 'YD'],
|
|
[7, '19-12-1960', '26-01-2012', 'MD'],
|
|
[0, '19-12-1960', '12-12-1961', 'Y'],
|
|
[1, '19-12-1960', '12-12-1962', 'Y'],
|
|
[51, '19-12-1960', '12-12-2012', 'Y'],
|
|
[0, '1982-12-07', '1982-12-7', 'D'],
|
|
[244, '2008-1-1', '2008-9-1'], // default unit is D
|
|
];
|