@@ 7051-7066 (lines=16) @@ | ||
7048 | break; |
|
7049 | case 0x3A: // 3d reference to cell |
|
7050 | case 0x5A: |
|
7051 | case 0x7A: |
|
7052 | $name = 'tRef3d'; |
|
7053 | $size = 7; |
|
7054 | ||
7055 | try { |
|
7056 | // offset: 1; size: 2; index to REF entry |
|
7057 | $sheetRange = $this->readSheetRangeByRefIndex(self::getUInt2d($formulaData, 1)); |
|
7058 | // offset: 3; size: 4; cell address |
|
7059 | $cellAddress = $this->readBIFF8CellAddress(substr($formulaData, 3, 4)); |
|
7060 | ||
7061 | $data = "$sheetRange!$cellAddress"; |
|
7062 | } catch (PhpSpreadsheetException $e) { |
|
7063 | // deleted sheet reference |
|
7064 | $data = '#REF!'; |
|
7065 | } |
|
7066 | ||
7067 | break; |
|
7068 | case 0x3B: // 3d reference to cell range |
|
7069 | case 0x5B: |
|
@@ 7070-7085 (lines=16) @@ | ||
7067 | break; |
|
7068 | case 0x3B: // 3d reference to cell range |
|
7069 | case 0x5B: |
|
7070 | case 0x7B: |
|
7071 | $name = 'tArea3d'; |
|
7072 | $size = 11; |
|
7073 | ||
7074 | try { |
|
7075 | // offset: 1; size: 2; index to REF entry |
|
7076 | $sheetRange = $this->readSheetRangeByRefIndex(self::getUInt2d($formulaData, 1)); |
|
7077 | // offset: 3; size: 8; cell address |
|
7078 | $cellRangeAddress = $this->readBIFF8CellRangeAddress(substr($formulaData, 3, 8)); |
|
7079 | ||
7080 | $data = "$sheetRange!$cellRangeAddress"; |
|
7081 | } catch (PhpSpreadsheetException $e) { |
|
7082 | // deleted sheet reference |
|
7083 | $data = '#REF!'; |
|
7084 | } |
|
7085 | ||
7086 | break; |
|
7087 | // Unknown cases // don't know how to deal with |
|
7088 | default: |