|
@@ 5756-5772 (lines=17) @@
|
| 5753 |
|
|
| 5754 |
|
case 0x3A: // 3d reference to cell |
| 5755 |
|
case 0x5A: |
| 5756 |
|
case 0x7A: |
| 5757 |
|
$name = 'tRef3d'; |
| 5758 |
|
$size = 7; |
| 5759 |
|
|
| 5760 |
|
try { |
| 5761 |
|
// offset: 1; size: 2; index to REF entry |
| 5762 |
|
$sheetRange = $this->_readSheetRangeByRefIndex(self::_GetInt2d($formulaData, 1)); |
| 5763 |
|
// offset: 3; size: 4; cell address |
| 5764 |
|
$cellAddress = $this->_readBIFF8CellAddress(substr($formulaData, 3, 4)); |
| 5765 |
|
|
| 5766 |
|
$data = "$sheetRange!$cellAddress"; |
| 5767 |
|
} catch (Exception $e) { |
| 5768 |
|
// deleted sheet reference |
| 5769 |
|
$data = '#REF!'; |
| 5770 |
|
} |
| 5771 |
|
|
| 5772 |
|
break; |
| 5773 |
|
case 0x3B: // 3d reference to cell range |
| 5774 |
|
case 0x5B: |
| 5775 |
|
case 0x7B: |
|
@@ 5775-5791 (lines=17) @@
|
| 5772 |
|
break; |
| 5773 |
|
case 0x3B: // 3d reference to cell range |
| 5774 |
|
case 0x5B: |
| 5775 |
|
case 0x7B: |
| 5776 |
|
$name = 'tArea3d'; |
| 5777 |
|
$size = 11; |
| 5778 |
|
|
| 5779 |
|
try { |
| 5780 |
|
// offset: 1; size: 2; index to REF entry |
| 5781 |
|
$sheetRange = $this->_readSheetRangeByRefIndex(self::_GetInt2d($formulaData, 1)); |
| 5782 |
|
// offset: 3; size: 8; cell address |
| 5783 |
|
$cellRangeAddress = $this->_readBIFF8CellRangeAddress(substr($formulaData, 3, 8)); |
| 5784 |
|
|
| 5785 |
|
$data = "$sheetRange!$cellRangeAddress"; |
| 5786 |
|
} catch (Exception $e) { |
| 5787 |
|
// deleted sheet reference |
| 5788 |
|
$data = '#REF!'; |
| 5789 |
|
} |
| 5790 |
|
|
| 5791 |
|
break; |
| 5792 |
|
// Unknown cases // don't know how to deal with |
| 5793 |
|
default: |
| 5794 |
|
throw new Exception('Unrecognized token ' . sprintf('%02X', $id) . ' in formula'); |