@@ 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'); |