PHPOffice /
PhpSpreadsheet
| @@ 628-634 (lines=7) @@ | ||
| 625 | $dateSetting = Functions::getReturnDateType(); |
|
| 626 | Functions::setReturnDateType(Functions::RETURNDATE_EXCEL); |
|
| 627 | ||
| 628 | if (strpos($value, ':') !== false) { |
|
| 629 | $timeValue = DateTime::TIMEVALUE($value); |
|
| 630 | if ($timeValue !== Functions::VALUE()) { |
|
| 631 | Functions::setReturnDateType($dateSetting); |
|
| 632 | return $timeValue; |
|
| 633 | } |
|
| 634 | } |
|
| 635 | $dateValue = DateTime::DATEVALUE($value); |
|
| 636 | if ($dateValue !== Functions::VALUE()) { |
|
| 637 | Functions::setReturnDateType($dateSetting); |
|
| @@ 434-440 (lines=7) @@ | ||
| 431 | return false; |
|
| 432 | } |
|
| 433 | ||
| 434 | if (strpos($dateValue, ':') !== false) { |
|
| 435 | $timeValue = \PHPExcel\Calculation\DateTime::TIMEVALUE($dateValue); |
|
| 436 | if ($timeValue === \PHPExcel\Calculation\Functions::VALUE()) { |
|
| 437 | return false; |
|
| 438 | } |
|
| 439 | $dateValueNew += $timeValue; |
|
| 440 | } |
|
| 441 | return $dateValueNew; |
|
| 442 | } |
|
| 443 | ||
