@@ 6727-6742 (lines=16) @@ | ||
6724 | break; |
|
6725 | case 0x3A: // 3d reference to cell |
|
6726 | case 0x5A: |
|
6727 | case 0x7A: |
|
6728 | $name = 'tRef3d'; |
|
6729 | $size = 7; |
|
6730 | ||
6731 | try { |
|
6732 | // offset: 1; size: 2; index to REF entry |
|
6733 | $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1)); |
|
6734 | // offset: 3; size: 4; cell address |
|
6735 | $cellAddress = $this->readBIFF8CellAddress(substr($formulaData, 3, 4)); |
|
6736 | ||
6737 | $data = "$sheetRange!$cellAddress"; |
|
6738 | } catch (\PhpSpreadsheet\Exception $e) { |
|
6739 | // deleted sheet reference |
|
6740 | $data = '#REF!'; |
|
6741 | } |
|
6742 | break; |
|
6743 | case 0x3B: // 3d reference to cell range |
|
6744 | case 0x5B: |
|
6745 | case 0x7B: |
|
@@ 6745-6760 (lines=16) @@ | ||
6742 | break; |
|
6743 | case 0x3B: // 3d reference to cell range |
|
6744 | case 0x5B: |
|
6745 | case 0x7B: |
|
6746 | $name = 'tArea3d'; |
|
6747 | $size = 11; |
|
6748 | ||
6749 | try { |
|
6750 | // offset: 1; size: 2; index to REF entry |
|
6751 | $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1)); |
|
6752 | // offset: 3; size: 8; cell address |
|
6753 | $cellRangeAddress = $this->readBIFF8CellRangeAddress(substr($formulaData, 3, 8)); |
|
6754 | ||
6755 | $data = "$sheetRange!$cellRangeAddress"; |
|
6756 | } catch (\PhpSpreadsheet\Exception $e) { |
|
6757 | // deleted sheet reference |
|
6758 | $data = '#REF!'; |
|
6759 | } |
|
6760 | break; |
|
6761 | // Unknown cases // don't know how to deal with |
|
6762 | default: |
|
6763 | throw new Exception('Unrecognized token ' . sprintf('%02X', $id) . ' in formula'); |