@@ 6640-6655 (lines=16) @@ | ||
6637 | break; |
|
6638 | case 0x3A: // 3d reference to cell |
|
6639 | case 0x5A: |
|
6640 | case 0x7A: |
|
6641 | $name = 'tRef3d'; |
|
6642 | $size = 7; |
|
6643 | ||
6644 | try { |
|
6645 | // offset: 1; size: 2; index to REF entry |
|
6646 | $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1)); |
|
6647 | // offset: 3; size: 4; cell address |
|
6648 | $cellAddress = $this->readBIFF8CellAddress(substr($formulaData, 3, 4)); |
|
6649 | ||
6650 | $data = "$sheetRange!$cellAddress"; |
|
6651 | } catch (PhpSpreadsheetException $e) { |
|
6652 | // deleted sheet reference |
|
6653 | $data = '#REF!'; |
|
6654 | } |
|
6655 | break; |
|
6656 | case 0x3B: // 3d reference to cell range |
|
6657 | case 0x5B: |
|
6658 | case 0x7B: |
|
@@ 6658-6673 (lines=16) @@ | ||
6655 | break; |
|
6656 | case 0x3B: // 3d reference to cell range |
|
6657 | case 0x5B: |
|
6658 | case 0x7B: |
|
6659 | $name = 'tArea3d'; |
|
6660 | $size = 11; |
|
6661 | ||
6662 | try { |
|
6663 | // offset: 1; size: 2; index to REF entry |
|
6664 | $sheetRange = $this->readSheetRangeByRefIndex(self::getInt2d($formulaData, 1)); |
|
6665 | // offset: 3; size: 8; cell address |
|
6666 | $cellRangeAddress = $this->readBIFF8CellRangeAddress(substr($formulaData, 3, 8)); |
|
6667 | ||
6668 | $data = "$sheetRange!$cellRangeAddress"; |
|
6669 | } catch (PhpSpreadsheetException $e) { |
|
6670 | // deleted sheet reference |
|
6671 | $data = '#REF!'; |
|
6672 | } |
|
6673 | break; |
|
6674 | // Unknown cases // don't know how to deal with |
|
6675 | default: |
|
6676 | throw new Exception('Unrecognized token ' . sprintf('%02X', $id) . ' in formula'); |