|
@@ 4002-4008 (lines=7) @@
|
| 3999 |
|
|
| 4000 |
|
// read STRING record |
| 4001 |
|
$value = $this->readString(); |
| 4002 |
|
} elseif ((ord($recordData[6]) == 1) |
| 4003 |
|
&& (ord($recordData[12]) == 255) |
| 4004 |
|
&& (ord($recordData[13]) == 255)) { |
| 4005 |
|
// Boolean formula. Result is in +2; 0=false, 1=true |
| 4006 |
|
$dataType = DataType::TYPE_BOOL; |
| 4007 |
|
$value = (bool) ord($recordData[8]); |
| 4008 |
|
} elseif ((ord($recordData[6]) == 2) |
| 4009 |
|
&& (ord($recordData[12]) == 255) |
| 4010 |
|
&& (ord($recordData[13]) == 255)) { |
| 4011 |
|
// Error formula. Error code is in +2 |
|
@@ 4014-4020 (lines=7) @@
|
| 4011 |
|
// Error formula. Error code is in +2 |
| 4012 |
|
$dataType = DataType::TYPE_ERROR; |
| 4013 |
|
$value = Xls\ErrorCode::lookup(ord($recordData[8])); |
| 4014 |
|
} elseif ((ord($recordData[6]) == 3) |
| 4015 |
|
&& (ord($recordData[12]) == 255) |
| 4016 |
|
&& (ord($recordData[13]) == 255)) { |
| 4017 |
|
// Formula result is a null string |
| 4018 |
|
$dataType = DataType::TYPE_NULL; |
| 4019 |
|
$value = ''; |
| 4020 |
|
} else { |
| 4021 |
|
// forumla result is a number, first 14 bytes like _NUMBER record |
| 4022 |
|
$dataType = DataType::TYPE_NUMERIC; |
| 4023 |
|
$value = self::extractNumber(substr($recordData, 6, 8)); |
PHPOffice /
PhpSpreadsheet
