|
@@ 3863-3869 (lines=7) @@
|
| 3860 |
|
|
| 3861 |
|
// read STRING record |
| 3862 |
|
$value = $this->readString(); |
| 3863 |
|
} elseif ((ord($recordData[6]) == 1) |
| 3864 |
|
&& (ord($recordData[12]) == 255) |
| 3865 |
|
&& (ord($recordData[13]) == 255)) { |
| 3866 |
|
// Boolean formula. Result is in +2; 0=false, 1=true |
| 3867 |
|
$dataType = Cell\DataType::TYPE_BOOL; |
| 3868 |
|
$value = (bool) ord($recordData[8]); |
| 3869 |
|
} elseif ((ord($recordData[6]) == 2) |
| 3870 |
|
&& (ord($recordData[12]) == 255) |
| 3871 |
|
&& (ord($recordData[13]) == 255)) { |
| 3872 |
|
// Error formula. Error code is in +2 |
|
@@ 3875-3881 (lines=7) @@
|
| 3872 |
|
// Error formula. Error code is in +2 |
| 3873 |
|
$dataType = Cell\DataType::TYPE_ERROR; |
| 3874 |
|
$value = Xls\ErrorCode::lookup(ord($recordData[8])); |
| 3875 |
|
} elseif ((ord($recordData[6]) == 3) |
| 3876 |
|
&& (ord($recordData[12]) == 255) |
| 3877 |
|
&& (ord($recordData[13]) == 255)) { |
| 3878 |
|
// Formula result is a null string |
| 3879 |
|
$dataType = Cell\DataType::TYPE_NULL; |
| 3880 |
|
$value = ''; |
| 3881 |
|
} else { |
| 3882 |
|
// forumla result is a number, first 14 bytes like _NUMBER record |
| 3883 |
|
$dataType = Cell\DataType::TYPE_NUMERIC; |
| 3884 |
|
$value = self::extractNumber(substr($recordData, 6, 8)); |
PHPOffice /
PhpSpreadsheet
