PHPOffice /
PhpSpreadsheet
| @@ 53-64 (lines=12) @@ | ||
| 50 | /** |
|
| 51 | * @dataProvider providerDateTimeTimestampToExcel1900 |
|
| 52 | */ |
|
| 53 | public function testDateTimeTimestampToExcel1900() |
|
| 54 | { |
|
| 55 | $result = call_user_func( |
|
| 56 | array(Date::class,'setExcelCalendar'), |
|
| 57 | Date::CALENDAR_WINDOWS_1900 |
|
| 58 | ); |
|
| 59 | ||
| 60 | $args = func_get_args(); |
|
| 61 | $expectedResult = array_pop($args); |
|
| 62 | $result = call_user_func_array(array(Date::class,'timestampToExcel'), $args); |
|
| 63 | $this->assertEquals($expectedResult, $result, null, 1E-5); |
|
| 64 | } |
|
| 65 | ||
| 66 | public function providerDateTimeTimestampToExcel1900() |
|
| 67 | { |
|
| @@ 74-85 (lines=12) @@ | ||
| 71 | /** |
|
| 72 | * @dataProvider providerDateTimeDateTimeToExcel |
|
| 73 | */ |
|
| 74 | public function testDateTimeDateTimeToExcel() |
|
| 75 | { |
|
| 76 | $result = call_user_func( |
|
| 77 | array(Date::class,'setExcelCalendar'), |
|
| 78 | Date::CALENDAR_WINDOWS_1900 |
|
| 79 | ); |
|
| 80 | ||
| 81 | $args = func_get_args(); |
|
| 82 | $expectedResult = array_pop($args); |
|
| 83 | $result = call_user_func_array(array(Date::class,'dateTimeToExcel'), $args); |
|
| 84 | $this->assertEquals($expectedResult, $result, null, 1E-5); |
|
| 85 | } |
|
| 86 | ||
| 87 | public function providerDateTimeDateTimeToExcel() |
|
| 88 | { |
|
| @@ 95-106 (lines=12) @@ | ||
| 92 | /** |
|
| 93 | * @dataProvider providerDateTimeFormattedPHPToExcel1900 |
|
| 94 | */ |
|
| 95 | public function testDateTimeFormattedPHPToExcel1900() |
|
| 96 | { |
|
| 97 | $result = call_user_func( |
|
| 98 | array(Date::class,'setExcelCalendar'), |
|
| 99 | Date::CALENDAR_WINDOWS_1900 |
|
| 100 | ); |
|
| 101 | ||
| 102 | $args = func_get_args(); |
|
| 103 | $expectedResult = array_pop($args); |
|
| 104 | $result = call_user_func_array(array(Date::class,'formattedPHPToExcel'), $args); |
|
| 105 | $this->assertEquals($expectedResult, $result, null, 1E-5); |
|
| 106 | } |
|
| 107 | ||
| 108 | public function providerDateTimeFormattedPHPToExcel1900() |
|
| 109 | { |
|
| @@ 116-127 (lines=12) @@ | ||
| 113 | /** |
|
| 114 | * @dataProvider providerDateTimeExcelToTimestamp1904 |
|
| 115 | */ |
|
| 116 | public function testDateTimeExcelToTimestamp1904() |
|
| 117 | { |
|
| 118 | $result = call_user_func( |
|
| 119 | array(Date::class,'setExcelCalendar'), |
|
| 120 | Date::CALENDAR_MAC_1904 |
|
| 121 | ); |
|
| 122 | ||
| 123 | $args = func_get_args(); |
|
| 124 | $expectedResult = array_pop($args); |
|
| 125 | $result = call_user_func_array(array(Date::class,'excelToTimestamp'), $args); |
|
| 126 | $this->assertEquals($expectedResult, $result); |
|
| 127 | } |
|
| 128 | ||
| 129 | public function providerDateTimeExcelToTimestamp1904() |
|
| 130 | { |
|
| @@ 137-148 (lines=12) @@ | ||
| 134 | /** |
|
| 135 | * @dataProvider providerDateTimeTimestampToExcel1904 |
|
| 136 | */ |
|
| 137 | public function testDateTimeTimestampToExcel1904() |
|
| 138 | { |
|
| 139 | $result = call_user_func( |
|
| 140 | array(Date::class,'setExcelCalendar'), |
|
| 141 | Date::CALENDAR_MAC_1904 |
|
| 142 | ); |
|
| 143 | ||
| 144 | $args = func_get_args(); |
|
| 145 | $expectedResult = array_pop($args); |
|
| 146 | $result = call_user_func_array(array(Date::class,'timestampToExcel'), $args); |
|
| 147 | $this->assertEquals($expectedResult, $result, null, 1E-5); |
|
| 148 | } |
|
| 149 | ||
| 150 | public function providerDateTimeTimestampToExcel1904() |
|
| 151 | { |
|
| @@ 174-185 (lines=12) @@ | ||
| 171 | /** |
|
| 172 | * @dataProvider providerDateTimeExcelToTimestamp1900Timezone |
|
| 173 | */ |
|
| 174 | public function testDateTimeExcelToTimestamp1900Timezone() |
|
| 175 | { |
|
| 176 | $result = call_user_func( |
|
| 177 | array(Date::class,'setExcelCalendar'), |
|
| 178 | Date::CALENDAR_WINDOWS_1900 |
|
| 179 | ); |
|
| 180 | ||
| 181 | $args = func_get_args(); |
|
| 182 | $expectedResult = array_pop($args); |
|
| 183 | $result = call_user_func_array(array(Date::class,'excelToTimestamp'), $args); |
|
| 184 | $this->assertEquals($expectedResult, $result); |
|
| 185 | } |
|
| 186 | ||
| 187 | public function providerDateTimeExcelToTimestamp1900Timezone() |
|
| 188 | { |
|
