package jxl.biff.formula;

import common.Logger;
import jxl.Cell;
import jxl.SheetSettings;
import jxl.biff.CellReferenceHelper;
import jxl.biff.IntegerHelper;

/* JADX INFO: loaded from: classes.dex */
class CellReference3d extends Operand implements ParsedThing {
    static /* synthetic */ Class class$jxl$biff$formula$CellReference3d;
    private static Logger logger;
    private int column;
    private boolean columnRelative;
    private Cell relativeTo;
    private int row;
    private boolean rowRelative;
    private int sheet;
    private ExternalSheet workbook;

    static {
        Class clsClass$ = class$jxl$biff$formula$CellReference3d;
        if (clsClass$ == null) {
            clsClass$ = class$("jxl.biff.formula.CellReference3d");
            class$jxl$biff$formula$CellReference3d = clsClass$;
        }
        logger = Logger.getLogger(clsClass$);
    }

    public CellReference3d(Cell cell, ExternalSheet externalSheet) {
        this.relativeTo = cell;
        this.workbook = externalSheet;
    }

    static /* synthetic */ Class class$(String str) {
        try {
            return Class.forName(str);
        } catch (ClassNotFoundException e) {
            throw new NoClassDefFoundError(e.getMessage());
        }
    }

    @Override // jxl.biff.formula.Operand, jxl.biff.formula.ParseItem
    public void adjustRelativeCellReferences(int i2, int i3) {
        if (this.columnRelative) {
            this.column += i2;
        }
        if (this.rowRelative) {
            this.row += i3;
        }
    }

    @Override // jxl.biff.formula.Operand, jxl.biff.formula.ParseItem
    public void columnInserted(int i2, int i3, boolean z) {
        int i4;
        if (i2 == this.sheet && (i4 = this.column) >= i3) {
            this.column = i4 + 1;
        }
    }

    @Override // jxl.biff.formula.Operand, jxl.biff.formula.ParseItem
    void columnRemoved(int i2, int i3, boolean z) {
        int i4;
        if (i2 == this.sheet && (i4 = this.column) >= i3) {
            this.column = i4 - 1;
        }
    }

    @Override // jxl.biff.formula.ParseItem
    byte[] getBytes() {
        byte[] bArr = new byte[7];
        bArr[0] = Token.REF3D.getCode();
        IntegerHelper.getTwoBytes(this.sheet, bArr, 1);
        IntegerHelper.getTwoBytes(this.row, bArr, 3);
        int i2 = this.column;
        if (this.rowRelative) {
            i2 |= 32768;
        }
        if (this.columnRelative) {
            i2 |= 16384;
        }
        IntegerHelper.getTwoBytes(i2, bArr, 5);
        return bArr;
    }

    public int getColumn() {
        return this.column;
    }

    public int getRow() {
        return this.row;
    }

    @Override // jxl.biff.formula.ParseItem
    public void getString(StringBuffer stringBuffer) {
        CellReferenceHelper.getCellReference(this.sheet, this.column, !this.columnRelative, this.row, !this.rowRelative, this.workbook, stringBuffer);
    }

    @Override // jxl.biff.formula.ParseItem
    void handleImportedCellReferences() {
        setInvalid();
    }

    @Override // jxl.biff.formula.ParsedThing
    public int read(byte[] bArr, int i2) {
        this.sheet = IntegerHelper.getInt(bArr[i2], bArr[i2 + 1]);
        this.row = IntegerHelper.getInt(bArr[i2 + 2], bArr[i2 + 3]);
        int i3 = IntegerHelper.getInt(bArr[i2 + 4], bArr[i2 + 5]);
        this.column = i3 & SheetSettings.DEFAULT_DEFAULT_ROW_HEIGHT;
        this.columnRelative = (i3 & 16384) != 0;
        this.rowRelative = (i3 & 32768) != 0;
        return 6;
    }

    @Override // jxl.biff.formula.Operand, jxl.biff.formula.ParseItem
    void rowInserted(int i2, int i3, boolean z) {
        int i4;
        if (i2 == this.sheet && (i4 = this.row) >= i3) {
            this.row = i4 + 1;
        }
    }

    @Override // jxl.biff.formula.Operand, jxl.biff.formula.ParseItem
    void rowRemoved(int i2, int i3, boolean z) {
        int i4;
        if (i2 == this.sheet && (i4 = this.row) >= i3) {
            this.row = i4 - 1;
        }
    }

    public CellReference3d(String str, ExternalSheet externalSheet) throws FormulaException {
        this.workbook = externalSheet;
        this.columnRelative = true;
        this.rowRelative = true;
        int iIndexOf = str.indexOf(33);
        String strSubstring = str.substring(iIndexOf + 1);
        this.column = CellReferenceHelper.getColumn(strSubstring);
        this.row = CellReferenceHelper.getRow(strSubstring);
        String strSubstring2 = str.substring(0, iIndexOf);
        if (strSubstring2.charAt(0) == '\'' && strSubstring2.charAt(strSubstring2.length() - 1) == '\'') {
            strSubstring2 = strSubstring2.substring(1, strSubstring2.length() - 1);
        }
        int externalSheetIndex = externalSheet.getExternalSheetIndex(strSubstring2);
        this.sheet = externalSheetIndex;
        if (externalSheetIndex < 0) {
            throw new FormulaException(FormulaException.SHEET_REF_NOT_FOUND, strSubstring2);
        }
    }
}