|
@@ 3900-3906 (lines=7) @@
|
| 3897 |
|
|
| 3898 |
|
// read STRING record |
| 3899 |
|
$value = $this->readString(); |
| 3900 |
|
} elseif ((ord($recordData{6}) == 1) |
| 3901 |
|
&& (ord($recordData{12}) == 255) |
| 3902 |
|
&& (ord($recordData{13}) == 255)) { |
| 3903 |
|
// Boolean formula. Result is in +2; 0=false, 1=true |
| 3904 |
|
$dataType = \PhpSpreadsheet\Cell\DataType::TYPE_BOOL; |
| 3905 |
|
$value = (bool) ord($recordData{8}); |
| 3906 |
|
} elseif ((ord($recordData{6}) == 2) |
| 3907 |
|
&& (ord($recordData{12}) == 255) |
| 3908 |
|
&& (ord($recordData{13}) == 255)) { |
| 3909 |
|
// Error formula. Error code is in +2 |
|
@@ 3912-3918 (lines=7) @@
|
| 3909 |
|
// Error formula. Error code is in +2 |
| 3910 |
|
$dataType = \PhpSpreadsheet\Cell\DataType::TYPE_ERROR; |
| 3911 |
|
$value = Excel5\ErrorCode::lookup(ord($recordData{8})); |
| 3912 |
|
} elseif ((ord($recordData{6}) == 3) |
| 3913 |
|
&& (ord($recordData{12}) == 255) |
| 3914 |
|
&& (ord($recordData{13}) == 255)) { |
| 3915 |
|
// Formula result is a null string |
| 3916 |
|
$dataType = \PhpSpreadsheet\Cell\DataType::TYPE_NULL; |
| 3917 |
|
$value = ''; |
| 3918 |
|
} else { |
| 3919 |
|
// forumla result is a number, first 14 bytes like _NUMBER record |
| 3920 |
|
$dataType = \PhpSpreadsheet\Cell\DataType::TYPE_NUMERIC; |
| 3921 |
|
$value = self::extractNumber(substr($recordData, 6, 8)); |
PHPOffice /
PhpSpreadsheet
